{"id":1226,"date":"2018-11-18T14:19:29","date_gmt":"2018-11-18T05:19:29","guid":{"rendered":"http:\/\/kats-eye.net\/info\/?p=1226"},"modified":"2020-01-19T08:45:19","modified_gmt":"2020-01-18T23:45:19","slug":"espr-adt7410","status":"publish","type":"post","link":"https:\/\/kats-eye.net\/info\/2018\/11\/18\/espr-adt7410\/","title":{"rendered":"ESPr Developer\u3092\u4f7f\u3063\u3066\u3001\u6e29\u5ea6\u3092\u6e2c\u5b9a\u3057\u3001\u30b5\u30fc\u30d0\u30fc\u4e0a\u306eSQLite\u30d5\u30a1\u30a4\u30eb\u306b\u8a18\u9332\u3057\u3066\u307f\u308b"},"content":{"rendered":"

 <\/p>\n\n\n\n
<\/td>\n<\/td>\n\u6982\u00a0 \u8981<\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

ESPr Developer\u304b\u3089\u3001I2<\/sup>C\u63a5\u7d9a\u3067\u6e29\u5ea6\u30bb\u30f3\u30b5\u30fc\uff08ADT7410\uff09\u3092\u4f7f\u3063\u3066\u6e29\u5ea6\u6e2c\u5b9a\u3057\u3001\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u4e0a\u306ePHP\u30d7\u30ed\u30b0\u30e9\u30e0\u306b\u4e00\u5b9a\u6642\u9593\u9593\u9694\u3067\u6e2c\u5b9a\u7d50\u679c\u3092\u9001\u4fe1\u3057\u307e\u3059\u3002PHP\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u30c7\u30fc\u30bf\u3092\u53d7\u4fe1\u3057\u305f\u90fd\u5ea6\u3001SQLite\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u8fbc\u307f\u307e\u3059\u3002\uff08SQLite\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u51e6\u7406\u306b\u3064\u3044\u3066\u306f\u5148\u56de\u6295\u7a3f\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u53c2\u8003\u306b\u3057\u3066\u307f\u3066\u4e0b\u3055\u3044\u3002\uff09\u3000\u4eca\u56de\u306f\u3053\u306e\u69d8\u306b\u3057\u3066\u66f8\u304d\u8fbc\u307e\u308c\u305f\u6e29\u5ea6\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u7d4c\u7531\u3067\u30d6\u30e9\u30a6\u30b6\u30fc\u4e0a\u3067\u898b\u308b\u3068\u3053\u308d\u307e\u3067\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3059\u3002
\n\u5c1a\u3001SQLite\u51e6\u7406\u306b\u3064\u3044\u3066\u306f\u3001\u4e0b\u8a18\u3082\u53c2\u8003\u306b\u3057\u3066\u307f\u3066\u4e0b\u3055\u3044\u3002
\n[https:\/\/kats-eye.net\/info\/2018\/11\/13\/php-sqlite\/<\/a>]<\/p>\n

 <\/p>\n\n\n\n
<\/td>\n<\/td>\n\u914d\u7dda\u63a5\u7d9a<\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4eca\u56de\u306e\u78ba\u8a8d\u306f\u3001\u3053\u308c\u307e\u3067\u6295\u7a3f\u3057\u305f\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u30c0\u30a4\u30b9\u3068PHP\u306b\u3088\u308bSQLite\u66f8\u304d\u8fbc\u307f\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3059\u3002\u5168\u4f53\u69cb\u6210\u30a4\u30e1\u30fc\u30b8\u306f\u305d\u3061\u3089\u3092\u53c2\u8003\u306b\u3057\u3066\u4e0b\u3055\u3044\u3002\u914d\u7dda\u63a5\u7d9a\u3082\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u30c0\u30a4\u30b9\u3067\u4f7f\u7528\u3057\u305f\u57fa\u677f\u914d\u7dda\u306b\u4e0b\u306e\u5199\u771f\u306e\u901a\u308a\u3001\u2464 I2<\/sup>C\u63a5\u7d9a\u6e29\u5ea6\u30bb\u30f3\u30b5\u30fc\uff08ADT7410\uff09\u3092\u8ffd\u52a0\u914d\u7dda\u3057\u3066\u3044\u307e\u3059\u3002
\n\"\"<\/p>\n

\u5b9f\u969b\u306b\u914d\u7dda\u3057\u305f\u5199\u771f\u306f\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002\u5199\u771f\u4e0a\u306e\u4e2d\u592e\uff08\u3084\u3084\u53f3\uff09\u306b\u6e29\u5ea6\u30bb\u30f3\u30b5\u30fc\u3092\u63a5\u7d9a\u3057\u3066\u3044\u307e\u3059\u3002\u72ed\u3044\u9818\u57df\u3067\u3059\u304c\u3001\u30d4\u30f3\u30bd\u30b1\u30c3\u30c8\u3092\u306f\u3093\u3060\u4ed8\u3051\u3067\u304d\u305f\u306e\u3067\u3001\u30b8\u30e3\u30f3\u30d1\u30fc\u7dda\u3067\u63a5\u7d9a\u3057\u3066\u3044\u307e\u3059\u3002
\n\"\"<\/p>\n\n\n\n
<\/td>\n<\/td>\n\u30d7\u30ed\u30b0\u30e9\u30e0<\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uff08\uff11\uff09ESPr Developer\u30d7\u30ed\u30b0\u30e9\u30e0<\/span><\/span>
\n\u57fa\u672c\u7684\u306b\u306f\u3001\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u30c0\u30a4\u30b9\uff08\u30b5\u30a4\u30b3\u30ed\uff09\u7528\u30d7\u30ed\u30b0\u30e9\u30e0\u306b\u6e29\u5ea6\u30bb\u30f3\u30b5\u30fc\u306e\u5024\u3092\u6e2c\u5b9a\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u8ffd\u52a0\u3057\u3066\u3044\u307e\u3059\u3002\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u30c0\u30a4\u30b9\u3067\u306f\u3001\u52a0\u901f\u5ea6\u30bb\u30f3\u30b5\u30fc\u306e\u6e2c\u5b9a\u5024\u3092\u30b5\u30a4\u30b3\u30ed\u306e\u76ee\u306b\u5909\u63db\u3057\u3066\u30b5\u30fc\u30d0\u30fc\u306b\u9001\u4fe1\u3057\u3066\u3044\u307e\u3057\u305f\u304c\u3001\u4eca\u56de\u306f\u30b5\u30a4\u30b3\u30ed\u306e\u76ee\u306e\u4ee3\u308f\u308a\u306b\u6e29\u5ea6\u6e2c\u5b9a\u30c7\u30fc\u30bf\u3092\u9001\u4fe1\u3057\u307e\u3059\u3002\u52a0\u901f\u5ea6\u30bb\u30f3\u30b5\u30fc\u6e2c\u5b9a\u95a2\u9023\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u3001\u4eca\u56de\u95a2\u4fc2\u3042\u308a\u307e\u305b\u3093\u304c\u3001\u307e\u305f\u9055\u3046\u76ee\u7684\u3067\u4f7f\u3046\u3053\u3068\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u306e\u3067\u3001\u57fa\u672c\u7684\u306b\u306f\u6b8b\u3057\u3066\u3044\u307e\u3059\u3002
\n\u884c\u756a\uff12\uff14\uff5e\uff16\uff16\u304c\u4e3b\u306a\u8ffd\u52a0\u3057\u305f\u6e29\u5ea6\u30bb\u30f3\u30b5\u30fc\u95a2\u9023\u306e\u30b3\u30fc\u30c9\u3067\u3059\u3002Arduino\u3067\u540c\u3058\u30bb\u30f3\u30b5\u30fc\u63a5\u7d9a\u3092\u884c\u3063\u3066\u304a\u308a\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u3082\u540c\u3058\u3067\u3059\u3002\u884c\u756a\uff11\uff15\uff11\u3067\u521d\u671f\u5316\u306e\u70ba\u306e\u95a2\u6570\u3092\u547c\u3073\u51fa\u3057\u3066\u3044\u307e\u3059\u3002
\n\u884c\u756a\uff11\uff17\uff12\uff5e\uff12\uff12\uff19\u304c\u7e70\u308a\u8fd4\u3057\u30eb\u30fc\u30d7\u306b\u306a\u3063\u3066\u304a\u308a\u3001\u6e29\u5ea6\u6e2c\u5b9a\u3092\u884c\u3044\u3001\u30b5\u30fc\u30d0\u30fc\u306b\u30c7\u30fc\u30bf\u9001\u4fe1\u3059\u308b\u51e6\u7406\u3092\u7e70\u308a\u8fd4\u3057\u307e\u3059\u3002
\n\u884c\u756a\uff11\uff17\uff13\u3067\u6e29\u5ea6\u6e2c\u5b9a\u3092\u884c\u3044\u3001\u305d\u306e\u7d50\u679c\u3092\u884c\u756a\uff11\uff17\uff17\u3067\u5909\u6570body\u306b\u683c\u7d0d\u3057\u3001\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u30c0\u30a4\u30b9\u3068\u540c\u3058\u3088\u3046\u306b\u4e00\u9023\u306e\u9001\u4fe1\u51e6\u7406\u3092\u884c\u3044\u307e\u3059\u3002\u884c\u756a\uff12\uff12\uff18\u3067\u306f\u3001\u7d04\uff15\u5206\uff08=5*60*1000\uff09\u9593\u51e6\u7406\u3092\u9045\u5ef6\u3055\u305b\u308b\u306e\u3067\u3001\u304a\u3088\u305d\uff15\u5206\u306b\uff11\u56de\u30c7\u30fc\u30bf\u9001\u4fe1\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n

#include <ESP8266WiFi.h>\r\n#include <Wire.h>\r\n\r\n\/\/ WIFI\u95a2\u9023\r\nconst char* ssid = \"\uff71\uff78\uff7e\uff7d\uff8e\uff9f\uff72\uff9d\uff84SSID\";               \/\/ \u63a5\u7d9a\u30a2\u30af\u30bb\u30b9\u30dd\u30a4\u30f3\u30c8\u306eSSID         \r\nconst char* password = \"\uff71\uff78\uff7e\uff7d\uff8e\uff9f\uff72\uff9d\uff84\uff8a\uff9f\uff7d\uff9c\uff70\uff84\uff9e\";         \/\/ \u63a5\u7d9a\u30a2\u30af\u30bb\u30b9\u30dd\u30a4\u30f3\u30c8\u306e\u30d1\u30b9\u30ef\u30fc\u30c9   \r\nconst int httpPort = 80 ;                       \/\/ \u30dd\u30fc\u30c8\u756a\u53f7\u6307\u5b9a\r\nconst char* host = \"\u63a5\u7d9a\uff7b\uff70\uff8a\uff9e\uff70\uff84\uff9e\uff92\uff72\uff9d\";              \/\/ \u63a5\u7d9a\u30b5\u30fc\u30d0\u30fc\u30c9\u30e1\u30a4\u30f3\u540d\r\nconst char* path = \"\uff7b\uff70\uff8a\uff9e\uff70\u5074\uff8c\uff9f\uff9b\uff78\uff9e\uff97\uff91Path\";          \/\/ \u547c\u3073\u51fa\u3059\u30d7\u30ed\u30b0\u30e9\u30e0\u540d\r\nconst int s_p = 4;                             \r\nint loopCnt=0;\r\n\r\nString body = \"\";\r\nString rtn =\"\";\r\n\r\n\/\/ I2C-\u52a0\u901f\u5ea6\u30bb\u30f3\u30b5\u30fc(MMA8451)\r\n#define DVC_ADRS 0x1D                           \/\/ \u30c7\u30d0\u30a4\u30b9\u30a2\u30c9\u30ec\u30b9\r\n#define GRAV_E       (9.80665F)                 \/\/ \u6a19\u6e96\u91cd\u529b\u52a0\u901f\u5ea6\r\n\r\nuint16_t x_r , y_r , z_r ;                      \/\/ XYZ 14bit\u30c7\u30fc\u30bf\r\nlong int x_v , y_v , z_v ;                      \/\/ XYZ \u6570\u5b57\r\nfloat x_g , y_g , z_g ;                         \/\/ XYZ \u89d2\u52a0\u901f\u5ea6\r\n\r\n\/\/ \u2606 ADT7410 \u5b9a\u6570\u30fb\u5909\u6570\r\n#define DVC_ADT7410 0x48                        \/\/ \u6e29\u5ea6\uff7e\uff9d\uff7b(ADT7410)\uff71\uff84\uff9e\uff9a\uff7d\uff08\u5916\u90e8\u8a2d\u5b9a\uff09\r\nuint16_t g_md = 0x40 ; \r\nuint16_t g_rs = 0x00 ;\r\nfloat r_t ;\r\n \r\n\/\/ \u2606 \u6e29\u5ea6\uff7e\uff9d\uff7b\uff0d(ADT7410)\u521d\u671f\u5316\r\nvoid ADT7410_INIT(){\r\n  Wire.beginTransmission(DVC_ADT7410);         \/\/ \u63a5\u7d9a\u958b\u59cb\r\n  Wire.write(0x03);                            \/\/ Configuration\u30a2\u30c9\u30ec\u30b9\u6307\u5b9a\r\n  Wire.write(g_md | g_rs);                     \/\/ \u64cd\u4f5c\u30e2\u30fc\u30c9\u3068\u5206\u89e3\u80fd\u6307\u5b9a\r\n  Wire.endTransmission();                      \/\/ \u63a5\u7d9a\u7d42\u4e86\r\n}\r\n \r\n\/\/ \u2606 \u6e29\u5ea6\uff7e\uff9d\uff7b\uff0d(ADT7410)\u30c7\u30fc\u30bf\u8aad\u307f\u53d6\u308a\r\nfloat rd_dat_ADT7410(void) {\r\n    uint16_t ui_val ; long int in_val ; float fl_tmp ;\r\n \r\n    Wire.beginTransmission(DVC_ADT7410);       \/\/ \u63a5\u7d9a\u958b\u59cb\r\n    Wire.write(0x00);                          \/\/ \u8aad\u8fbc\u958b\u59cb\u30a2\u30c9\u30ec\u30b9\u6307\u5b9a\r\n    Wire.endTransmission(false);               \/\/ \u9001\u4fe1\u5b8c\u4e86\uff08\u63a5\u7d9a\u7dad\u6301\uff09\r\n    \r\n    Wire.requestFrom(DVC_ADT7410 , 2);         \/\/ \uff12\u30d0\u30a4\u30c8\u8981\u6c42\r\n    ui_val = (uint16_t)Wire.read() << 8 ;      \/\/ \u30c7\u30fc\u30bf\u306e\u8aad\u307f\u51fa\u3057(\u4e0a\u4f4d)\r\n    ui_val |= Wire.read();                     \/\/ \u30c7\u30fc\u30bf\u306e\u8aad\u307f\u51fa\u3057(\u4e0b\u4f4d)\r\n \r\n    if (g_rs == 0x80){                         \/\/ \u6e2c\u5b9a\u30ec\u30f3\u30b8\u306b\u3088\u308b\u51e6\u7406\u9078\u629e\r\n        in_val = (long int)ui_val;\r\n        if(ui_val & 0x8000) {                  \/\/ \u7b26\u53f7\u5224\u5b9a\r\n            in_val = in_val - 65536 ;\r\n        }\r\n        fl_tmp = (float)in_val \/ 128.0 ;\r\n        \r\n    }else{\r\n        ui_val >>= 3 ;\r\n        in_val = (long int)ui_val;\r\n        if(ui_val & 0x1000) {                  \/\/ \u7b26\u53f7\u5224\u5b9a\r\n            in_val = in_val - 8192 ;\r\n        }\r\n        fl_tmp = (float)in_val \/ 16.0 ;\r\n    }\r\n     return fl_tmp ;\r\n}\r\n\r\n \r\n\/\/ \u2460\u901a\u4fe1\u958b\u59cb\u3001\u30c7\u30d0\u30a4\u30b9\u521d\u671f\u5316\r\nbool DVC_INIT(uint8_t i2caddr){\r\n    Wire.begin(12,14);                          \/\/ \u63a5\u7d9a\u958b\u59cb\r\n  \r\n    wrt_reg(0x2B, 0x40);                        \/\/ DEVICE RESET ENABLED\r\n    while (read_reg(0x2B) & 0x40);              \/\/ \u30c7\u30d0\u30a4\u30b9\u30ea\u30bb\u30c3\u30c8\u5f85\u3061\r\n    wrt_reg(0x0E , 0x01);                       \/\/ RANGE \u8a2d\u5b9a\r\n  \r\n    wrt_reg(0x2B, 0x02);                        \/\/ PowerMode\uff08 0x00:normal,0x01:Low Noise Low Power,0x02:High Resolution, 0x03:Low Power)\r\n    wrt_reg(0x2D, 0x01);                        \/\/ INT_EN_DRDY\r\n    wrt_reg(0x2E, 0x01);                        \/\/ INT_CFG_DRDY\r\n\r\n    wrt_reg(0x11, 0x40);                        \/\/ PL_EN\r\n    wrt_reg(0x2A, 0x01 | 0x04);                 \/\/ ACTIVE , LNOISE\r\n    return true;   \r\n}\r\n\r\n\/\/ \u2461\u6307\u5b9a\u30ec\u30b8\u30b9\u30bf\u306b\u30c7\u30fc\u30bf\u66f8\u304d\u8fbc\u307f\r\nvoid wrt_reg(uint8_t reg, uint8_t value) {\r\n    Wire.beginTransmission(DVC_ADRS);           \/\/ \u30c7\u30d0\u30a4\u30b9\u6307\u5b9a\u3001\u901a\u4fe1\u958b\u59cb\r\n    Wire.write((uint8_t)reg);                   \/\/ \u30ec\u30b8\u30b9\u30bf\u6307\u5b9a\r\n    Wire.write((uint8_t)(value));               \/\/ \u30c7\u30fc\u30bf\u66f8\u8fbc\r\n    Wire.endTransmission();                     \/\/ \u9001\u4fe1\u5b8c\u4e86\r\n}\r\n\r\n\/\/ \u2462\u6307\u5b9a\u30ec\u30b8\u30b9\u30bf\u304b\u3089\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u51fa\u3057\r\nuint8_t read_reg(uint8_t reg) {\r\n    Wire.beginTransmission(DVC_ADRS);           \/\/ \u9001\u4fe1\u51e6\u7406\u958b\u59cb\r\n    Wire.write(reg);                            \/\/ \u30ec\u30b8\u30b9\u30bf\u6307\u5b9a\r\n    Wire.endTransmission(false);                \/\/ \u9001\u4fe1\u5b8c\u4e86(\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u7dad\u6301)\r\n    Wire.requestFrom(DVC_ADRS, 1);              \/\/ 1byte\u30c7\u30fc\u30bf\u306b\u8981\u6c42\r\n\r\n    if (! Wire.available()) return -1;          \/\/ \u30c7\u30fc\u30bf\u6709\u7121\u5224\u5b9a\r\n    return (Wire.read());                       \/\/ 1byte\u30c7\u30fc\u30bf  \r\n}\r\n\r\n\/\/ \u2463\u30c7\u30fc\u30bf\u53d6\u5f97\u3001\u5909\u63db\r\nvoid read_data(void) {\r\n    Wire.beginTransmission(DVC_ADRS);           \/\/ \u9001\u4fe1\u51e6\u7406\u958b\u59cb\r\n    Wire.write(0x01);                           \/\/ \u30a2\u30c9\u30ec\u30b9\u6307\u5b9a\r\n    Wire.endTransmission(false);                \/\/ \u9001\u4fe1\u5b8c\u4e86(\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u7dad\u6301)\r\n    Wire.requestFrom(DVC_ADRS, 6);              \/\/ 6byte\u30c7\u30fc\u30bf\u8981\u6c42\r\n                                                \/\/\r\n    \/\/ \u30c7\u30fc\u30bf\u53d6\u5f97\u3001\u5909\u63db\r\n    x_r = Wire.read() ; x_r <<= 8 ; x_r |= Wire.read() ; x_r >>= 2;\r\n    y_r = Wire.read() ; y_r <<= 8 ; y_r |= Wire.read() ; y_r >>= 2;\r\n    z_r = Wire.read() ; z_r <<= 8 ; z_r |= Wire.read() ; z_r >>= 2;\r\n\r\n    x_v = (long int)x_r ; y_v = (long int)y_r ; z_v = (long int)z_r ;    \r\n\r\n    \/\/ \u30de\u30a4\u30ca\u30b9\u5024\u5909\u63db\r\n    if(x_r & 0x2000) x_v = x_v - 16384 ;        \r\n    if(y_r & 0x2000) y_v = y_v - 16384 ;\r\n    if(z_r & 0x2000) z_v = z_v - 16384 ;\r\n \r\n    \/\/ \u30b9\u30b1\u30fc\u30eb\u30ec\u30f3\u30b8\u3092\u53d6\u5f97\r\n    uint8_t range = read_reg(0x0E) & 0x03;\r\n    uint16_t div_p = 1;\r\n\r\n    \/\/ \u52a0\u901f\u5ea6\u5909\u63db\u4fc2\u6570\uff08\u6e2c\u5b9a\u30ec\u30f3\u30b8\u306b\u3088\u308a\u7570\u306a\u308b\uff09\r\n    if (range == 0x02) div_p = 1024 ; \r\n    if (range == 0x01) div_p = 2048 ;\r\n    if (range == 0x00) div_p = 4096 ;\r\n    x_g = (float)x_v * GRAV_E \/ div_p ; \r\n    y_g = (float)y_v * GRAV_E \/ div_p ; \r\n    z_g = (float)z_v * GRAV_E \/ div_p ;\r\n}\r\n\r\n\/\/ \u2464\u6700\u521d\u306b\uff11\u56de\u3060\u3051\u884c\u3046\u51e6\u7406\r\nvoid setup() {\r\n    Serial.begin(115200);\r\n    \/\/ \u30c7\u30d0\u30a4\u30b9\u30a2\u30c9\u30ec\u30b9\u6307\u5b9a\u3057\u3001\u521d\u671f\u8a2d\u5b9a\r\n    if(!DVC_INIT(DVC_ADRS))  {\r\n        Serial.println(\"-----\");\r\n        while (1);\r\n    }\r\n                                            \r\n    uint8_t reg1 = read_reg(0x2A);              \/\/ \u5143\u8a2d\u5b9a\u78ba\u8a8d\r\n    wrt_reg(0x2A, 0x00);                        \/\/ StandByMode\r\n    wrt_reg(0x0E, 0x00 & 0x3);                  \/\/ Set Range( 0x00:2g , 0x01:4g , 0x02:8g , 0x03:reserved )\r\n    wrt_reg(0x2A, reg1 | 0x01);                 \/\/ ActiveMode\r\n\r\n    ADT7410_INIT();                             \/\/ \u2606 \u6e29\u5ea6\uff7e\uff9d\uff7b\uff0d(ADT7410)\u521d\u671f\u5316\r\n\r\n    \/\/ \u25c6 WIFI-\u521d\u671f\u8a2d\u5b9a \u25c6\r\n    Serial.println() ; Serial.println() ;\r\n    Serial.print(\"Connecting to \") ; Serial.println(ssid);\r\n\r\n    WiFi.mode(WIFI_STA);                        \/\/ STA\uff93\uff70\uff84\uff9e\u8a2d\u5b9a\r\n    WiFi.begin(ssid, password);                 \/\/ SSID,\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u6307\u5b9a\u3057\u3066\u30a2\u30af\u30bb\u30b9\u30dd\u30a4\u30f3\u30c8\u63a5\u7d9a   \r\n\r\n    \/\/ Wi-Fi\u63a5\u7d9a\u78ba\u8a8d\r\n    while (WiFi.status() != WL_CONNECTED) {\r\n        delay(500);\r\n        Serial.print(\".\");\r\n    }\r\n\r\n    Serial.println(\"\");\r\n    Serial.println(\"WiFi\u306b\u63a5\u7d9a\u3057\u307e\u3057\u305f\u3002\"); \r\n    Serial.println(\"\");\r\n}\r\n\r\n\/\/ \u2465\u7e70\u308a\u8fd4\u3057\u51e6\u7406\uff08\u30bb\u30f3\u30b5\u30fc\u3092\u8aad\u3093\u3067\u3001\u30b7\u30ea\u30a2\u30eb\u901a\u4fe1\u51fa\u529b\uff09\r\nvoid loop() {\r\n        r_t = rd_dat_ADT7410();                   \/\/ \u2606 \u6e29\u5ea6\uff7e\uff9d\uff7b\uff0d(ADT7410)\u30c7\u30fc\u30bf\u53d6\u5f97\r\n        read_data();                              \/\/ XYZ\u8ef8\u30c7\u30fc\u30bf\u53d6\u5f97\r\n        loopCnt = loopCnt + 1 ;\r\n\r\n        body = r_t ;                              \/\/ \u6e29\u5ea6\u30c7\u30fc\u30bf\u3092\u9001\u4fe1\u30dc\u30c7\u30a3\u306b\u8a2d\u5b9a\r\n        \r\n        WiFiClient client;                        \/\/ TCP\u63a5\u7d9a\u7528\u306bWiFiClient class\u3092\u4f7f\u7528\u3059\u308b\r\n\r\n        \/\/ TCP\u63a5\u7d9a\u78ba\u8a8d\r\n        if (!client.connect(host, httpPort)) {    \/\/ \u5916\u90e8\u30b5\u30fc\u30d0\u30fc\u306b\u63a5\u7d9a\r\n            Serial.println(\"\u63a5\u7d9a\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002\");\r\n            return;\r\n        }\r\n\r\n        \/\/ \u30b5\u30fc\u30d0\u306b\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u9001\u4fe1(POST)\r\n        client.print(String(\"POST \") + path + \" HTTP\/1.1\\r\\n\" +\r\n               \"Host: \" + host + \"\\r\\n\" + \r\n               \"Content-Length:\" + String(body.length())+ \"\\r\\n\" + \r\n               \"Connection: close\\r\\n\\r\\n\" +\r\n               body);\r\n   \r\n        \/\/ \u30ea\u30af\u30a8\u30b9\u30c8\u7d50\u679c\u53d7\u4fe1\u5f85\u3061            \r\n        unsigned long timeout = millis();\r\n        while (client.available() == 0) {\r\n            if (millis() - timeout > 12000) {\r\n                Serial.println(\">>> \u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u3057\u307e\u3057\u305f\u3002\");\r\n                client.stop();\r\n                return;\r\n            }\r\n        }\r\n\r\n        \/\/ HTTP\u30d8\u30c3\u30c0\u3092\u542b\u3080\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u53d6\u308a(1\u6587\u5b57\u6bce) \r\n        String raw = \"\";\r\n        while (client.available()) {\r\n            char c = client.read();\r\n            raw = raw +c;\r\n        }  \r\n\r\n        \/\/ HTTP\u30d8\u30c3\u30c0\u306e\u524a\u9664\u3001\r\n        int index = raw.indexOf(\"\\r\\n\\r\\n\");      \/\/ \u6539\u884c\u304c\uff12\u56de\u7d9a\u304f\u7b87\u6240\u691c\u7d22\uff08\\r\\n(='CR+LF')\uff09\r\n        \r\n        \/\/ ( index + s_p + 2 )\u304b\u3089\uff11\u6587\u5b57\u5207\u308a\u51fa\u3059    \r\n        rtn = raw.substring(index+s_p , index+s_p + 32 ) ;\r\n\r\n        Serial.println(\"--------------------------------------------------------------\");                   \r\n        \/\/Serial.print( loopCnt ) ;               \/\/ \u9001\u4fe1\u56de\u6570\r\n        Serial.print(\"\u9001\u4fe1\uff1a\");                   \r\n        Serial.print(r_t);                      \/\/ \u9001\u4fe1\u30c7\u30fc\u30bf\r\n\u51fa\u529b\r\n        Serial.print(\"\uff0c\u3000\u53d7\u4fe1\uff1a\");                   \r\n        Serial.println(rtn);                    \/\/ \u53d7\u4fe1\u30c7\u30fc\u30bf\u51fa\u529b\r\n        Serial.println(\"\");                     \/\/ \u6539\u884c\r\n        \/\/ WiFi.disconnect();                    \/\/ Wifi\u306e\u5207\u65ad\r\n\r\n        \/\/ 1000=1\u79d2    \r\n        delay(5 * 60 * 1000);                                \r\n}<\/pre>\n
\u4ee5\u4e0b\u306e\u56f3\u306f\u30d7\u30ed\u30b0\u30e9\u30e0\u5b9f\u884c\u6642\u306e\u30b7\u30ea\u30a2\u30eb\u30e2\u30cb\u30bf\u30fc\u51fa\u529b\u5185\u5bb9\u3067\u3059\u3002\u7d04\uff15\u5206\u304a\u304d\u306b\u30b5\u30fc\u30d0\u30fc\u306b\u9001\u3063\u305f\u300c\u9001\u4fe1\u30c7\u30fc\u30bf\u300d\u3068\u30b5\u30fc\u30d0\u304b\u3089\u8fd4\u4fe1\u3055\u308c\u305f\u300c\u53d7\u4fe1\u30c7\u30fc\u30bf\u300d\u3092\u51fa\u529b\u3057\u3066\u3044\u307e\u3059\u3002<\/span>
\n\"\"<\/span><\/span><\/p>\n
\uff08\uff12\uff09\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u5074\u30d7\u30ed\u30b0\u30e9\u30e0\u2460\uff08SQLite\u66f8\u304d\u8fbc\u307f\uff09<\/span><\/span><\/span><\/span>
\n\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u5074\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u793a\u3057\u307e\u3059\u3002\u884c\u756a\uff18\u3067ESPr\u00ae Developer\u304b\u3089\u9001\u4fe1\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u53d7\u3051\u53d6\u308a\u307e\u3059\u3002\u884c\u756a\uff11\uff10\uff5e\uff11\uff17\u3067\u53d7\u3051\u53d6\u3063\u305f\u30c7\u30fc\u30bf\u3092\u66f8\u304d\u8fbc\u3080SQLite\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u304c\u5b58\u5728\u3057\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3057\u307e\u3059\u3002\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u3001\u884c\u756a\uff11\uff18\uff5e\uff12\uff12\u3067\u65b0\u305f\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u884c\u756a\uff12\uff18\u3067\u306f\u53d7\u3051\u53d6\u3063\u305f\u5024\u304c\u3001\uff11\u5ea6\uff5e\uff14\uff15\u5ea6\u4ee5\u5185\u306e\u7bc4\u56f2\u3067\u3042\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3001\u884c\u756a\uff12\uff19\uff5e\uff13\uff12\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u8fbc\u307f\u3092\u884c\u3044\u307e\u3059\u3002
\n\u884c\u756a\uff13\uff14\uff0c\uff13\uff16\u3067\u306f\u3001\u66f8\u304d\u8fbc\u307f\u3092\u884c\u3063\u305f\u5834\u5408\u3001\u884c\u308f\u306a\u304b\u3063\u305f\u5834\u5408\u306e\u7d50\u679c\u3092ESPr\u00ae Developer\u5074\u306b\u9001\u4fe1\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n
<?php\r\n\r\n\t\/\/ \u65e5\u6642\u53d6\u5f97\r\n\tdate_default_timezone_set('Asia\/Tokyo');\r\n\t$timestamp = date('Y-m-d H:i:s');\r\n\r\n\t\/\/ post\u9001\u4fe1\u306eBody\u3059\u3079\u3066\u53d6\u5f97\r\n\t$entireBody = file_get_contents('php:\/\/input');\t\r\n\r\n\t\/\/ \u6e29\u5ea6\u8a18\u9332\u7528\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\r\n\t$db = null ; $sql = null ; $res = null;\r\n\t$db = new SQLite3(\".\/sq\/temp_record.sqlite3\");\t\r\n        \/\/ \u30c6\u30fc\u30d6\u30eb\u6709\u7121\u78ba\u8a8d\u7528\u306eSQL\r\n\t$sql = 'SELECT count(*) FROM sqlite_master WHERE type=\"table\" AND name=\"temp_reco\"';\r\n        \r\n\t\/\/ \u30c6\u30fc\u30d6\u30eb\u304c\u306a\u3044\u5834\u5408\u306f\u65b0\u305f\u306b\u4f5c\u6210\r\n\tif(!$db->querySingle($sql)){\r\n\t\t$sql = \"CREATE TABLE temp_reco(\r\n\t\t\tid INTEGER PRIMARY KEY,\r\n\t\t\tg_temp TEXT NOT NULL,\r\n\t\t\tcreated_datetime TIMESTAMP DEFAULT(datetime(CURRENT_TIMESTAMP,'localtime')))\";\r\n\t\t$res = $db->exec($sql);\r\n\t\t\r\n\t        \/\/echo \"<br>\";\r\n\t\t\/\/echo \"\u5546\u54c1\u30ea\u30b9\u30c8\u30c6\u30fc\u30d6\u30eb\u3092\u65b0\u305f\u306b\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002\";\r\n \t}\r\n\r\n\tif($entireBody >= 1 && $entireBody <= 45){\r\n\t\t$db = null ; $sql = null ; $res = null;\r\n\t    \t$db = new SQLite3(\".\/sq\/temp_record.sqlite3\");\r\n\t    \t$sql = 'INSERT INTO temp_reco( g_temp ) VALUES (\"'.$entireBody.'\")';\r\n\t    \t$res = $db->exec($sql);\r\n\r\n\t\techo \"OK , \".$entireBody.\" , \".$timestamp ;\r\n\t}else{\r\n\t\techo \"NG , \".$entireBody.\" , \".$timestamp ;\r\n\t}\r\n\r\n?><\/pre>\n
\uff08\uff13\uff09\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u5074\u30d7\u30ed\u30b0\u30e9\u30e0\u2461\uff08SQLite\u8aad\u307f\u51fa\u3057\uff09<\/span><\/span><\/span><\/span><\/a>\uff08\uff12\uff09\u3067\u66f8\u304d\u8fbc\u3093\u3060\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u4e0a\u306eSQLite\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u51fa\u3059\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u793a\u3057\u307e\u3059\u3002\u884c\u756a\uff13\uff5e\uff17\u3067\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u5168\u3066\u306e\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u8aad\u307f\u51fa\u3057\u3001\u884c\u756a\uff19\uff5e\uff11\uff18\u3067\u30d6\u30e9\u30a6\u30b6\u30fc\u4e0a\u306b\u51fa\u529b\u3057\u307e\u3059\u3002<\/p>\n
<?php\r\n\r\n\t$db = null;$sql = null;$res = null;\r\n\t$db = new SQLite3(\".\/sq\/temp_record.sqlite3\");\r\n\t$sql = 'SELECT * FROM temp_reco';\r\n\t\r\n\t$res = $db->query($sql);\r\n \r\n\twhile($row = $res->fetchArray(SQLITE3_NUM)) {\r\n\t    for($i = 0 ; $i < count($row); $i++){\r\n\t\techo $row [$i];\r\n    \t\t\t\r\n\t\tif($i < count($row) - 1){\r\n\t\t    echo \" , \" ;\r\n\t\t}\r\n\t    }\r\n\t    echo \"<br>\";\r\n\t}\r\n\r\n?><\/pre>\n
\u30d6\u30e9\u30a6\u30b6\u30fc\u3078\u306e\u51fa\u529b<\/a>\u306f\u4ee5\u4e0b\u306e\u69d8\u306b\u306a\u308a\u307e\u3059\u3002\u5de6\u304b\u3089\u30ab\u30f3\u30de\u3067\u533a\u5207\u3063\u3066\u3001\u9023\u756a\uff0c\u6e29\u5ea6\uff0c\u65e5\u6642\u306e\u9806\u306b\u767b\u9332\u6642\u9593\u5358\u4f4d\u3067\u8868\u793a\u3057\u3066\u3044\u307e\u3059\u3002
\n\uff08\u4ef6\u6570\u304c\u84c4\u7a4d\u3055\u308c\u308b\u3068\u3001\u51fa\u529b\u6642\u9593\u304c\u639b\u304b\u308a\u307e\u3059\u306e\u3067\u3001\u6700\u65b0\uff12\uff10\u4ef6\u8868\u793a\u306b\u4e00\u90e8\u6539\u826f\uff09
\n\"\"<\/p>\n\n\n\n
<\/td>\n<\/td>\n\u307e\u3068\u3081<\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u4eca\u56de\u306fESPr Developer\u3092\u4f7f\u3063\u305f\u6e2c\u5b9a\u5024\u3092\u30b5\u30fc\u30d0\u30fc\u5074\u306b\u4fdd\u5b58\u3059\u308b\u70ba\u306bSQLite\u3092\u4f7f\u3063\u3066\u307f\u307e\u3057\u305f\u3002\u4eca\u56de\u3001\u30b5\u30fc\u30d0\u30fc\u5074\u306b\u767b\u9332\u3057\u305f\u30c7\u30fc\u30bf\u306e\u547c\u3073\u51fa\u3057\u3082\u884c\u3063\u3066\u307f\u307e\u3057\u305f\u304c\u3001\u5358\u306a\u308b\u30c7\u30fc\u30bf\u306e\u7f85\u5217\u3067\u3059\u306e\u3067\u3001\u3082\u3046\u5c11\u3057\u898b\u308b\u4eba\u306b\u3084\u3055\u3057\u3044\u8868\u793a\u65b9\u6cd5\u3092\u691c\u8a0e\u3059\u308b\u4e88\u5b9a\u3067\u3059\u3002
\nIoT\u3084Cloud\u306a\u3069\u306e\u610f\u5473\u306f\u77e5\u3089\u3044\u306a\u3044\u306e\u3067\u3059\u304c\u3001\u306a\u3093\u3068\u306a\u304f\u5c11\u3057\u8fd1\u3065\u3044\u3066\u304d\u305f\u69d8\u306a\u6c17\u5206\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
  \u6982\u00a0 \u8981 ESPr Developer\u304b\u3089\u3001I2C\u63a5\u7d9a\u3067\u6e29\u5ea6\u30bb\u30f3\u30b5\u30fc\uff08ADT7410\uff09\u3092\u4f7f\u3063\u3066\u6e29\u5ea6\u6e2c\u5b9a\u3057\u3001\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u4e0a\u306ePHP\u30d7\u30ed\u30b0\u30e9\u30e0\u306b\u4e00\u5b9a\u6642\u9593\u9593\u9694\u3067\u6e2c\u5b9a\u7d50\u679c\u3092\u9001\u4fe1\u3057\u307e\u3059\u3002PHP\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u30c7\u30fc\u30bf\u3092 … \u7d9a\u304d\u3092\u8aad\u3080 ESPr Developer\u3092\u4f7f\u3063\u3066\u3001\u6e29\u5ea6\u3092\u6e2c\u5b9a\u3057\u3001\u30b5\u30fc\u30d0\u30fc\u4e0a\u306eSQLite\u30d5\u30a1\u30a4\u30eb\u306b\u8a18\u9332\u3057\u3066\u307f\u308b<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[24,44],"tags":[18,25,16,45,46],"_links":{"self":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/1226"}],"collection":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/comments?post=1226"}],"version-history":[{"count":42,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/1226\/revisions"}],"predecessor-version":[{"id":2865,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/1226\/revisions\/2865"}],"wp:attachment":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/media?parent=1226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/categories?post=1226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/tags?post=1226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}