{"id":10302,"date":"2023-01-06T10:04:03","date_gmt":"2023-01-06T13:04:03","guid":{"rendered":"https:\/\/ajuda.locaweb.com.br\/?post_type=ht_kb&#038;p=10302"},"modified":"2023-01-16T12:22:06","modified_gmt":"2023-01-16T15:22:06","slug":"como-fazer-um-formulario-php-com-conexao-mysql-hospedagem-de-sites","status":"publish","type":"ht_kb","link":"https:\/\/www.locaweb.com.br\/ajuda\/wiki\/como-fazer-um-formulario-php-com-conexao-mysql-hospedagem-de-sites\/","title":{"rendered":"Como fazer um formul\u00e1rio PHP com conex\u00e3o Mysql &#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\tVeremos neste artigo um exemplo de formul\u00e1rio de contato PHP com a conex\u00e3o 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<h6><strong>Banco de dados<\/strong><\/h6>\n<ul>\n<li>Um dos modos mais usados para acessar o banco de dados, e mais r\u00e1pido sem precisar instalar programas em sua maquina \u00e9 pelo <a href=\"http:\/\/phpmyadmin.locaweb.com.br\" target=\"_blank\" rel=\"noopener noreferrer\">phpmyadmin<\/a>.<\/li>\n<\/ul>\n<h6 id=\"firstHeading\" class=\"firstHeading\"><span dir=\"auto\">Informa\u00e7\u00f5es de acesso ao banco MySQL<\/span><\/h6>\n<div id=\"bodyContent\" class=\"mw-body-content\">\n<div id=\"jump-to-nav\" class=\"mw-jump\"><\/div>\n<\/div>\n<ul>\n<li><strong>IP ou hostname<\/strong>\u00a0\u2013 endere\u00e7o onde o banco de dados est\u00e1 dispon\u00edvel, recomendamos o uso do hostname em vez do IP;<\/li>\n<\/ul>\n<ul>\n<li>Digite o\u00a0<b>usu\u00e1rio<\/b>\u00a0e a\u00a0<b>senha<\/b>\u00a0de acesso \u00e0 base de dados;<\/li>\n<\/ul>\n<ul>\n<li>Em seguida clique no bot\u00e3o\u00a0<b>&#8220;Executar&#8221;<\/b>.<\/li>\n<li>Todo processo para cria\u00e7\u00e3o de um banco de dados est\u00e1 disponivel em nossa documenta\u00e7\u00e3o de ajuda: <a href=\"https:\/\/ajuda.locaweb.com.br\/wiki\/como-instalar-um-banco-de-dados-hospedagem-de-sites\/\" target=\"_blank\" rel=\"noopener noreferrer\">Instalar banco de dados.<\/a><\/li>\n<li>Ap\u00f3s acessar sua base de dados, ser\u00e1 necess\u00e1rio que crie a tabela que ser\u00e1 utilizada pelo formul\u00e1rio:<\/li>\n<\/ul>\n<pre class=\"de1\"><span class=\"kw1\">CREATE<\/span> <span class=\"kw1\">TABLE<\/span> <span class=\"st0\">`clientes`<\/span> <span class=\"br0\">(<\/span>\r\n<span class=\"st0\">`nome`<\/span> <span class=\"kw1\">VARCHAR<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">60<\/span> <span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`email`<\/span> <span class=\"kw1\">VARCHAR<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">60<\/span> <span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`sexo`<\/span> <span class=\"kw1\">VARCHAR<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">10<\/span> <span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`ddd`<\/span> <span class=\"kw1\">INT<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">2<\/span> <span class=\"br0\">)<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`telefone`<\/span> <span class=\"kw1\">INT<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">8<\/span> <span class=\"br0\">)<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`endere\u00e7o`<\/span> <span class=\"kw1\">VARCHAR<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">70<\/span> <span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`cidade`<\/span> <span class=\"kw1\">VARCHAR<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">20<\/span> <span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`estado`<\/span> <span class=\"kw1\">VARCHAR<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">2<\/span> <span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`bairro`<\/span> <span class=\"kw1\">VARCHAR<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">20<\/span> <span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`pa\u00eds`<\/span> <span class=\"kw1\">VARCHAR<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">20<\/span> <span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`login`<\/span> <span class=\"kw1\">VARCHAR<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">12<\/span> <span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`senha`<\/span> <span class=\"kw1\">VARCHAR<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">12<\/span> <span class=\"br0\">)<\/span> <span class=\"kw1\">NOT<\/span> <span class=\"kw1\">NULL<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`news`<\/span> <span class=\"kw1\">VARCHAR<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">8<\/span> <span class=\"br0\">)<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"st0\">`id`<\/span> <span class=\"kw1\">INT<\/span><span class=\"br0\">(<\/span> <span class=\"nu0\">200<\/span> <span class=\"br0\">)<\/span> <span class=\"kw1\">AUTO_INCREMENT<\/span> <span class=\"sy0\">,<\/span>\r\n<span class=\"kw1\">UNIQUE<\/span> <span class=\"br0\">(<\/span>\r\n<span class=\"st0\">`id`<\/span> \r\n<span class=\"br0\">)<\/span>\r\n<span class=\"br0\">)<\/span>;<\/pre>\n<h6>Formul\u00e1rio de contato<\/h6>\n<p>Para cria\u00e7\u00e3o do formul\u00e1rio com conex\u00e3o com o banco ser\u00e1 necess\u00e1rio criar alguns arquivos:<\/p>\n<ul>\n<li><strong>Arquivo HTML<\/strong>: <strong><a href=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2018\/12\/html.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">cadastro.html<\/a><\/strong><\/li>\n<li><strong>Arquivo PHP<\/strong>: <strong><a href=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2018\/12\/php.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">cadastro.php<\/a><\/strong><\/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\tNo arquivo<strong> cadastro.php<\/strong> defina os dados de acesso a sua base 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    \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>Conhe\u00e7a!<\/b><\/span>    \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>Banco de dados Um dos modos mais usados para acessar o banco de dados, e mais r\u00e1pido sem precisar instalar programas em sua maquina \u00e9 pelo phpmyadmin. Informa\u00e7\u00f5es de acesso ao banco MySQL IP ou hostname\u00a0\u2013 endere\u00e7o onde o banco de dados est\u00e1 dispon\u00edvel, recomendamos o uso do hostname em&#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":[418],"class_list":["post-10302","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hospedagem-de-sites","ht_kb_tag-categoriahospedagem"],"_links":{"self":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/10302","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=10302"}],"version-history":[{"count":8,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/10302\/revisions"}],"predecessor-version":[{"id":29360,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/10302\/revisions\/29360"}],"wp:attachment":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/media?parent=10302"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-category?post=10302"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-tag?post=10302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}