CREATE TABLE SensorData (\n id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\n\/\/ MACadd VARCHAR(30) NOT NULL,\n value1 VARCHAR(10),\n value2 VARCHAR(10),\n value3 VARCHAR(10),\n reading_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP\n)<\/code><\/pre>\n\n\n\n\u30c6\u30fc\u30d6\u30eb\u304c\u51fa\u6765\u4e0a\u304c\u3063\u305f\u3089\u3001\u9069\u5f53\u306b\u30c7\u30fc\u30bf\u3092\u5165\u308c\u3066\u307f\u307e\u3059\u3002<\/p>\n\n\n\n
INSERT INTO `SensorData`(`value1`, `value2`, `value3`) VALUES (12.3,23.4,35.3)<\/code><\/pre>\n\n\n\n\u5b9f\u884c\u3092\u62bc\u3059\u3068SQL\u6587\u304c\u5b9f\u884c\u3055\u308c\u3001\u884c\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002\u3053\u3053\u307e\u3067\u78ba\u8a8d\u3057\u305f\u3089\u3001\u6b21\u306fMicroPython\u4e0a\u3067json\u3092\u7528\u3044\u305fPOST\u6587\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
import ujson\nimport urequests\n \n\ndict = {\n \"data_value\":\"12.4\",\n \"temp_value\":\"23.4\",\n \"humi_value\":\"35.2\"\n }\nresponse = urequests.post(\n 'http:\/\/**url**\/postrcv.php',\n data=ujson.dumps(dict).encode(\"utf-8\"),\n headers={'Content-Type': 'application\/json'}\n )\nprint (response.text)<\/pre><\/div>\n\n\n\nMicroPython\u3067\u306fpython\u3067\u4f7f\u7528\u3059\u308bjson\u3068requests\u306e\u982d\u306bu\u3092\u3064\u3051\u308b\u5f62\u306b\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u5f62\u3067post\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n
\u6b21\u306b\u30c7\u30fc\u30bf\u3092\u53d7\u3051\u308bphp\u5074\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
<?php\n\n$in = json_decode(stripslashes(file_get_contents('php:\/\/input')),true);\n$data_value = $in[\"data_value\"];\n$temp_value = $in[\"temp_value\"]; \n$humi_value = $in[\"humi_value\"];\n\n$servername = \"localhost\";\n$dbname = \"esp_data\";\n$username = \"username\";\n$password = \"password\";\n\n$conn = new mysqli($servername, $username, $password, $dbname);\nif ($conn->connect_error) {\n die(\"Connection failed: \" . $conn->connect_error);\n} \n\n$sql=\"INSERT INTO `SensorData`(`value1`, `value2`, `value3`) VALUES ($data_value,$temp_value,$humi_value)\";\nif ($conn->query($sql) === TRUE) {\n echo \"New record created successfully\";\n} \nelse {\n echo \"Error: \" . $sql . \"<br>\" . $conn->error;\n}\n \n$conn->close();\n\n?><\/pre><\/div>\n\n\n\n\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u304b\u3089ampy\u3092\u7528\u3044\u3066\u4e0a\u8a18MicroPython\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u8d70\u3089\u305b\u305f\u7d50\u679c\u304c\u6b21\u3067\u3059\u3002<\/p>\n\n\n\n
C:\\Users\\>ampy -p com4 run c:\\micropython\\posttest.py\nNew record created successfully<\/code><\/pre>\n\n\n\nphpMyAdmin\u3067\u78ba\u8a8d\u3057\u3066\u3082\u65b0\u3057\u3044\u30ec\u30b3\u30fc\u30c9\u304c\u633f\u5165\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/a><\/p>\n\n\n\n\n\n \u7de8\u96c6<\/a> \u30b3\u30d4\u30fc<\/a>![\"\u524a\u9664\"](\"http:\/\/160.16.91.174\/phpmyadmin\/themes\/dot.gif\")
\u524a\u9664<\/a>1712.323.435.32021-02-25 19:35:51<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"\u30bb\u30f3\u30b5\u304b\u3089\u306e\u30c7\u30fc\u30bf\u3082\u3068\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u3001Wi-Fi\u306b\u3064\u306a\u304c\u308a\u3001\uff2e\uff34\uff30\u3067\u6642\u8a08\u306e\u88dc\u6b63\u3082\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002 IoT\u3092\u9032\u3081\u308b\u4e2d\u3067\u5fc5\u8981\u306a\u306e\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u3072\u305f\u3059\u3089\u30c7\u30fc\u30bf\u3092\u653e\u308a\u8fbc\u307f\u3001\u305d\u306e\u4e2d\u3067\u3001\u7570\u5e38\u306e\u3042\u308b\u30c7\u30fc\u30bf\u3092\u3044\u304b\u306b\u65e9\u304f\u898b\u3064\u3051\u51fa … <\/p>\n