{"id":229,"date":"2026-01-06T12:47:47","date_gmt":"2026-01-06T15:47:47","guid":{"rendered":"https:\/\/techsmundo.com.br\/?p=229"},"modified":"2026-01-06T12:47:55","modified_gmt":"2026-01-06T15:47:55","slug":"arduino-mysql-e-php-arduino-gravando-dados-de-temperatura-no-mysql","status":"publish","type":"post","link":"https:\/\/techsmundo.com.br\/?p=229","title":{"rendered":"Arduino, MySQL e PHP: Arduino Gravando Dados de Temperatura no MySQL"},"content":{"rendered":"\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Arduino Mysql e php: Arduino gravando dados Mysql completo\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/Jp2Moh69AOw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>A integra\u00e7\u00e3o entre <strong>Arduino, PHP e MySQL<\/strong> permite criar sistemas completos de <strong>monitoramento e armazenamento de dados<\/strong>, muito utilizados em projetos de IoT, automa\u00e7\u00e3o residencial, ind\u00fastria e pesquisa.<\/p>\n\n\n\n<p>Neste post, voc\u00ea vai aprender como criar um <strong>sistema completo onde o Arduino mede a temperatura e grava os dados em um banco MySQL<\/strong>, utilizando um script PHP como intermedi\u00e1rio.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udfaf Objetivo do Projeto<\/h2>\n\n\n\n<p>Desenvolver um sistema capaz de:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Medir temperatura usando sensor no Arduino<\/li>\n\n\n\n<li>Enviar os dados via rede<\/li>\n\n\n\n<li>Receber informa\u00e7\u00f5es em um script PHP<\/li>\n\n\n\n<li>Armazenar leituras em um banco MySQL<\/li>\n\n\n\n<li>Permitir futuras consultas e gr\u00e1ficos<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\udde0 Arquitetura do Sistema<\/h2>\n\n\n\n<p>O funcionamento ocorre em tr\u00eas etapas:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Arduino<\/strong> l\u00ea a temperatura do sensor<\/li>\n\n\n\n<li><strong>Arduino envia os dados<\/strong> via HTTP<\/li>\n\n\n\n<li><strong>PHP recebe e grava<\/strong> os dados no MySQL<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>Arduino \u2192 PHP \u2192 MySQL\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\uddf0 Componentes Utilizados<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Hardware<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Arduino Uno \/ Mega \/ ESP8266 \/ ESP32<\/li>\n\n\n\n<li>Sensor de temperatura (DHT11, DHT22 ou LM35)<\/li>\n\n\n\n<li>M\u00f3dulo Ethernet ou Wi-Fi<\/li>\n\n\n\n<li>Cabos jumpers<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Software<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Arduino IDE<\/li>\n\n\n\n<li>Servidor Web (Apache ou Nginx)<\/li>\n\n\n\n<li>PHP 7 ou superior<\/li>\n\n\n\n<li>MySQL ou MariaDB<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udf21\ufe0f Leitura da Temperatura no Arduino<\/h2>\n\n\n\n<p>Exemplo usando <strong>sensor DHT11<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#include &lt;DHT.h&gt;\n#define DHTPIN 2\n#define DHTTYPE DHT11\n\nDHT dht(DHTPIN, DHTTYPE);\n\nvoid setup() {\n  Serial.begin(9600);\n  dht.begin();\n}\n\nvoid loop() {\n  float temperatura = dht.readTemperature();\n  Serial.println(temperatura);\n  delay(2000);\n}\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udf10 Enviando Dados do Arduino para o PHP<\/h2>\n\n\n\n<p>O Arduino envia os dados via <strong>requisi\u00e7\u00e3o HTTP GET ou POST<\/strong>.<\/p>\n\n\n\n<p>Exemplo de envio (simplificado):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>http:&#47;&#47;servidor\/salvar.php?temp=25.6\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\uddd1\u200d\ud83d\udcbb Script PHP para Receber os Dados<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n$temperatura = $_GET&#91;'temp'];\n\n$conn = new mysqli(\"localhost\", \"usuario\", \"senha\", \"sensores\");\n\nif ($conn-&gt;connect_error) {\n    die(\"Erro de conex\u00e3o\");\n}\n\n$sql = \"INSERT INTO temperatura (valor, data_hora) VALUES ('$temperatura', NOW())\";\n$conn-&gt;query($sql);\n$conn-&gt;close();\n?&gt;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\uddc4\ufe0f Estrutura da Tabela MySQL<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE temperatura (\n  id INT AUTO_INCREMENT PRIMARY KEY,\n  valor FLOAT,\n  data_hora DATETIME\n);\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2699\ufe0f Boas Pr\u00e1ticas de Seguran\u00e7a<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Validar dados recebidos no PHP<\/li>\n\n\n\n<li>Utilizar <strong>POST<\/strong> ao inv\u00e9s de GET<\/li>\n\n\n\n<li>Criar usu\u00e1rio MySQL com permiss\u00f5es limitadas<\/li>\n\n\n\n<li>Usar HTTPS<\/li>\n\n\n\n<li>Adicionar token de autentica\u00e7\u00e3o<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udcca Visualiza\u00e7\u00e3o dos Dados<\/h2>\n\n\n\n<p>Com os dados gravados no MySQL, \u00e9 poss\u00edvel:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Criar gr\u00e1ficos em PHP<\/li>\n\n\n\n<li>Integrar com dashboards<\/li>\n\n\n\n<li>Exportar dados para CSV<\/li>\n\n\n\n<li>Monitorar temperatura em tempo real<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\ude80 Poss\u00edveis Melhorias<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Gr\u00e1ficos com Chart.js<\/li>\n\n\n\n<li>Dashboard web responsivo<\/li>\n\n\n\n<li>Integra\u00e7\u00e3o com ESP32<\/li>\n\n\n\n<li>Envio de alertas por e-mail<\/li>\n\n\n\n<li>Registro de m\u00faltiplos sensores<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udfed Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Monitoramento ambiental<\/li>\n\n\n\n<li>C\u00e2maras frias<\/li>\n\n\n\n<li>Estufas agr\u00edcolas<\/li>\n\n\n\n<li>Data centers<\/li>\n\n\n\n<li>Projetos acad\u00eamicos<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udccc Conclus\u00e3o<\/h2>\n\n\n\n<p>A combina\u00e7\u00e3o de <strong>Arduino + PHP + MySQL<\/strong> cria uma solu\u00e7\u00e3o robusta para coleta e armazenamento de dados de temperatura.<\/p>\n\n\n\n<p>Esse projeto \u00e9 uma excelente introdu\u00e7\u00e3o ao <strong>IoT<\/strong>, banco de dados e desenvolvimento web, podendo evoluir facilmente para sistemas profissionais.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\ud83c\udf21\ufe0f <strong>Pr\u00f3ximo passo:<\/strong> Dashboard web com gr\u00e1ficos em tempo real<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A integra\u00e7\u00e3o entre Arduino, PHP e MySQL permite criar sistemas completos de monitoramento e armazenamento de dados, muito utilizados em projetos de IoT, automa\u00e7\u00e3o residencial, ind\u00fastria e pesquisa. Neste post, voc\u00ea vai aprender como criar um sistema completo onde o Arduino mede a temperatura e grava os dados em um banco MySQL, utilizando um script [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-229","post","type-post","status-publish","format-standard","hentry","category-arduino-tecnologia"],"_links":{"self":[{"href":"https:\/\/techsmundo.com.br\/index.php?rest_route=\/wp\/v2\/posts\/229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsmundo.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsmundo.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsmundo.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsmundo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=229"}],"version-history":[{"count":1,"href":"https:\/\/techsmundo.com.br\/index.php?rest_route=\/wp\/v2\/posts\/229\/revisions"}],"predecessor-version":[{"id":230,"href":"https:\/\/techsmundo.com.br\/index.php?rest_route=\/wp\/v2\/posts\/229\/revisions\/230"}],"wp:attachment":[{"href":"https:\/\/techsmundo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsmundo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsmundo.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}