{"id":10165,"date":"2023-01-04T11:08:01","date_gmt":"2023-01-04T14:08:01","guid":{"rendered":"https:\/\/ajuda.locaweb.com.br\/?post_type=ht_kb&#038;p=10165"},"modified":"2023-02-01T12:50:39","modified_gmt":"2023-02-01T15:50:39","slug":"como-conectar-um-banco-mysql-atraves-de-script-php","status":"publish","type":"ht_kb","link":"https:\/\/www.locaweb.com.br\/ajuda\/wiki\/como-conectar-um-banco-mysql-atraves-de-script-php\/","title":{"rendered":"Como conectar a um banco MySQL atrav\u00e9s de script PHP &#8211; Hospedagem de Sites"},"content":{"rendered":"    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\"><b>Informa\u00e7\u00e3o!<\/b><\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tVeja neste artigo como realizar a conex\u00e3o de banco de dados via MySQL pelo script PHP.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<ul>\n<li>O c\u00f3digo de programa\u00e7\u00e3o mencionado nesse artigo \u00e9 uma sugest\u00e3o. Contamos com sua compreens\u00e3o para o fato de que a Locaweb n\u00e3o pode se responsabilizar por apresentar mais detalhes a respeito de sua implementa\u00e7\u00e3o e utiliza\u00e7\u00e3o.<\/li>\n<li>Para mais informa\u00e7\u00f5es, sugerimos que entre em contato com o seu desenvolvedor, pois tal conhecimento \u00e9 aberto e de dom\u00ednio de profissionais t\u00e9cnicos.<\/li>\n<\/ul>\n<h6><strong><span id=\"Fun.C3.A7.C3.B5es_do_PHP\" class=\"mw-headline\">Fun\u00e7\u00f5es do PHP<\/span><\/strong><\/h6>\n<ul>\n<li>Existem fun\u00e7\u00f5es no PHP espec\u00edficas para conex\u00e3o ao servidor e ao banco.<\/li>\n<\/ul>\n<div class=\"mw-geshi mw-code mw-content-ltr\" dir=\"ltr\">\n<div class=\"php source-php\">\n<pre class=\"de1\"><span class=\"kw3\">mysql_connect<\/span><span class=\"br0\">(<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> fun\u00e7\u00e3o para conex\u00e3o ao servidor \r\n<span class=\"kw3\">mysql_select_db<\/span><span class=\"br0\">(<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> fun\u00e7\u00e3o para selecionar o banco de dados<\/pre>\n<\/div>\n<\/div>\n<h6><strong>Testando a conex\u00e3o<\/strong><\/h6>\n<div class=\"mw-geshi mw-code mw-content-ltr\" dir=\"ltr\">\n<div class=\"php source-php\">\n<pre class=\"de1\"><span class=\"kw2\">&lt;?php<\/span> \r\n<span class=\"re0\">$conecta<\/span> <span class=\"sy0\">=<\/span> <span class=\"kw3\">mysql_connect<\/span><span class=\"br0\">(<\/span><span class=\"st_h\">'HOST'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'LOGIN'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'SENHA'<\/span><span class=\"br0\">)<\/span> or <span class=\"kw1\">print<\/span> <span class=\"br0\">(<\/span><span class=\"kw3\">mysql_error<\/span><span class=\"br0\">(<\/span><span class=\"br0\">)<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"kw1\">print<\/span> <span class=\"st0\">\"Conex\u00e3o OK!\"<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"kw3\">mysql_close<\/span><span class=\"br0\">(<\/span><span class=\"re0\">$conecta<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"sy1\">?&gt;<\/span><\/pre>\n<ul>\n<li>Host=<b>mysqlxx.seudominio.com.br<\/b>, caso o DNS de seu site n\u00e3o estiver hospedado na Locaweb, pode utilizar o IP do servidor at\u00e9 que voc\u00ea aponte o DNS para nossa rede.<\/li>\n<\/ul>\n<h6><strong><span id=\"Testando_a_sele.C3.A7.C3.A3o\" class=\"mw-headline\">Testando a sele\u00e7\u00e3o<\/span><\/strong><\/h6>\n<\/div>\n<\/div>\n<div>\n<div class=\"mw-geshi mw-code mw-content-ltr\" dir=\"ltr\">\n<div class=\"php source-php\">\n<pre class=\"de1\"><span class=\"kw2\">&lt;?php<\/span> \r\n<span class=\"re0\">$conecta<\/span> <span class=\"sy0\">=<\/span> <span class=\"kw3\">mysql_connect<\/span><span class=\"br0\">(<\/span><span class=\"st_h\">'HOST'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'LOGIN'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'SENHA'<\/span><span class=\"br0\">)<\/span> or <span class=\"kw1\">print<\/span> <span class=\"br0\">(<\/span><span class=\"kw3\">mysql_error<\/span><span class=\"br0\">(<\/span><span class=\"br0\">)<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"kw3\">mysql_select_db<\/span><span class=\"br0\">(<\/span><span class=\"st0\">\"BANCO\"<\/span><span class=\"sy0\">,<\/span> <span class=\"re0\">$conecta<\/span><span class=\"br0\">)<\/span> or <span class=\"kw1\">print<\/span><span class=\"br0\">(<\/span><span class=\"kw3\">mysql_error<\/span><span class=\"br0\">(<\/span><span class=\"br0\">)<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"kw1\">print<\/span> <span class=\"st0\">\"Conex\u00e3o e Sele\u00e7\u00e3o OK!\"<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"kw3\">mysql_close<\/span><span class=\"br0\">(<\/span><span class=\"re0\">$conecta<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"sy1\">?&gt;<\/span><\/pre>\n<h6><strong><span id=\"Trabalhando_com_os_Dados_Presentes_no_Banco\" class=\"mw-headline\">Trabalhando com os Dados Presentes no Banco<\/span><\/strong><\/h6>\n<div class=\"mw-geshi mw-code mw-content-ltr\" dir=\"ltr\">\n<div class=\"php source-php\">\n<pre class=\"de1\"><span class=\"kw3\">mysql_query<\/span><span class=\"br0\">(<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> executa um comando SQL no banco de dados<span class=\"sy0\">.<\/span> \r\n<span class=\"kw3\">mysql_fetch_array<\/span><span class=\"br0\">(<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> retorna linha de consulta at\u00e9 que a condi\u00e7\u00e3o seja falsa<span class=\"sy0\">.<\/span> \r\n<span class=\"kw3\">mysql_free_result<\/span><span class=\"br0\">(<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> libera mem\u00f3ria utilizada<span class=\"sy0\">.<\/span> \r\n<span class=\"kw3\">mysql_close<\/span><span class=\"br0\">(<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> fecha conex\u00e3o com o servidor<span class=\"sy0\">.<\/span><\/pre>\n<ul>\n<li>Usaremos uma fun\u00e7\u00e3o de loop <b>( while(); )<\/b> para demonstrar uma consulta SQL em a\u00e7\u00e3o.<\/li>\n<\/ul>\n    \t\t<div class=\"hts-messages hts-messages--alert  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\"><b>Observa\u00e7\u00e3o!<\/b><\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\t\u00c9 poss\u00edvel utilizar o script abaixo para intera\u00e7\u00e3o com tabela e colunas criadas em nosso exemplo de MySQL.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<pre class=\"de1\"><span class=\"kw2\">&lt;?php<\/span> \r\n<span class=\"re0\">$conecta<\/span> <span class=\"sy0\">=<\/span> <span class=\"kw3\">mysql_connect<\/span><span class=\"br0\">(<\/span><span class=\"st_h\">'HOST'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'LOGIN'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'SENHA'<\/span><span class=\"br0\">)<\/span> or <span class=\"kw1\">print<\/span> <span class=\"br0\">(<\/span><span class=\"kw3\">mysql_error<\/span><span class=\"br0\">(<\/span><span class=\"br0\">)<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"kw3\">mysql_select_db<\/span><span class=\"br0\">(<\/span><span class=\"st_h\">'BANCO'<\/span><span class=\"sy0\">,<\/span> <span class=\"re0\">$conecta<\/span><span class=\"br0\">)<\/span> or <span class=\"kw1\">print<\/span><span class=\"br0\">(<\/span><span class=\"kw3\">mysql_error<\/span><span class=\"br0\">(<\/span><span class=\"br0\">)<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"re0\">$sql<\/span> <span class=\"sy0\">=<\/span> <span class=\"st0\">\"SELECT coluna1, coluna2 FROM tabela\"<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"re0\">$result<\/span> <span class=\"sy0\">=<\/span> <span class=\"kw3\">mysql_query<\/span><span class=\"br0\">(<\/span><span class=\"re0\">$sql<\/span><span class=\"sy0\">,<\/span> <span class=\"re0\">$conecta<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> \r\n\u00a0\r\n<span class=\"coMULTI\">\/* Escreve resultados at\u00e9 que n\u00e3o haja mais linhas na tabela *\/<\/span> \r\n\u00a0\r\n<span class=\"kw1\">while<\/span><span class=\"br0\">(<\/span><span class=\"re0\">$consulta<\/span> <span class=\"sy0\">=<\/span> <span class=\"kw3\">mysql_fetch_array<\/span><span class=\"br0\">(<\/span><span class=\"re0\">$result<\/span><span class=\"br0\">)<\/span><span class=\"br0\">)<\/span> <span class=\"br0\">{<\/span> \r\n   <span class=\"kw1\">print<\/span> <span class=\"st0\">\"Coluna1: <span class=\"es4\">$consulta[coluna1]<\/span> - Coluna2: <span class=\"es4\">$consulta[coluna2]<\/span>&lt;br&gt;\"<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"br0\">}<\/span> \r\n<span class=\"kw3\">mysql_free_result<\/span><span class=\"br0\">(<\/span><span class=\"re0\">$result<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"kw3\">mysql_close<\/span><span class=\"br0\">(<\/span><span class=\"re0\">$conecta<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">;<\/span> \r\n<span class=\"sy1\">?&gt;<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n    \t\t<div class=\"hts-messages hts-messages--info   hts-messages--withicon \"   >\r\n    \t\t\t    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tAproveite e conhe\u00e7a outros produtos da Locaweb, como o VPS Locaweb, <a href=\"https:\/\/www.locaweb.com.br\/vps-locaweb\" target=\"_blank\" rel=\"noopener noreferrer\">clique aqui<\/a> e saiba mais!    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n","protected":false},"excerpt":{"rendered":"<p>O c\u00f3digo de programa\u00e7\u00e3o mencionado nesse artigo \u00e9 uma sugest\u00e3o. Contamos com sua compreens\u00e3o para o fato de que a Locaweb n\u00e3o pode se responsabilizar por apresentar mais detalhes a respeito de sua implementa\u00e7\u00e3o e utiliza\u00e7\u00e3o. Para mais informa\u00e7\u00f5es, sugerimos que entre em contato com o seu desenvolvedor, pois tal&#8230;<\/p>\n","protected":false},"author":6,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[119],"ht-kb-tag":[495,418],"class_list":["post-10165","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hospedagem-de-sites","ht_kb_tag-categoriacloud-e-dedicados","ht_kb_tag-categoriahospedagem"],"_links":{"self":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/10165","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/comments?post=10165"}],"version-history":[{"count":9,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/10165\/revisions"}],"predecessor-version":[{"id":29638,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/10165\/revisions\/29638"}],"wp:attachment":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/media?parent=10165"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-category?post=10165"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-tag?post=10165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}