{"id":279,"date":"2016-02-27T19:29:50","date_gmt":"2016-02-27T19:29:50","guid":{"rendered":"https:\/\/www.kolkataonweb.com\/code-bank\/?p=279"},"modified":"2016-07-18T21:33:46","modified_gmt":"2016-07-18T20:33:46","slug":"arduino-communicate-with-server-part-2","status":"publish","type":"post","link":"https:\/\/www.kolkataonweb.com\/code-bank\/php\/arduino-communicate-with-server-part-2\/","title":{"rendered":"Arduino – Communicate With Server – Part 2 – Server Code for Saving Data"},"content":{"rendered":"

This article shows the server side code for a server which is gathering or sending data by polling method to an Arduino device.<\/p>\n

This method or code is putting less load on the server (compared to socket) but data transmission is slower than socket.<\/p>\n

\n
<?php\r\ndate_default_timezone_set(\"Asia\/Kolkata\");\r\n$conn = mysql_connect(\"localhost\",\"root\",\"**********\");\r\nif(!$conn)\r\n{\r\n\u00a0\u00a0 \u00a0echo \"Error: failed to connect DB Server\";\r\n\u00a0\u00a0 \u00a0die();\r\n}\r\n\r\nif(!mysql_select_db(\"database_name\",$conn))\r\n{\r\n\u00a0\u00a0 \u00a0echo \"Error: failed to connect DB\";\r\n\u00a0\u00a0 \u00a0die();\r\n}\r\n$action = intval(strip_tags($_GET['action']));\r\n\r\nif($action == 1)\r\n{\r\n\u00a0\u00a0 \u00a0$temp = floatval(strip_tags($_GET['temp']));\r\n\u00a0\u00a0 \u00a0$paH = floatval(strip_tags($_GET['paH']));\r\n\u00a0\u00a0 \u00a0$paM = floatval(strip_tags($_GET['paM']));\r\n\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0mysql_query(\"insert into weather (temperature, paH, paM, time) values(\".$temp.\",\".$paH.\",\".$paM.\",\".time().\")\");\r\n\u00a0\u00a0 \u00a0\/\/mysql_query(\"update led_status set led_1 = \".$led_1.\", led_2 = \".$led_2);\r\n\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0echo \"success\";\r\n}\r\nelse\r\n\u00a0\u00a0 \u00a0if($action == 2)\r\n\u00a0\u00a0 \u00a0{\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$output = \"\";\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$result = mysql_query(\"select * from led_status\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$rows = mysql_fetch_array($result);\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0if($rows['led_1'] == 1)\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0{\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $output = \"led_1=1|\";\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0else\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0{\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $output = \"led_1=0|\";\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0if($rows['led_2'] == 1)\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0{\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $output .= \"led_2=1\";\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0else\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0{\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $output .= \"led_2=0\";\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0echo $output;\r\n\u00a0\u00a0 \u00a0}\r\n    mysql_close($conn);\r\n?><\/span><\/pre>\n<\/blockquote>\n
 <\/p>\n
The else<\/em> part ( if($action == 2)<\/em> ) output from the above will be <\/span><\/p>\n
\n
HTTP\/1.1 200 OK\r\nDate: Sun, 14 Feb 2016 20:33:16 GMT\r\nServer: Apache\/2.4.7 (Ubuntu)\r\nX-Powered-By: PHP\/5.5.9-1ubuntu4.14\r\nContent-Length: 15\r\nConnection: close\r\nContent-Type: text\/html\r\n\r\nled_1=0|led_2=1<\/span><\/pre>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"
This article shows the server side code for a server which is gathering or sending data by polling method to an Arduino device. This method or code is putting less load on the server (compared to socket) but data transmission is slower than socket. <?php date_default_timezone_set(“Asia\/Kolkata”); $conn = mysql_connect(“localhost”,”root”,”**********”); if(!$conn) { \u00a0\u00a0 \u00a0echo “Error: failed… Continue reading Arduino – Communicate With Server – Part 2 – Server Code for Saving Data<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,3],"tags":[13,28,32],"class_list":["post-279","post","type-post","status-publish","format-standard","hentry","category-arduino","category-php","tag-arduino","tag-save-data-to-cloud","tag-send-data-to-server","entry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/posts\/279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/comments?post=279"}],"version-history":[{"count":4,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/posts\/279\/revisions"}],"predecessor-version":[{"id":448,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/posts\/279\/revisions\/448"}],"wp:attachment":[{"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/media?parent=279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/categories?post=279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/tags?post=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}