Universidad Tecnológica de Tijuana
Tecnologías de Información
Electrónica para IdC Lab exp #18
Pág. 1/5
Lab Experiment #18. PHP TCP Server that receives JSON
messages and stores data to MySQL
Objective
The student will extend the previous PHP TCP server code where after extracting the data in
the JSON, the software will connect to a MySQL database and will insert the node ID, the
message sequence number and the Celsius temperature data into a predefined table.
Material
PC or Laptop with XAMPP (Apache-PHP-MySQL)
PHPmyAdmin working on your system
TCPClientServer freeware tool installed in your system
Arduino-ESP01 and LM35 and IDE (from the previous experiment)
Lab experiment steps
1. You can save the previous script to another name like for example
TCP_server1mysql.php, so you can add the code as shown at the end of this
document.
2. Also create or edit another Batch file as follows. I am calling it Tm.bat:
Fig. 1. Tm.bat executes DOS commands to simplify running the TCP_server1mysql script.
3. For this experiment you have to create and configure in your MySQL system the
following database and user:
$database="arduinotest";
$username="userTest";
$password="userTestpass";
