{"id":4790,"date":"2016-09-08T16:59:25","date_gmt":"2016-09-08T07:59:25","guid":{"rendered":"https:\/\/okiraku-camera.tokyo\/blog\/?p=4790"},"modified":"2016-09-13T15:03:25","modified_gmt":"2016-09-13T06:03:25","slug":"wroom-02%e3%81%a7%e6%b8%a9%e5%ba%a6%ef%bc%8f%e6%b9%bf%e5%ba%a6%e8%a8%88%e6%b8%ac%e3%80%80%e3%81%9d%e3%81%ae%ef%bc%92","status":"publish","type":"post","link":"https:\/\/okiraku-camera.tokyo\/blog\/?p=4790","title":{"rendered":"WROOM-02\u3067\u6e29\u5ea6\uff0f\u6e7f\u5ea6\u8a08\u6e2c\u3000\u305d\u306e\uff12"},"content":{"rendered":"<h1>\u6982\u8981<\/h1>\n<p><a href=\"https:\/\/okiraku-camera.tokyo\/blog\/?p=4738\">WROOM-02\u3067\u6e29\u5ea6\uff0f\u6e7f\u5ea6\u8a08\u6e2c\u3000\u305d\u306e\uff11<\/a>\u3067\u306f\u3001WROOM-02\u3068HDC-1000\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u3001\u6e29\u5ea6\u3068\u6e7f\u5ea6\u3092\u5b9a\u671f\u7684\u306b\u6e2c\u5b9a\u3057\u30b5\u30fc\u30d0\u30fc\u306b\u9001\u4fe1\u3059\u308b\u305f\u3081\u306e\u4ed5\u7d44\u307f\u306b\u3064\u3044\u3066\u63b2\u8f09\u3057\u305f\u3002\u305d\u306e\u5f8c\u3001\u305f\u307e\u306b\u8a2d\u7f6e\u5834\u6240\u3092\u5909\u3048\u3066\u306f\u3044\u308b\u304c\u3001\u307b\u307c\u52d5\u304b\u3057\u305f\u307e\u307e\u3067\u5feb\u8abf\u306b\u30c7\u30fc\u30bf\u306e\u6e2c\u5b9a\u3068\u9001\u4fe1\u3092\u7e70\u308a\u8fd4\u3057\u3066\u3044\u308b\u3002<\/p>\n<p><a href=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/08\/8bc57a66cf675f7d8e186141d27f59c9.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-4770\" src=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/08\/8bc57a66cf675f7d8e186141d27f59c9-552x414.jpg\" alt=\"esp-hdc1000\" width=\"552\" height=\"414\" \/><\/a><\/p>\n<p>\u4eca\u56de\u306f\u30b5\u30fc\u30d0\u30fc\u5074\u306e\u8a71\u306b\u306a\u308b\u304c\u3001\u6b8b\u5ff5\u306a\u3053\u3068\u306b\u96fb\u5b50\u5de5\u4f5c\u306f\u306a\u304f\u3066\u3001\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u306e\u8a71\u3060\u3051\u306b\u306a\u308b\uff08\u984c\u540d\u306b\u554f\u984c\u3042\u308a\u304b\u3082\u3057\u308c\u306a\u3044\uff09\u3002<\/p>\n<p>\u6e2c\u5b9a\u30c7\u30fc\u30bf\u306e\u683c\u7d0d\u3068\u6e2c\u5b9a\u30c7\u30fc\u30bf\u306e\u30af\u30a8\u30ea\u3092\u884c\u3046\u30d7\u30ed\u30b0\u30e9\u30e0\uff08php\uff09\u3068\u3001\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a\u3059\u308bhtml\uff08javaScript\uff09\u3092\u63b2\u8f09\u3059\u308b\u3002<\/p>\n<h1>\u30b5\u30fc\u30d0\u30fc\u5074\u306e\u69cb\u6210<\/h1>\n<h2>\u6982\u8981<\/h2>\n<p>\u4eca\u56de\u306f\u3001\u6570\u5e74\u524d\u304b\u3089\u5b89\u5b9a\u3057\u3066\u52d5\u4f5c\u3057\u3066\u3044\u308b httpd (apache 2.2.3)\u3068php 5.5.18\u3001\u304a\u3088\u3073\u3001mysql (5.0.95)\u304c\u5c0e\u5165\u3055\u308c\u3066\u3044\u308bLinux (CentOS 5.11) \u306e\u4eee\u60f3\u30b5\u30fc\u30d0\u30fc\u3092\u7528\u3044\u305f\uff08\u5f53\u30d6\u30ed\u30b0\u306e\u30db\u30b9\u30c8\u3068\u306f\u7570\u306a\u308a\u307e\u3059\uff09\u3002<\/p>\n<p>\u4ee5\u4e0b\u3001\u4e0a\u8a18\u306e\u52d5\u4f5c\u74b0\u5883\u306b\u5bfe\u3059\u308b\u64cd\u4f5c\u3068\u3057\u3066\u8a18\u8f09\u3059\u308b\u3002<\/p>\n<h2>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u95a2\u4fc2<\/h2>\n<h3>\u6e96\u5099\u306e\u305f\u3081\u306e\u30b9\u30af\u30ea\u30d7\u30c8<\/h3>\n<p>\u6e96\u5099\u3068\u3057\u3066\u306f\u3001mysql\u306e\u4e0a\u306b\u5c02\u7528\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff08envdata\uff09\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30e6\u30fc\u30b6\u30fc\uff08envuser\uff09\u3092\u4f5c\u6210\u3057\u3001\u6240\u5b9a\u306e\u30c6\u30fc\u30d6\u30eb\uff08envdata\uff09\u3092\u4f5c\u6210\u3059\u308b\u3002\u3042\u3068\u306f\u3001php\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f8\u304f\u3060\u3051\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u95a2\u9023\u306e\u6e96\u5099\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u884c\u3063\u305f\u3002<\/p>\n<pre class=\"lang:default decode:true\">create database envdata default character set utf8 collate utf8_general_ci;\r\n\r\ngrant all privileges on envdata.* to envuser@localhost identified by 'password';\r\n\r\nuse envdata;\r\ncreate table envdata(\r\n  serial_no  int  not null   AUTO_INCREMENT\r\n  ,point_id varchar (20) not null\r\n  ,T float (7,2) null\r\n  ,H float (7,2) null\r\n  ,X1 float (7,2) null\r\n  ,X2 float (7,2) null\r\n  ,post_datetime timestamp default CURRENT_TIMESTAMP not null\r\n  ,PRIMARY KEY (serial_no)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n<\/pre>\n<p>\u30ab\u30e9\u30e0X1\u3068X2\u306f\u62e1\u5f35\u7528\u306b\u7528\u610f\u3057\u305f\u3002\u6c17\u5727\u3067\u3082\u3068\u308c\u308b\u3068\u3088\u3044\u306e\u3060\u304c\u3002<\/p>\n<p>\u30ea\u30e2\u30fc\u30c8\u30c7\u30fc\u30bf\u3092\u53d7\u3051\u53d6\u308b\u305f\u3081\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u3063\u305f\u3068\u304d\u306b\u306f\u3001<\/p>\n<p style=\"padding-left: 30px;\"><em>mysql&gt; select user,password, host from mysql.user;<\/em><\/p>\n<p>\u3092\u5b9f\u884c\u3057\u3001\u3053\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30e6\u30fc\u30b6\u30fc\u304c\u6240\u5b9a\u306e\u30db\u30b9\u30c8\uff08\u3053\u306e\u5834\u5408\u306f <em>localhost<\/em> \uff09\u304b\u3089\u3057\u304b\u63a5\u7d9a\u3067\u304d\u306a\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3057\u305f\u65b9\u304c\u3088\u3044\u3060\u308d\u3046\u3002<\/p>\n<h3>\u6e2c\u5b9a\u30c7\u30fc\u30bf\u306e\u683c\u7d0d\u3068\u30af\u30a8\u30ea<\/h3>\n<p>\u30bb\u30f3\u30b5\u30fc\u3092\u63a5\u7d9a\u3057\u305fWROOM02 \uff08\u4ee5\u964d\u3001<strong>\u30bb\u30f3\u30b5\u30fc<\/strong>\u3068\u79f0\u3059\u308b\uff09\u306f\u3001\u3053\u306e\u30b5\u30fc\u30d0\u30fc\u306etcp\/80\u306bhttp\u63a5\u7d9a\u3057\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u5177\u5408\u306eGET\u30ea\u30af\u30a8\u30b9\u30c8\u3067\u6e2c\u5b9a\u30c7\u30fc\u30bf\u3092\u6295\u3052\u3066\u304f\u308b\u3002<\/p>\n<p style=\"padding-left: 30px;\"><strong><em>\/data\/store_data.php?point_id=18:FE:34:xx:xx:xx&amp;T=26.87&amp;H=43.95<\/em><\/strong><\/p>\n<p>point_id\u304cMAC\u30a2\u30c9\u30ec\u30b9\u3001T\u304c\u6e29\u5ea6\u3001H\u304c\u6e7f\u5ea6\u3067\u3042\u308b\u3002\u30ea\u30af\u30a8\u30b9\u30c8\u304b\u3089\u5206\u304b\u308b\u3088\u3046\u306b\u3001<em><strong>store_data.php<\/strong><\/em> \u3068\u3044\u3046php\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u53d7\u3051\u3066\u304a\u308a\u3001\u3053\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u304c\u30c6\u30fc\u30d6\u30eb <em>envdata<\/em> \u306binsert\u3092\u5b9f\u884c\u3059\u308b\u3002\u6e2c\u5b9a\u6642\u523b\u3068\u3057\u3066\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u3078\u306einsert\u6642\u523b\uff08\u30b5\u30fc\u30d0\u30fc\u6642\u523b\u3001\u00a0<strong><em>CURRENT_TIMESTAMP<\/em><\/strong> \uff09\u304c\u00a0<em>post_datetime \u00a0<\/em>\u30ab\u30e9\u30e0\u306b\u683c\u7d0d\u3055\u308c\u308b\u3002<\/p>\n<p>\u524d\u56de\u306e\u30cf\u30fc\u30c9\u30a6\u30a7\u30a2\u7de8\u306b\u3042\u308b\u3088\u3046\u306b\u3001WiFi\u30eb\u30fc\u30bf\u30fc\u306b\u3064\u306a\u304c\u3089\u306a\u304b\u3063\u305f\u5834\u5408\u3084\u3001\u30bb\u30f3\u30b5\u30fc\u306e\u96fb\u6e90\u3092\u5207\u3063\u3066\u3044\u308b\u5834\u5408\u306b\u306f\u6b20\u6e2c\u3068\u306a\u308a\u30c7\u30fc\u30bf\u306f\u683c\u7d0d\u3055\u308c\u306a\u3044\u304c\u3001\u305d\u306e\u3042\u305f\u308a\u306b\u306f\u914d\u616e\u3057\u3066\u3044\u306a\u3044\u3002<\/p>\n<p>\u4eca\u56de\u63b2\u8f09\u3059\u308b3\u3064\u306ephp\u30d7\u30ed\u30b0\u30e9\u30e0\uff08<em>envdata_db.php , store_data.php, readdata_json.php<\/em>\uff09\u306f\u3001\u3044\u305a\u308c\u3082httpd\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\uff08 \u30ea\u30af\u30a8\u30b9\u30c8\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e <em>\/data<\/em> \u306b\u5bfe\u5fdc\u3059\u308b\u7269\u7406\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\uff09\u306b\u683c\u7d0d\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308b\u3002\u3069\u306e\u7269\u7406\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u3059\u308b\u306e\u304b\u306f\u3001httpd.conf\u3084conf.d\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u5185\u306econf\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u3044\u305f\u3068\u304a\u308a\u306b\u306a\u308b\u3002<\/p>\n<h6>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u51e6\u7406\u30af\u30e9\u30b9 envdata_db<\/h6>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3059\u308b\u30c7\u30fc\u30bf\u683c\u7d0d\u3068\u30af\u30a8\u30ea\u6a5f\u80fd\u306f\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u30d6\u30ed\u30c3\u30af\u5316\u3092\u610f\u8b58\u3057\u3066\u4e00\u3064\u306e\u30af\u30e9\u30b9 (<em>envdata_db.php<\/em>) \u306b\u307e\u3068\u3081\u305f\u3002\u4ee5\u4e0b\u306b\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u793a\u3059\u3002<\/p>\n<pre class=\"lang:php decode:true\" title=\"envdata_db.php\">&lt;?PHP\r\nclass envdata_db {\r\n\tprivate $mysql;\t\/\/ \u30b3\u30cd\u30af\u30b7\u30e7\u30f3\r\n\tprivate $last_error;\r\n\tprivate $last_sql;\r\n\r\n\tpublic function __construct(){\r\n\t\t$this-&gt;mysql= mysqli_connect(\"localhost\", \"envuser\", \"password\", \"envdata\");\t\r\n\t\t$this-&gt;last_error = mysqli_connect_error();\r\n\t}\r\n\r\n\tpublic function __destruct() {\r\n\t\tif ($this-&gt;mysql)\r\n\t\t\tmysqli_close($this-&gt;mysql);\r\n\t\t$this-&gt;mysql = FALSE ;\r\n\t}\r\n\r\n\tpublic function isConnect() {\r\n\t\treturn ($this-&gt;mysql != FALSE);\r\n\t}\r\n\r\n\tpublic function getLast_error() {\r\n\t\treturn $this-&gt;last_error;\r\n\t}\r\n\r\n\tpublic function getLast_sql() {\r\n\t\treturn $this-&gt;last_sql;\r\n\t}\r\n\r\n\tpublic function insert_data($point_id, $t, $h, $x1, $x2) {\r\n\t\tif (!$this-&gt;isConnect())\r\n\t\t\treturn FALSE;\r\n\t\t$id = mysqli_real_escape_string($this-&gt;mysql, $point_id);\r\n\t\t$sql = \"insert into envdata (T, H, X1, X2, point_id) values ($t, $h, $x1, $x2, '$id')\";\r\n\t\t$this-&gt;last_sql = $sql;\r\n\t\tif (!mysqli_query($this-&gt;mysql, $sql)) {\r\n\t\t\t$this-&gt;last_error = mysqli_error($this-&gt;mysql);\r\n\t\t\treturn FALSE ;\r\n\t\t}\r\n\t\treturn TRUE;\r\n\t}\r\n\r\n\tpublic function query_data_json($condition = \"\") {\r\n\t\tif (!$this-&gt;isConnect())\r\n\t\t\treturn FALSE;\r\n\r\n\t\t$today = TRUE;\r\n\t\t$sql = \"select post_datetime as datetime,T,H from (select * from envdata order by serial_no desc limit 120) as A\";\r\n\t\t$sql = $sql . \" order by serial_no asc\";\r\n\t\t$this-&gt;last_sql = $sql;\r\n\t\tif (($query_result = mysqli_query($this-&gt;mysql, $sql)) == FALSE) {\r\n\t\t\t$this-&gt;last_error = mysqli_error($this-&gt;mysql);\r\n\t\t\treturn FALSE ;\r\n\t\t}\r\n\t\t$result_count = mysqli_num_rows($query_result);\r\n\t\t$result = array();\r\n\t\twhile ($r = mysqli_fetch_assoc ($query_result))\r\n\t\t\t$result[] = array('datetime' =&gt; str_replace(\"-\", \"\/\", $r['datetime']), 'T' =&gt; (float)$r['T'], 'H' =&gt; (float)$r['H']);\r\n\t\tmysqli_free_result($query_result);\r\n\t\t$json_result = json_encode(array('count' =&gt; $result_count, 'data' =&gt; $result), JSON_UNESCAPED_SLASHES);\r\n\t\treturn $json_result;\r\n\t}\r\n}\r\n<\/pre>\n<p>\u3053\u306e\u30af\u30e9\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u4f5c\u6210\u3055\u308c\u305f\u6642\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u3092\u78ba\u7acb\u3057\u3001<em>insert_data()<\/em>\u306b\u3088\u3063\u3066\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3001<em>query_data_json()<\/em>\u306b\u3088\u308aJSON\u5f62\u5f0f\u3067\u30af\u30a8\u30ea\u7d50\u679c\u3092\u8fd4\u3059\u3002\u305d\u3057\u3066\u30c7\u30b9\u30c8\u30e9\u30af\u30c8\u3055\u308c\u308b\u3068\u304d\u306b\u63a5\u7d9a\u3092\u9589\u3058\u308b\u3002http\u30ea\u30af\u30a8\u30b9\u30c8\u306e\u90fd\u5ea6\u3054\u3068\u306b\u3001\u69cb\u7bc9\uff5e\u30af\u30a8\u30ea\uff5e\u5ec3\u68c4\u304c\u901f\u3084\u304b\u306b\u884c\u308f\u308c\u308b\u3053\u3068\u3092\u60f3\u5b9a\u3057\u3066\u3044\u308b\u3002<\/p>\n<p>\u4eca\u56de\u306f\u6e2c\u5b9a\u7d50\u679c\u3092google chart\u3092\u4f7f\u3063\u3066\u30b0\u30e9\u30d5\u8868\u793a\u3059\u308b\u3053\u3068\u3060\u3051\u3092\u8003\u3048\u305f\u306e\u3067\u3001\u30af\u30a8\u30ea\u7528\u306e\u30e1\u30bd\u30c3\u30c9\u3068\u3057\u3066\u306f <em>query_data_json()<\/em> \u306e\u307f\u3092\u7528\u610f\u3057\u305f\u3002\u7c21\u5358\u306e\u305f\u3081\u306b\u30af\u30a8\u30ea\u6761\u4ef6\u306f\u306a\u304f\u3001\u4ee5\u4e0b\u306eSQL\u6587\u306b\u3088\u3063\u3066\u6700\u65b0\u306e120\u4ef6\uff082\u5206\u9593\u3054\u3068\u306e\u6e2c\u5b9a\u306a\u3089\u30704\u6642\u9593\u5206\uff09\u3092JSON\u5f62\u5f0f\u306e\u6587\u5b57\u5217\u3068\u3057\u3066\u8fd4\u3059\u3002<\/p>\n<p style=\"padding-left: 30px;\"><strong><em>select post_datetime as datetime,T,H from<br \/>\n(select * from envdata order by serial_no desc limit 120) as A<br \/>\norder by serial_no asc<\/em><\/strong><\/p>\n<p>\u6700\u65b0120\u4ef6\u3092\u5f97\u308b\u305f\u3081\u306b\u3001\u30b5\u30d6\u30af\u30a8\u30ea\u306b\u3088\u3063\u3066\u65b0\u898f\u9806120\u4ef6\u306e\u7d50\u679c\u30bb\u30c3\u30c8\u3092\u4f5c\u308a\u3001\u305d\u3053\u304b\u3089\u53e4\u3044\u9806\u306b\u53d6\u308a\u51fa\u3059\u3068\u3044\u3046\u3088\u304f\u4f7f\u308f\u308c\u308b\u624b\u6cd5\u3002<br \/>\nSQL\u30af\u30a8\u30ea\u304c\u6210\u529f\u3059\u308b\u3068\u305d\u306e\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u5404\u884c\u306b\u5bfe\u3057\u3066\u00a0<em>mysqli_fetch_assoc()<\/em> \u3067\u30ab\u30e9\u30e0\u540d\u3092\u30ad\u30fc\u3068\u3059\u308b\u9023\u60f3\u914d\u5217\u3092\u5f97\u3066\u3044\u308b\u3002\u305d\u3057\u3066\u3001\u3053\u306e\u9023\u60f3\u914d\u5217\u5185\u306e\u65e5\u4ed8\u306e\u5f62\u5f0f\u3092\u5909\u63db\u3057\u305f\u308a\u3001\u6587\u5b57\u5217\u3092\u6570\u5024\u306b\u76f4\u3057\u305f\u308a\u3057\u3066\u304b\u3089\u3001<em>json_encode()<\/em> \u3092\u884c\u3063\u3066\u3044\u308b\u304c\u3001\u3053\u308c\u3089\u306f google chart\u3067\u3046\u307e\u304f\u8868\u793a\u3059\u308b\u305f\u3081\u306e\u5c0f\u7d30\u5de5\u3067\u3042\u308b\u3002<\/p>\n<h6>\u30c7\u30fc\u30bf\u306e\u53d7\u3051\u53d6\u308a\u3068\u683c\u7d0d( store_data.php )<\/h6>\n<p>\u30bb\u30f3\u30b5\u30fc\u5074\u304b\u3089\u306e\u30c7\u30fc\u30bf\u3092\u53d7\u3051\u53d6\u308a\u3001envdata_db\u30af\u30e9\u30b9\u3092\u547c\u3073\u51fa\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u683c\u7d0d\u3059\u308b\u3002<\/p>\n<pre class=\"lang:php decode:true\" title=\"store_data.php\">&lt;?PHP\r\nrequire_once('envdata_db.php');\r\nfunction check_store_data($key, $default) {\r\n\t$v = isset($_GET[$key]) ? $_GET[$key] : $default;\r\n\tif ($v == \"\")\r\n\t\t$v = $default;\r\n\treturn $v;\r\n}\r\n$t = check_store_data('T', 0.0);\r\n$h = check_store_data('H', 0.0);\r\n$x1 = check_store_data('X1', 0.0);\r\n$x2 = check_store_data('X2', 0.0);\r\n$pid = check_store_data('point_id', 'unknown');\r\nheader('cotent-type: text\/html');\r\n$envdata = new envdata_db();\r\nif (!$envdata-&gt;insert_data($pid, $t, $h, $x1, $x2)) {\r\n\techo \"NG SQL ERROR: \" . $envdata-&gt;getLast_error() . '&lt;br\/&gt;';\r\n\techo $envdata-&gt;getLast_sql() . '&lt;br\/&gt;';\r\n} else {\r\n\techo \"OK\";\r\n}\r\n?&gt;\r\n<\/pre>\n<p>\u5148\u306eenvdata_db\u30af\u30e9\u30b9\u306e\u5185\u5bb9\u304b\u3089\u660e\u3089\u304b\u306a\u3088\u3046\u306b\u3001\u6e2c\u5b9a\u30c7\u30fc\u30bf\u95a2\u9023\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u30d1\u30e9\u30e1\u30fc\u30bf\u306bfloat\u3068\u89e3\u91c8\u3067\u304d\u306a\u3044\u30c7\u30fc\u30bf\u304c\u5165\u3063\u3066\u3044\u308b\u3068\u3001insert\u306f\u5931\u6557\u3059\u308b\u3002\u3068\u308a\u3042\u3048\u305a\u3001check_data() \u3068\u3044\u3046\u95a2\u6570\u306b\u3088\u3063\u3066\u3001\u30d1\u30e9\u30e1\u30fc\u30bf\u7701\u7565\u6642\u3084\u7a7a\u767d\u306e\u5834\u5408\u306f0.0\u3068\u3044\u3046\u6570\u5024\u3092\u5165\u308c\u308b\u3053\u3068\u306b\u3057\u305f\u3002<\/p>\n<p>\u4e00\u5fdc\u3001insert_data()\u304c\u5931\u6557\u3057\u305f\u3068\u304d\u306b\u306f\u3001\u305d\u306e\u5185\u5bb9\u3092html\u3067\u8fd4\u3059\u3088\u3046\u306a\u5185\u5bb9\u306b\u306a\u3063\u3066\u3044\u308b\u304c\u3001\u30bb\u30f3\u30b5\u30fc\u5074\u3067\u5fdc\u7b54\u6587\u5b57\u5217\u3092\u89e3\u91c8\u3057\u305f\u3068\u3057\u3066\u3082\u3001\u57fa\u672c\u7684\u306b\u4eba\u9593\u306f\u4ecb\u5728\u3057\u306a\u3044\u308f\u3051\u306a\u306e\u3067\u3001\u3042\u307e\u308a\u610f\u5473\u304c\u306a\u3044\u3002LED\u3092\u70b9\u6ec5\u3055\u305b\u305f\u3068\u3053\u308d\u3067\u8ab0\u3082\u6c17\u3065\u304b\u306a\u3044\u306e\u3067\u3042\u308b\u3002\u3042\u304f\u307e\u3067\u3082\u673a\u4e0a\u306e\u30c6\u30b9\u30c8\u7528\u3068\u3044\u3046\u3068\u3053\u308d\u3002<\/p>\n<h6>\u30af\u30a8\u30ea\u7d50\u679c\u306e\u51fa\u529b( readdata_json.php )<\/h6>\n<p>\u3053\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u3001\u30d6\u30e9\u30a6\u30b6\u3067\u52d5\u304fjavaScript\u5185\u304b\u3089json\u30c7\u30fc\u30bf\u3092\u30ea\u30af\u30a8\u30b9\u30c8\u3059\u308b\u3068\u304d\u306b\u4f7f\u3046\u3082\u306e\u3067\u3001\u4eba\u9593\u304c\u76ee\u3067\u307f\u308b\u305f\u3081\u306e\u3082\u306e\u3067\u306f\u306a\u3044\u3002<em>envdata_db<\/em>\u30af\u30e9\u30b9<em>query_data_json()<\/em>\u30e1\u30bd\u30c3\u30c9\u3092\u547c\u3073\u51fa\u3059\u3053\u3068\u3067\u3001JSON\u5f62\u5f0f\u306e\u7d50\u679c\u3092\u5f97\u305f\u3001http\u30ea\u30af\u30a8\u30b9\u30c8\u306e\u5fdc\u7b54\u3068\u3057\u3066\u8fd4\u3059\u3002<\/p>\n<pre class=\"lang:php decode:true\" title=\"readdata_json.php\">&lt;?PHP\r\nrequire_once('envdata_db.php');\r\n\r\n$envdata = new envdata_db();\r\n$r = $envdata-&gt;query_data_json();\r\nif (!$r) {\r\n       header('Content-Type: text\/html');\r\n\techo $envdata-&gt;getLast_error() . \"&lt;br\/&gt;\\n\";\r\n\techo $envdata-&gt;getLast_sql() . \"&lt;br\/&gt;\\n\";\r\n} else {\r\n\theader('Content-Type: application\/json; charset=utf-8');\r\n\techo $r;\r\n}\r\n?&gt;\r\n<\/pre>\n<p>\u30af\u30a8\u30ea\u6210\u529f\u6642\u306b\u306f\u3001&#8217;application\/json\u2019\u3068\u3044\u3046\u30b3\u30f3\u30c6\u30f3\u30c8\u30bf\u30a4\u30d7\u3092\u7528\u3044\u3066\u30c7\u30fc\u30bf\u3092\u5fdc\u7b54\u3059\u308b\u3002\u5931\u6557\u6642\u306b\u306f\u4eba\u9593\u7528\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8fd4\u3059\u304c\u3001\u3053\u308c\u3082\u30c6\u30b9\u30c8\u7528\u3067javaScript\u3067\u30a8\u30e9\u30fc\u3092\u5224\u5b9a\u3059\u308b\u3053\u3068\u306f\u8003\u3048\u3066\u3044\u306a\u3044\u3002<\/p>\n<p>\u30d6\u30e9\u30a6\u30b6\u304b\u3089\u76f4\u63a5 <em>\/data\/readdata_json.php<\/em>\u00a0\u3092\u30ea\u30af\u30a8\u30b9\u30c8\u3057\u3066\u307f\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u7d50\u679c\u304c\u5f97\u3089\u308c\u308b\uff08\u898b\u3084\u3059\u3055\u306e\u305f\u3081\u6539\u884c\u3068\u30a4\u30f3\u30c7\u30f3\u30c8\u3092\u5165\u308c\u3066\u3044\u308b\u304c\u3001\u5b9f\u969b\u306b\u306f\u5165\u3089\u306a\u3044\uff09\u3002\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u884c\u6570\u3092\u00a0<em>count<\/em>\u00a0\u3068\u3044\u3046\u30ad\u30fc\u540d\u3067\u3001\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u5404\u884c\u306e\u914d\u5217\u3092 <em>data<\/em>\u00a0\u3068\u3044\u3046\u30ad\u30fc\u540d\u3067\u8868\u73fe\u3057\u3066\u3044\u308b\u3002\u305d\u3057\u3066\u3001\u5404\u7d50\u679c\u30bb\u30c3\u30c8\u306f\u3001<em>datetime<\/em>, \u00a0<em>T<\/em>, <em>H<\/em>\u3068\u3044\u3046\u30ab\u30e9\u30e0\u540d\uff08\u307e\u305f\u306f\u305d\u306e\u5225\u540d\uff09\u304c\u30ad\u30fc\u3068\u306a\u3063\u3066\u3044\u308b\u3002<\/p>\n<pre class=\"lang:default decode:true\">{\"count\":120,\r\n\"data\":[\r\n\u3000{\"datetime\":\"2016\/09\/01 08:44:14\",\"T\":29.58,\"H\":60.39},\r\n\u3000....,,\r\n\u3000{\"datetime\":\"2016\/09\/01 12:55:18\",\"T\":27.79,\"H\":59.83}\r\n\u3000]\r\n}\r\n<\/pre>\n<p>\u30c7\u30fc\u30bf\u53d6\u5f97\u7528\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3084\u30af\u30a8\u30ea\u306e\u305f\u3081\u306e\u30e1\u30bd\u30c3\u30c9\u306b\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u691c\u7d22\u6761\u4ef6\u3092\u4ed8\u52a0\u3059\u308b\u306a\u3069\u306e\u62e1\u5f35\u306f\u5bb9\u6613\u3060\u308d\u3046\u3002<\/p>\n<h3>\u4f11\u61a9<\/h3>\n<p>\u8108\u7d61\u3082\u306a\u304f\u6700\u8fd1\u30de\u30af\u30ed\u30ec\u30f3\u30ba\u3067\u5199\u3057\u305f\u30a2\u30d6\u30e9\u30bc\u30df\u306e\u9854\u3092\u3002\u3082\u3046\u590f\u3082\u7d42\u308f\u308a\u3067\u3059\u306d\u3002<\/p>\n<figure id=\"attachment_4797\" aria-describedby=\"caption-attachment-4797\" style=\"width: 552px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/3fab25c5da9ca3fe9957cbc6a9d0f3ea.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4797 size-large\" src=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/3fab25c5da9ca3fe9957cbc6a9d0f3ea-552x414.jpg\" alt=\"\u30a2\u30d6\u30e9\u30bc\u30df\" width=\"552\" height=\"414\" \/><\/a><figcaption id=\"caption-attachment-4797\" class=\"wp-caption-text\">\u30a2\u30d6\u30e9\u30bc\u30df\u306e\u9854<\/figcaption><\/figure>\n<p>\u8907\u773c\u306e\u507d\u77b3\u5b54\u304c\u3088\u304f\u898b\u3048\u308b\u3002<\/p>\n<h1>\u30b0\u30e9\u30d5\u8868\u793a\u7528html<\/h1>\n<h2>Google Charts\u306e\u5229\u7528<\/h2>\n<p>google\u3055\u3093\u304c\u7528\u610f\u3057\u3066\u3044\u308b\u3001<em><strong>google.visualization.LineChart<\/strong><\/em> \u30af\u30e9\u30b9\u3092\u4f7f\u3063\u3066\u3001\u30d6\u30e9\u30a6\u30b6\u306b\u30b0\u30e9\u30d5\u3092\u8868\u793a\u3059\u308b\u3002\u3053\u306e\u30af\u30e9\u30b9\u3092\u5229\u7528\u3059\u308c\u3070\u3001\u4e0e\u3048\u305f\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u6307\u5b9a\u306e<em>&lt;div&gt;<\/em>\u306e\u4e2d\u306bSVG\u3067\u30b0\u30e9\u30d5\u3092\u63cf\u3044\u3066\u304f\u308c\u308b\u3002\u30b5\u30fc\u30d0\u30fc\u5185\u3067\u30b0\u30e9\u30d5\u3092\u63cf\u753b\u3057\u3066png\u5f62\u5f0f\u306e\u30a4\u30e1\u30fc\u30b8\u3092\u8fd4\u3059\u3068\u3044\u3046\u3084\u308a\u65b9\u3082\u3042\u308b\u304c\u3001\u30c7\u30fc\u30bf\u3092\u30d3\u30b8\u30e5\u30a2\u30eb\u306b\u8868\u793a\u3057\u305f\u3044\u3068\u304d\u306b\u306f\u3001<a href=\"https:\/\/developers.google.com\/chart\/\">Google Charts<\/a> \u3092\u4f7f\u3046\u306e\u304c\u624b\u8efd\u3067\u7c21\u5358\u3002<\/p>\n<figure id=\"attachment_4829\" aria-describedby=\"caption-attachment-4829\" style=\"width: 552px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/3366b238a7ddd501526806434cc7ecc4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-4829\" src=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/3366b238a7ddd501526806434cc7ecc4-552x308.png\" alt=\"LineChart1\" width=\"552\" height=\"308\" \/><\/a><figcaption id=\"caption-attachment-4829\" class=\"wp-caption-text\">google.visualization.LineChart() \u306b\u3088\u308b\u63cf\u753b<\/figcaption><\/figure>\n<p>\u6e29\u5ea6\u3068\u6e7f\u5ea6\u306e2\u7cfb\u7d71\u306e\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3059\u308b\u3068\u3001\u3053\u3093\u306a\u5177\u5408\u306b\u306a\u308b\u3002\u6e7f\u5ea6\u306b\u6bd4\u3079\u3066\u6e29\u5ea6\u306e\u5909\u5316\u304c\u5c11\u306a\u3044\u3002<\/p>\n<h2>data_chart.html<\/h2>\n<p>\u3053\u306e\u30b0\u30e9\u30d5\u3092\u8868\u793a\u3059\u308b\u305f\u3081\u306ehtml (data_chart.html) \u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3001\u307b\u3068\u3093\u3069javaScript\u306b\u306a\u3063\u3066\u3044\u308b\u3002<\/p>\n<pre class=\"lang:js decode:true\">&lt;!DOCTYPE html&gt;\r\n&lt;html&gt;\r\n&lt;head&gt;\r\n&lt;meta charset=\"utf-8\"&gt;\r\n&lt;title&gt;Thermal and Humidity&lt;\/title&gt;\r\n&lt;script type=\"text\/javascript\" src=\"http:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.11.1\/jquery.min.js\"&gt;&lt;\/script&gt;\r\n&lt;script type=\"text\/javascript\" src=\"https:\/\/www.gstatic.com\/charts\/loader.js\"&gt;&lt;\/script&gt;\r\n&lt;script&gt;\r\n\tgoogle.charts.load(\"visualization\", \"1\", {packages: [\"corechart\"], language:\"ja\"});\r\n\tgoogle.charts.setOnLoadCallback(drawChart);\r\n\r\n\tfunction drawChart() {\r\n\t\tvar query_json = \"readdata_json.php\";\r\n\t\t$.getJSON(query_json, function(json) {\r\n\t\t\tvar data = new google.visualization.DataTable();\r\n\t\t\tdata.addRows(json.data.length);\r\n\t\t\tdata.addColumn(\"datetime\", \"\u65e5\u6642\");\r\n\t\t\tdata.addColumn(\"number\", \"\u6e29\u5ea6\");\r\n\t\t\tdata.addColumn(\"number\", \"\u6e7f\u5ea6\");\r\n\t\t\tvar first = null;\r\n\t\t\tvar last = null;\r\n\t\t\t$.each(json.data, function(i, v) {\r\n\t\t\t\tlast = new Date(v.datetime);\r\n\t\t\t\tif (first == null)\r\n\t\t\t\t\tfirst = last;\r\n\t\t\t\tdata.setValue(i, 0, new Date(last));\r\n\t\t\t\tdata.setValue(i, 1, v.T);\r\n\t\t\t\tdata.setValue(i, 2, v.H);\r\n\t\t\t});\r\n\t\t\tvar options = {\r\n\t\t\t\ttitle: \"\u30bb\u30f3\u30b5\u30fc\u30c7\u30fc\u30bf (\" + json.count + \"\u4ef6)  [\" + first.toLocaleString() + \" \uff5e \" + last.toLocaleString() + \"] \",\r\n\t\t\t\tlineWidth: 1, \r\n\t\t\t\tfontSize: 12,\r\n\t\t\t\tchartArea: {left: '80px', top: '80px', width: \"80%\", height: \"80%\"}\r\n\t\t\t};\r\n\t\t\tvar chart = new google.visualization.LineChart(document.getElementById(\"chart_div\"));\r\n\t\t\tchart.draw(data, options);\r\n\t\t});\r\n\t}\r\n&lt;\/script&gt;\r\n&lt;style&gt;\r\ndiv#chart_div { height: 500px; width: 100%; border: 1px solid #000000; }\r\n&lt;\/style&gt;\r\n&lt;\/head&gt;\r\n&lt;body&gt;\r\n&lt;div id=\"chart_div\"&gt;&lt;\/div&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;\r\n<\/pre>\n<p>\u7c21\u5358\u306b\u8aac\u660e\u3059\u308b\u3068\u3001<\/p>\n<h6>var query_json = &#8220;readdata_json.php&#8221;;<\/h6>\n<p>\u30b5\u30fc\u30d0\u30fc\u304b\u3089json\u30c7\u30fc\u30bf\u3092GET\u3059\u308b\u305f\u3081\u306e\u30a2\u30c9\u30ec\u30b9\u3092\u6307\u5b9a\u3059\u308b\u3002\u4eca\u56de\u306f\u3001\u3053\u306ehtml (data_chart.html) \u3068\u540c\u3058\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u7f6e\u3044\u3066\u3044\u308b\u304b\u3089\u3001\u30db\u30b9\u30c8\u540d\u3084\u30d1\u30b9\u540d\u306e\u6307\u5b9a\u306f\u306a\u3044\u3002\u308f\u3056\u308f\u3056\u5909\u6570\u306b\u3059\u308b\u5fc5\u8981\u306f\u306a\u3044\u306e\u3060\u304c\u3001\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u6761\u4ef6\u3092\u5909\u66f4\u3059\u308b\u305f\u3081\u306b\u30ea\u30af\u30a8\u30b9\u30c8\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u52a0\u5de5\u3057\u305f\u308a\u3059\u308b\u3068\u304d\u306b\u3001&lt;form&gt;\u304b\u3089\u5024\u3092\u66f8\u304d\u63db\u3048\u308b\u3053\u3068\u3092\u8003\u616e\u3057\u305f\u3002<\/p>\n<h6>$.getJSON(query_json, function(json) { &#8230;. });<\/h6>\n<p><em>jQuery<\/em>\u306e<em>getJSON()<\/em>\u306b\u3088\u3063\u3066query_json\u3067\u6307\u5b9a\u3055\u308c\u308bURL\u304b\u3089json\u30c7\u30fc\u30bf\u3092GET\u3057\u3066\u304f\u308b\u3002\u3046\u307e\u304f\u3068\u308c\u305f\u3089\u3001{ &#8230; } \u306e\u90e8\u5206\u306e\u51e6\u7406\u304c\u8d70\u308b\u3002\u3046\u307e\u304f\u3068\u308c\u305f\u3068\u304d\u306b\u306f<em><strong>google.visualization.DataTable<\/strong><\/em>\u00a0\u306b\u53d6\u5f97\u3057\u3066\u304d\u305f\u30c7\u30fc\u30bf\u3092\u5c55\u958b\u3057\u3066\u3044\u308b\u304c\u3001\u305d\u3053\u3067\u306f\u3001<\/p>\n<ul>\n<li>DataTable\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u8ffd\u52a0\u3059\u308b\u884c\u6570\u3092\u6307\u5b9a\uff08<em>addRows()<\/em>\uff09<\/li>\n<li>DataTable\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u69cb\u6210\u306e\u6307\u5b9a\uff08<em>addColumn()<\/em>\uff09<\/li>\n<li>\u958b\u59cb\uff0f\u7d42\u4e86\u65e5\u6642\u306e\u53d6\u5f97\uff08first, last\uff09<\/li>\n<li>\u6587\u5b57\u5217\u3068\u3057\u3066\u9001\u3089\u308c\u3066\u304f\u308b\u65e5\u4ed8\uff08v.datetime\uff09\u3092javaScript\u306eDate\u306b\u5909\u63db<\/li>\n<li>\u7cfb\u5217\u30c7\u30fc\u30bf\u306e\u30bb\u30c3\u30c8\uff08 <em>data.setValue(&#8230;)<\/em>\uff09<\/li>\n<\/ul>\n<p>\u3092\u884c\u3063\u3066\u3044\u308b\u3002\u305d\u3057\u3066\u6700\u5f8c\u306b\u3001\u6307\u5b9a\u306ediv\uff08chart_div\uff09\u306b\u00a0<strong><em>google.visualization.LineChart<\/em><em>.<\/em><em>draw()<\/em><\/strong>\u3000\u3092\u5b9f\u884c\u3057\u3066\u3044\u308b\u3002<\/p>\n<p><em><strong>var options<\/strong><\/em>\u306b\u306f\u3001<strong><em>chart.draw() <\/em><\/strong>\u6642\u306e\u5404\u7a2e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6307\u5b9a\u3057\u3066\u304a\u308a\u3001\u30b0\u30e9\u30d5\u306e\u30bf\u30a4\u30c8\u30eb\u3001\u7dda\u3084\u6587\u5b57\u306e\u5927\u304d\u3055\u3001\u63cf\u753b\u9818\u57df\uff08 <em><strong>chart_div\u00a0<\/strong><\/em>\uff09\u306b\u5360\u3081\u308b\u30c1\u30e3\u30fc\u30c8\u9818\u57df\u306e\u30b5\u30a4\u30ba\u306a\u3069\u3092\u6307\u5b9a\u3059\u308b\u3002\u30aa\u30d7\u30b7\u30e7\u30f3\u306e<em><strong>chartArea<\/strong><\/em>\u3092\u6307\u5b9a\u3057\u306a\u3044\u3068\u3001\u4f59\u767d\u306e\u5927\u304d\u306a\u9593\u5ef6\u3073\u3057\u305f\u8868\u793a\u306b\u306a\u3063\u3066\u3057\u307e\u3046\u3002<\/p>\n<h3>\u4f11\u61a9\uff12<\/h3>\n<figure id=\"attachment_4830\" aria-describedby=\"caption-attachment-4830\" style=\"width: 552px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/442d792c8f8fde687d8025d99a9dd02d.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-4830\" src=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/442d792c8f8fde687d8025d99a9dd02d-552x414.jpg\" alt=\"\u30d2\u30ab\u30b2\u30c1\u30e7\u30a6\" width=\"552\" height=\"414\" \/><\/a><figcaption id=\"caption-attachment-4830\" class=\"wp-caption-text\">\u30d2\u30ab\u30b2\u30c1\u30e7\u30a6<\/figcaption><\/figure>\n<p>\u65e5\u9670\u304c\u597d\u304d\u306a\u304f\u305b\u306b\u660e\u308b\u3044\u7a93\u306b\u304d\u305f\u30d2\u30ab\u30b2\u30c1\u30e7\u30a6\u3092\u7a93\u30ac\u30e9\u30b9\u8d8a\u3057\u306b\u64ae\u5f71\u3002<\/p>\n<h2>\u30ed\u30fc\u30bd\u30af\u30b0\u30e9\u30d5\u3082\u4f7f\u3063\u3066\u307f\u308b<\/h2>\n<p><a href=\"https:\/\/developers.google.com\/chart\/interactive\/docs\/gallery\">Google Charts\u306e\u30ae\u30e3\u30e9\u30ea\u30fc<\/a>\u306b\u306f\u3001\u3044\u308d\u3044\u308d\u306a\u30d1\u30bf\u30fc\u30f3\u306e\u30b0\u30e9\u30d5\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u308b\u3002<strong><em>google.visualization.ComboChart<\/em><\/strong>\u00a0\u3092\u4f7f\u3063\u3066\u3001\u682a\u4fa1\u306a\u3069\u306b\u4f7f\u308f\u308c\u308b\u30ed\u30fc\u30bd\u30af\u30b0\u30e9\u30d5\u3068\u6298\u308c\u7dda\u30b0\u30e9\u30d5\u3092\u7d44\u307f\u5408\u308f\u305b\u3001\u5404\u6e2c\u5b9a\u65e5\u306e\u6700\u9ad8\u6c17\u6e29\u3068\u6700\u4f4e\u6c17\u6e29\u3092\u7e26\u68d2\u306e\u77e9\u5f62\u3067\u8868\u73fe\u3057\u3066\u307f\u305f\u3002<\/p>\n<figure id=\"attachment_4836\" aria-describedby=\"caption-attachment-4836\" style=\"width: 552px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/data_candle1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-4836\" src=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/data_candle1-552x301.png\" alt=\"ComboChart\" width=\"552\" height=\"301\" \/><\/a><figcaption id=\"caption-attachment-4836\" class=\"wp-caption-text\">ComboChart\u3092\u4f7f\u3063\u305f\u6e2c\u5b9a\u30c7\u30fc\u30bf\u306e\u8868\u793a<\/figcaption><\/figure>\n<p>\u4e2d\u592e\u306b\u6e2c\u5b9a\u65e5\u3068\u5e73\u5747\u6c17\u6e29\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u304c\u3001\u3053\u308c\u306f\u30de\u30a6\u30b9\u30dd\u30a4\u30f3\u30bf\u3092\u7f6e\u3044\u305f\u3068\u304d\u306b\u3067\u3066\u304f\u308b\u30c4\u30fc\u30eb\u30c1\u30c3\u30d7\u8868\u793a\u3067\u3042\u308b\u3002\u6642\u523b\uff0800:00:00\uff09\u304c\u4f59\u8a08\u306a\u306e\u3060\u304c\u3001\u8868\u793a\u5185\u5bb9\u3092\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u308b\u3088\u3046\u3060\uff08\u3084\u3063\u3066\u307e\u305b\u3093\u3051\u3069\uff09\u3002<\/p>\n<p>\u672c\u5f53\u306f\u30ed\u30fc\u30bd\u30af\u306e\u77e9\u5f62\u306e\u4e0a\u306b\u5e73\u5747\u5024\u306e\u7dda\u3092\u63cf\u304d\u305f\u3044\u306e\u3060\u3051\u3069\u3001\u305d\u3046\u3044\u3046\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u3002\u30ed\u30fc\u30bd\u30af\u30b0\u30e9\u30d5\uff08candleSticks chart\uff09\u3067\u306f\u3001\u77e9\u5f62\u3092\u5857\u308a\u3064\u3076\u3057\u305f\u5834\u5408\u306e\u900f\u660e\u5ea6\uff08opacity\uff09\u3082\u6307\u5b9a\u3067\u304d\u306a\u3044\u3088\u3046\u3067\u3042\u308b\u3002<\/p>\n<h6>\u30c7\u30fc\u30bf\u306e\u30af\u30a8\u30ea<\/h6>\n<p>\u5404\u6e2c\u5b9a\u65e5\u6bce\u306e\u6700\u9ad8\u3001\u6700\u4f4e\u3001\u5e73\u5747\u6c17\u6e29\u3092\u5f97\u308b\u305f\u3081\u306b\u3001\u30b5\u30fc\u30d0\u30fc\u5074\u306eenvdata_db.php\u306bSQL\u306e\u96c6\u8a08\u95a2\u6570\u3092\u7528\u3044\u305f\u30e1\u30bd\u30c3\u30c9\u3092\u8ffd\u52a0\u3057\u305f\u3002<\/p>\n<pre class=\"lang:php decode:true\" title=\"envdata_db.query_candledata_json()\">public function query_candledata_json() {\r\n\tif (!$this-&gt;isConnect())\r\n\t\treturn FALSE;\r\n\t$sql = \"select min(T) as T1,max(T) as T2,avg(T) as TA, DATE(post_datetime) as datetime from envdata group by DATE(post_datetime) order by serial_no\";\r\n\t$this-&gt;last_sql = $sql;\r\n\tif (($query_result = mysqli_query($this-&gt;mysql, $sql)) == FALSE) {\r\n\t\t$this-&gt;last_error = mysqli_error($this-&gt;mysql);\r\n\t\treturn FALSE ;\r\n\t}\r\n\t$result_count = mysqli_num_rows($query_result);\r\n\t$result = array();\r\n\twhile ($r = mysqli_fetch_assoc ($query_result))\r\n\t\t$result[] = array('datetime' =&gt; str_replace(\"-\", \"\/\", $r['datetime']), 'T1' =&gt; (float)$r['T1'], 'T2' =&gt; (float)$r['T2'], 'TA' =&gt; (float)$r['TA']);\r\n\tmysqli_free_result($query_result);\r\n\t$json_result = json_encode(array('count' =&gt; $result_count, 'data' =&gt; $result), JSON_UNESCAPED_SLASHES);\r\n\treturn $json_result;\r\n}\r\n<\/pre>\n<p><strong><em>DATE(post_datetime)<\/em><\/strong>\u3067GROUP BY\u3057\u305f\u5bfe\u8c61\u304b\u3089\u3001\u6700\u9ad8\u3001\u6700\u4f4e\u3001\u5e73\u5747\u3092\u5f97\u3066\u304a\u308a\u3001\u5e73\u5747\u5024\u306f&#8217;TA&#8217;\u3068\u3044\u3046\u30ad\u30fc\u3067\u8fd4\u3059\u3002<br \/>\njavaScript\u304b\u3089\u306eGET\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u53d7\u3051\u3066\u4e0a\u8a18\u306e\u30e1\u30bd\u30c3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u3001\u524d\u306e\u3082\u306e\u3068\u307b\u3068\u3093\u3069\u540c\u3058\u306a\u306e\u3067\u7701\u7565\u3002<\/p>\n<h3>data_candle.html<\/h3>\n<p>\u4e0a\u306b\u8f09\u305b\u305f\u30b0\u30e9\u30d5\u3092\u8868\u793a\u3059\u308b\u305f\u3081\u306ehtml\u3092\u4ee5\u4e0b\u306b\u793a\u3059\u3002\u6298\u308c\u7dda\u30b0\u30e9\u30d5\u306e\u3082\u306e\u3068\u3042\u307e\u308a\u5909\u308f\u3089\u306a\u3044\u3002<\/p>\n<pre class=\"lang:js decode:true\" title=\"data_candle.html\">&lt;!DOCTYPE html&gt;\r\n&lt;html&gt;\r\n&lt;head&gt;\r\n&lt;meta charset=\"utf-8\"&gt;\r\n&lt;title&gt;Thermal and Humidity&lt;\/title&gt;\r\n&lt;script type=\"text\/javascript\" src=\"http:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.11.1\/jquery.min.js\"&gt;&lt;\/script&gt;\r\n&lt;script type=\"text\/javascript\" src=\"https:\/\/www.gstatic.com\/charts\/loader.js\"&gt;&lt;\/script&gt;\r\n&lt;script&gt;\r\n\tgoogle.charts.load(\"visualization\", \"1\", {packages: [\"corechart\"], language:\"ja\"});\r\n\tgoogle.charts.setOnLoadCallback(drawChart);\r\n\r\n\tfunction drawChart() {\r\n\t\tvar query_json = \"read_candledata_json.php\";\r\n\t\t$.getJSON(query_json, function(json) {\r\n\t\t\tvar data = new google.visualization.DataTable();\r\n\t\t\tdata.addColumn(\"datetime\", \"datetime\");\r\n\t\t\tdata.addColumn(\"number\", \"T1\");\r\n\t\t\tdata.addColumn(\"number\", \"T1\");\r\n\t\t\tdata.addColumn(\"number\", \"T2\");\r\n\t\t\tdata.addColumn(\"number\", \"T2\");\r\n\t\t\tdata.addColumn(\"number\", \"\u5e73\u5747\");\r\n\t\t\tdata.addRows(json.data.length);\r\n\t\t\tvar first = null;\r\n\t\t\tvar last = null;\r\n\t\t\t$.each(json.data, function(i, v) {\r\n\t\t\t\tlast = new Date(v.datetime);\r\n\t\t\t\tif (first == null)\r\n\t\t\t\t\tfirst = last;\r\n\t\t\t\tdata.setValue(i, 0, new Date(last));\r\n\t\t\t\tdata.setValue(i, 1, v.T1);\r\n\t\t\t\tdata.setValue(i, 2, v.T1);\r\n\t\t\t\tdata.setValue(i, 3, v.T2);\r\n\t\t\t\tdata.setValue(i, 4, v.T2);\r\n\t\t\t\tdata.setValue(i, 5, v.TA);\r\n\t\t\t});\r\n\t\t\tvar options = {\r\n\t\t\t\ttitle: \"\u30bb\u30f3\u30b5\u30fc\u30c7\u30fc\u30bf (\" + json.count + \"\u4ef6)  [\" + first.toLocaleDateString() + \" \uff5e \" + last.toLocaleDateString() + \"] \",\r\n\t\t\t\tfontSize: 14,legend: 'none',\r\n\t\t\t\tvAxis: {title: '\u6e29\u5ea6'}, hAxis: {title: '\u65e5\u4ed8'},\r\n\t\t\t\tchartArea: {left: '80px', top: '80px', width: \"82%\", height: \"80%\"},\r\n\t\t\t\tseriesType: 'candlesticks',\r\n\t\t\t\tseries : { 0: {color: 'green'},  1: {type: 'line'}}\r\n\t\t\t};\r\n\t\t\tvar chart = new google.visualization.ComboChart(document.getElementById(\"chart_div\"));\r\n\t\t\tchart.draw(data, options);\r\n\t\t});\r\n\t}\r\n&lt;\/script&gt;\r\n&lt;style&gt;\r\ndiv#chart_div { height: 500px; width: 100%; border: 1px solid #000000; }\r\n&lt;\/style&gt;\r\n&lt;\/head&gt;\r\n&lt;body&gt;\r\n&lt;div id=\"chart_div\"&gt;&lt;\/div&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n<p>\u57fa\u672c\u7684\u306a\u69cb\u9020\u3084\u6d41\u308c\u306e\u8aac\u660e\u306f\u7701\u7565\u3002<em>ComboChart<\/em>\u3067\u306f\u8907\u6570\u7a2e\u985e\u306e\u30b0\u30e9\u30d5\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u306b\u306a\u308b\u306e\u3067\u3001\u30c7\u30fc\u30bf\u7cfb\u5217\u3054\u3068\u306e\u30b0\u30e9\u30d5\u306e\u7a2e\u5225\u3092\u6307\u5b9a\u3057\u3066\u3084\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/p>\n<h6>DataTable\u306e\u69cb\u6210<\/h6>\n<p>candlestick chart\u3092\u4f7f\u3046\u5834\u5408\u3001X\u8ef8\u306e\u50241\u3064\u306b\u5bfe\u3057\u30664\u3064\u306e\u5024\u304c\u5fc5\u8981\u306b\u306a\u308b\uff08\u5e02\u5834\u53d6\u5f15\u3067\u306e\u3001\u5b89\u5024\u3001\u59cb\u5024\u3001\u7d42\u5024\u3001\u9ad8\u5024\u306b\u5bfe\u5fdc\uff09\u3002\u4eca\u56de\u306f\u6700\u4f4e\u6c17\u6e29\u3001\u6700\u9ad8\u6c17\u6e29\u306e2\u3064\u3057\u304b\u306a\u3044\u306e\u3067\u3001\u304a\u306e\u304a\u306e2\u56de\u305a\u3064\u00a0<em>addColumn()<\/em> \u3057\u3066\u3084\u308a\u3001\u6700\u5f8c\u306b\u5e73\u5747\u5024\u3092\u00a0<em>addColumn()<\/em>\u3057\u30012\u7cfb\u5217\u306e\u30c7\u30fc\u30bf\u3068\u3057\u3066\u3044\u308b\u3002DataTable\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u5bfe\u3059\u308b\u00a0<em>setValue()<\/em>\u306b\u3064\u3044\u3066\u3082\u540c\u69d8\u3002<\/p>\n<h6>var options\u5185\u306eseriesType: &#8216;candlesticks&#8217;<\/h6>\n<p>\u30b0\u30e9\u30d5\u5168\u4f53\u306e\u4e3b\u305f\u308b\u30bf\u30a4\u30d7\u3092\u3001\u30ed\u30fc\u30bd\u30af\u30b0\u30e9\u30d5\u306b\u5bfe\u5fdc\u3059\u308b\u00a0<em><strong>&#8216;candlesticks&#8217;<\/strong><\/em> \u3068\u3057\u3066\u3044\u308b\u3002<\/p>\n<h6>series : { 0: {color: &#8216;green&#8217;}, \u00a01: {type: &#8216;line&#8217;}}<\/h6>\n<p>\u6700\u521d\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\uff080\u756a\uff09\u306f\u4e3b\u305f\u308b\u30bf\u30a4\u30d7\u306e\u00a0<em><strong>candlesticks<\/strong><\/em>\u00a0\u306b\u306a\u308b\u304c\u3001\u305d\u306e\u8272\u3092\u6307\u5b9a\u3057\u3066\u3044\u308b\u3002\u30c7\u30fc\u30bf\u7cfb\u52171\u756a\u306etype\u3092\u3001<em><strong>&#8216;line&#8217;<\/strong><\/em> \u3068\u3059\u308b\u3053\u3068\u3067\u5e73\u5747\u5024\u3092\u7dda\u30b0\u30e9\u30d5\u3068\u3057\u3066\u63cf\u753b\u3055\u305b\u308b\u3002<\/p>\n<p>\u6700\u5f8c\u306b\u3001<strong><em>google.visualization.ComboChart.draw()<\/em><\/strong>\u00a0\u3092\u4f7f\u3063\u3066\u63cf\u753b\u3057\u3066\u3044\u308b\u3002<\/p>\n<h2>\u7cfb\u5217\u9593\u306e\u30a4\u30f3\u30bf\u30fc\u30d0\u30eb\u8868\u793a<\/h2>\n<p>\u30ed\u30fc\u30bd\u30af\u30b0\u30e9\u30d5\u3092\u4f7f\u3063\u305f\u8868\u793a\u304c\u4eca\u4e00\u3064\u6e80\u8db3\u3067\u304d\u306a\u304b\u3063\u305f\u306e\u3067\u3001isStacked: true\u3068\u3057\u305fColumnChart\uff08\u7a4d\u307f\u91cd\u306d\u68d2\u30b0\u30e9\u30d5\uff09\u3068LineChart\u3092\u7d44\u307f\u5408\u308f\u305b\u3001\u68d2\u30b0\u30e9\u30d5\u4e2d\u306e\u7279\u5b9a\u306e\u7cfb\u5217\u8868\u793a\u8272\u3092transparent\u306b\u3059\u308b\u3001\u306a\u3093\u3066\u3044\u3046\u3053\u3068\u3082\u3084\u3063\u3066\u306f\u307f\u305f\u3002<\/p>\n<figure id=\"attachment_4839\" aria-describedby=\"caption-attachment-4839\" style=\"width: 552px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/data_column.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-4839\" src=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/data_column-552x301.png\" alt=\"data_column\" width=\"552\" height=\"301\" \/><\/a><figcaption id=\"caption-attachment-4839\" class=\"wp-caption-text\">stacked column chart<\/figcaption><\/figure>\n<p>\u753b\u50cf\u3067\u306f\u4f1d\u308f\u308a\u306b\u304f\u3044\u304c\u3001\u3044\u308d\u3044\u308d\u3068\u4eca\u4e00\u3064\u306a\u306e\u3067\u3042\u308b\u3002<br \/>\n\u3088\u308a\u826f\u3055\u305d\u3046\u306a\u30c1\u30e3\u30fc\u30c8\u3092\u63a2\u3057\u3066\u3044\u305f\u3089\u3001\u91cd\u8981\u306a\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u5f37\u8abf\u3057\u3064\u3064\u3001\u305d\u308c\u306b\u4ed8\u968f\u3059\u308b\u8907\u6570\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u540c\u6642\u306b\u63cf\u753b\u3059\u308b <a href=\"https:\/\/developers.google.com\/chart\/interactive\/docs\/gallery\/intervals\">Intervals<\/a> \u3068\u3044\u3046\u6a5f\u80fd\u3092\u898b\u3064\u3051\u305f\u306e\u3067\u3001\u3055\u3063\u305d\u304f\u4f7f\u3063\u3066\u307f\u305f\u3002<\/p>\n<h3>\u30a4\u30f3\u30bf\u30fc\u30d0\u30eb\u8868\u793a\u3044\u308d\u3044\u308d<\/h3>\n<p>\u5148\u307b\u3069\u306e\u30ed\u30fc\u30bd\u30af\u30b0\u30e9\u30d5\u3068\u540c\u3058\u30c7\u30fc\u30bf\u3092\u7528\u3044\u3066\u3001\u3068\u308a\u3042\u3048\u305a3\u7a2e\u985e\u306e\u30a4\u30f3\u30bf\u30fc\u30d0\u30eb\u8868\u793a\u3092\u884c\u3063\u3066\u307f\u305f\u3002html\u306f\u5171\u901a\u3067\u3001\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3\u306b\u5bfe\u3059\u308b\u64cd\u4f5c\u3067\u7a2e\u985e\u3092\u5909\u3048\u3066\u518d\u8868\u793a\u3055\u305b\u308b\u3088\u3046\u306b\u3057\u305f\u3002<\/p>\n<figure id=\"attachment_4841\" aria-describedby=\"caption-attachment-4841\" style=\"width: 552px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/data_interval1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-4841\" src=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/data_interval1-552x301.png\" alt=\"bar interval\" width=\"552\" height=\"301\" \/><\/a><figcaption id=\"caption-attachment-4841\" class=\"wp-caption-text\">\u5e73\u5747\u5024\u306b\u5bfe\u3059\u308b\u5909\u4f4d\u3092\u7e26\u68d2\u3067\u8868\u73fe<\/figcaption><\/figure>\n<figure id=\"attachment_4843\" aria-describedby=\"caption-attachment-4843\" style=\"width: 552px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/data_interval3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-4843\" src=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/data_interval3-552x302.png\" alt=\"box interval\" width=\"552\" height=\"302\" \/><\/a><figcaption id=\"caption-attachment-4843\" class=\"wp-caption-text\">\u5909\u4f4d\u3092\u77e9\u5f62\u3067\u8868\u73fe<\/figcaption><\/figure>\n<figure id=\"attachment_4842\" aria-describedby=\"caption-attachment-4842\" style=\"width: 552px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/data_interval2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4842 size-large\" src=\"https:\/\/okiraku-camera.tokyo\/blog\/wp-content\/uploads\/2016\/09\/data_interval2-552x301.png\" alt=\"line interval\" width=\"552\" height=\"301\" \/><\/a><figcaption id=\"caption-attachment-4842\" class=\"wp-caption-text\">\u6700\u9ad8\u3001\u6700\u4f4e\u3068\u5e73\u5747\u6e29\u5ea6\u3092\u7dda\u3067\u8868\u73fe<\/figcaption><\/figure>\n<h2>data_interval.html<\/h2>\n<p>\u3053\u308c\u3089\u306e\u30a4\u30f3\u30bf\u30fc\u30d0\u30eb\u8868\u793a\u3092\u884c\u3046\u305f\u3081\u306ehtml\u3092\u4ee5\u4e0b\u306b\u793a\u3059\u3002\u30b0\u30e9\u30d5\u8868\u793a\u306e\u5909\u66f4\u306f\u3001<em><strong>google.visualization.LineChart.draw()<\/strong><\/em> \u306b\u63cf\u753b\u30aa\u30d7\u30b7\u30e7\u30f3\u3068\u3057\u3066\u4e0e\u3048\u308b\u30d7\u30ed\u30d1\u30c6\u30a3\u5024\u3060\u3051\u3067\u5909\u5316\u3059\u308b\u306e\u3067\u3001\u753b\u9762\u4e0a\u306eform\u8981\u7d20\u306b\u5bfe\u3059\u308b\u64cd\u4f5c\u3067\u8868\u793a\u304c\u5207\u308a\u63db\u308f\u308b\u3088\u3046\u306b\u3057\u305f\u3002<\/p>\n<pre class=\"lang:js decode:true \" title=\"data_interval.html\">&lt;!DOCTYPE html&gt;\r\n&lt;html&gt;\r\n&lt;head&gt;\r\n&lt;meta charset=\"utf-8\"&gt;\r\n&lt;title&gt;Thermal and Humidity&lt;\/title&gt;\r\n&lt;script type=\"text\/javascript\" src=\"http:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.11.1\/jquery.min.js\"&gt;&lt;\/script&gt;\r\n&lt;script type=\"text\/javascript\" src=\"https:\/\/www.gstatic.com\/charts\/loader.js\"&gt;&lt;\/script&gt;\r\n&lt;script&gt;\r\n\tgoogle.charts.load(\"visualization\", \"1\", {packages: [\"corechart\"], language:\"ja\"});\r\n\tgoogle.charts.setOnLoadCallback(drawChart);\r\n\tvar interval_style = {'style' : 'line'};\r\n\tfunction drawChart() {\r\n\t\tvar query_json = \"read_candledata_json.php\";\r\n\t\t$.getJSON(query_json, function(json) {\r\n\t\t\tvar data = new google.visualization.DataTable();\r\n\t\t\tdata.addColumn(\"datetime\", \"datetime\");\r\n\t\t\tdata.addColumn(\"number\", \"\u5e73\u5747\");\r\n\t\t\tdata.addColumn({id:'T1', type:'number', role:'interval'});\r\n\t\t\tdata.addColumn({id:'T2', type:'number', role:'interval'});\r\n\t\t\tdata.addRows(json.data.length);\r\n\t\t\tvar first = null;\r\n\t\t\tvar last = null;\r\n\t\t\t$.each(json.data, function(i, v) {\r\n\t\t\t\tlast = new Date(v.datetime);\r\n\t\t\t\tif (first == null)\r\n\t\t\t\t\tfirst = last;\r\n\t\t\t\tdata.setValue(i, 0, new Date(last));\r\n\t\t\t\tdata.setValue(i, 1, v.TA);\r\n\t\t\t\tdata.setValue(i, 2, v.T1);\r\n\t\t\t\tdata.setValue(i, 3, v.T2);\r\n\t\t\t});\r\n\t\t\tvar options = {\r\n\t\t\t\ttitle: \"\u30bb\u30f3\u30b5\u30fc\u30c7\u30fc\u30bf (\" + json.count + \"\u4ef6)  [\" + first.toLocaleDateString() + \" \uff5e \" + last.toLocaleDateString() + \"] \",\r\n\t\t\t\tfontSize: 14, vAxis: {title: '\u6e29\u5ea6'}, hAxis: {title: '\u65e5\u4ed8'}, legend: 'none',\r\n\t\t\t\tchartArea: {left: '80px', top: '80px', width: \"80%\", height: \"80%\"},\r\n\t\t\t\tcurveType: 'function'\r\n\t\t\t};\r\n\t\t\toptions.intervals = interval_style;\r\n\t\t\tvar chart = new google.visualization.LineChart(document.getElementById(\"chart_div\"));\r\n\t\t\tchart.draw(data, options);\r\n\t\t});\r\n\t}\r\n\t\r\n\tfunction redrawChart(s) {\r\n\t\tinterval_style['style'] = s;\r\n\t\tdrawChart();\r\n\t\treturn true;\r\n\t}\r\n\t\r\n&lt;\/script&gt;\r\n&lt;style&gt;\r\ndiv#chart_div { height: 500px; width: 100%; border: 1px solid #000000; }\r\n&lt;\/style&gt;\r\n&lt;\/head&gt;\r\n&lt;body&gt;\r\n&lt;div id=\"chart_div\"&gt;&lt;\/div&gt;\r\n&lt;form onsubmit='javaScript:void(0);'&gt;\r\n&lt;input type=\"radio\" name=\"types\" value=\"line\" checked=\"true\" onclick=\"return redrawChart(this.value);\"&gt;line&lt;\/input&gt;\r\n&lt;input type=\"radio\" name=\"types\" value=\"bars\" onclick=\"return redrawChart(this.value);\"&gt;bars&lt;\/input&gt;\r\n&lt;input type=\"radio\" name=\"types\" value=\"boxes\" onclick=\"return redrawChart(this.value);\"&gt;boxes&lt;\/input&gt;\r\n&lt;\/form&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;\r\n\r\n<\/pre>\n<p>\u57fa\u672c\u7684\u306b\u306fLineChart\u306a\u306e\u3060\u304c\u3001<em>google.visualization.DataTable <\/em>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u5bfe\u3057\u3066\u30ab\u30e9\u30e0\u69cb\u6210\u3092\u6307\u5b9a\u3059\u308b\u3068\u304d\u3001<em><strong>role:&#8217;interval&#8217;<\/strong><\/em>\u3000\u3068\u3057\u3066\u30ab\u30e9\u30e0\u306b\u5f79\u5272\u3092\u4e0e\u3048\u3066\u3044\u308b\u70b9\u304c\u3001\u5358\u7d14\u306a\u30b0\u30e9\u30d5\u3068\u7570\u306a\u308b\u70b9\u306b\u306a\u308b\u3002\u8a73\u3057\u304f\u306f<a href=\"https:\/\/developers.google.com\/chart\/interactive\/docs\/roles\">\u3053\u3061\u3089\u3092\u53c2\u7167<\/a>\u306e\u3053\u3068\u3002<\/p>\n<p>\u8868\u793a\u3059\u308b\u30b0\u30e9\u30d5\u306e\u5207\u63db\u306f\u3001<em>chart_div<\/em> \u306e\u4e0b\u306b\u4f5c\u3063\u305fhtml\u30d5\u30a9\u30fc\u30e0\u306b\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3\u3092\u914d\u7f6e\u3057\u3001<em>options.intervals<\/em> \u306b\u4e0e\u3048\u308b\u30d7\u30ed\u30d1\u30c6\u30a3\u5024\u3092\u4f5c\u308a\u3001<em>draw_chart()<\/em> \u3055\u305b\u308b\u3053\u3068\u3067\u5b9f\u73fe\u3057\u3066\u3044\u308b\u3002<\/p>\n<h3>\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u3068\u30d5\u30a1\u30a4\u30eb<\/h3>\n<p>\u3053\u306e\u30d6\u30ed\u30b0\u5185\u306b\u3082\u3001<em><a href=\"https:\/\/okiraku-camera.tokyo\/blog\/data\/data_interval.html\">data_interval.html<\/a><\/em> \u3092\u7f6e\u3044\u305f\u306e\u3067\u8208\u5473\u306e\u3042\u308b\u65b9\u306f\u3069\u3046\u305e\u3002\u3055\u3059\u304c\u306b\u3001\u30bb\u30f3\u30b5\u30fc\u3068\u76f4\u7d50\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u7f6e\u304d\u305f\u304f\u306a\u304b\u3063\u305f\u306e\u3067\u3001\u8868\u793a\u7528\u306ejson\u30c7\u30fc\u30bf (<em>data_sample1.json<\/em>) \u3082\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u914d\u7f6e\u3057\u3001<em>$.getJSON()<\/em> \u306e\u8aad\u307f\u8fbc\u307f\u5148\u3092\u5909\u66f4\u3057\u305f\u3002\u6c17\u304c\u5411\u3044\u305f\u3089\u3001\u305f\u307e\u306b\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u5165\u308c\u66ff\u3048\u307e\u3059\u3002<\/p>\n<h1>\u307e\u3068\u3081<\/h1>\n<ul>\n<li>\u3082\u3068\u3082\u3068\u306f\u3001WROOM02\u3068\u6e29\u5ea6\uff0f\u6e7f\u5ea6\u30bb\u30f3\u30b5\u30fc\u3092\u4f7f\u3063\u305f\u3061\u3087\u3063\u3068\u3057\u305f\u5de5\u4f5c\u306e\u3064\u3082\u308a\u3060\u3063\u305f\u304c\u3001\u7d50\u679c\u3068\u3057\u3066\u30c7\u30fc\u30bf\u306e\u84c4\u7a4d\u3084\u8868\u793a\u306b\u91cd\u304d\u3092\u304a\u304f\u3053\u3068\u306b\u306a\u3063\u3066\u3057\u307e\u3063\u305f\u3002\u898b\u76f4\u3055\u308c\u306a\u3044\u30c7\u30fc\u30bf\u306b\u306f\u3042\u307e\u308a\u610f\u5473\u304c\u306a\u3044\u304b\u3089\u3001\u4eca\u56deGoogle Charts \u3092\u3044\u308d\u3044\u308d\u89e6\u308b\u3053\u3068\u304c\u3067\u304d\u305f\u306e\u306f\u826f\u304b\u3063\u305f\u3002<\/li>\n<li>\u6e2c\u5b9a\u958b\u59cb\u5f53\u6642\u306b\u30bb\u30f3\u30b5\u30fc\u3092\u7f6e\u3044\u3066\u3044\u305f\u90e8\u5c4b\u306b\u306f\u30a8\u30a2\u30b3\u30f3\u304c\u5165\u3063\u3066\u3044\u305f\u306e\u3067\u3001\u6700\u4f4e\uff0d\u6700\u9ad8\u6e29\u5ea6\u306b\u3051\u3063\u3053\u3046\u306a\u5dee\u304c\u3067\u3066\u3044\u305f\u3002\u4eba\u304c\u3044\u306a\u3044\u9593\u306f\u30a8\u30a2\u30b3\u30f3\u304c\u6b62\u307e\u308b\u306e\u3067\u3001\u5e73\u5747\u6e29\u5ea6\u304c\u9ad8\u3081\u306a\u306e\u306f\u7d0d\u5f97\u3067\u304d\u308b\u3002<br \/>\n\u9014\u4e2d\u304b\u3089\u7121\u4eba\u306e\u90e8\u5c4b\u306b\u8a2d\u7f6e\u3057\u305f\u306e\u3067\u3001\u6e29\u5ea6\u306e\u5909\u5316\u304c\u5c11\u306a\u304f\u3001\u306a\u304a\u304b\u3064\u9ad8\u6b62\u307e\u308a\u3057\u3066\u3044\u308b\u304c\u3001\u3053\u308c\u3082\u5b63\u7bc0\u306e\u63a8\u79fb\u3067\u3060\u3093\u3060\u3093\u3068\u5909\u308f\u3063\u3066\u3044\u304f\u3060\u308d\u3046\u3002<\/li>\n<li>\u6e29\u5ea6\u8a08\u6e2c\u3068\u30ed\u30ae\u30f3\u30b0\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u306e\u3067\u3001\u6b21\u306f\u540c\u3058\u30d6\u30ec\u30c3\u30c9\u30dc\u30fc\u30c9\u306b\u8d64\u5916\u7dda\u30ea\u30e2\u30b3\u30f3\u6a5f\u80fd\u3092\u8f09\u305b\u3001\u30a8\u30a2\u30b3\u30f3\u305d\u306e\u4ed6\u81ea\u52d5\u30aa\u30f3\uff0f\u30aa\u30d5\u3067\u3082\u3084\u3063\u3066\u307f\u308b\u4e88\u5b9a\u3002\u307e\u305f\u3001\u30b5\u30fc\u30d0\u30fc\u306b\u304a\u3044\u305f\u30b3\u30de\u30f3\u30c9\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u307f\u3001\u305d\u308c\u306b\u5fdc\u3058\u3066\u30ea\u30e2\u30b3\u30f3\u3092\u52d5\u304b\u3059\u3068\u304b\u3082\u8003\u3048\u3089\u308c\u308b\u3002<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981 WROOM-02\u3067\u6e29\u5ea6\uff0f\u6e7f\u5ea6\u8a08\u6e2c\u3000\u305d\u306e\uff11\u3067\u306f\u3001WROOM-02\u3068HDC-1000\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u3001\u6e29\u5ea6\u3068\u6e7f\u5ea6\u3092\u5b9a\u671f\u7684\u306b\u6e2c\u5b9a\u3057\u30b5\u30fc\u30d0\u30fc\u306b\u9001\u4fe1\u3059\u308b\u305f\u3081\u306e\u4ed5\u7d44\u307f\u306b\u3064\u3044\u3066\u63b2\u8f09\u3057\u305f\u3002\u305d\u306e\u5f8c\u3001\u305f\u307e\u306b\u8a2d\u7f6e\u5834\u6240\u3092\u5909\u3048\u3066\u306f\u3044\u308b\u304c\u3001\u307b\u307c &hellip; <a href=\"https:\/\/okiraku-camera.tokyo\/blog\/?p=4790\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">WROOM-02\u3067\u6e29\u5ea6\uff0f\u6e7f\u5ea6\u8a08\u6e2c\u3000\u305d\u306e\uff12<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,69],"tags":[78,77],"class_list":["post-4790","post","type-post","status-publish","format-standard","hentry","category-pc","category-programming","tag-php","tag-wroom02"],"_links":{"self":[{"href":"https:\/\/okiraku-camera.tokyo\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/okiraku-camera.tokyo\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/okiraku-camera.tokyo\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/okiraku-camera.tokyo\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/okiraku-camera.tokyo\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4790"}],"version-history":[{"count":0,"href":"https:\/\/okiraku-camera.tokyo\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4790\/revisions"}],"wp:attachment":[{"href":"https:\/\/okiraku-camera.tokyo\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/okiraku-camera.tokyo\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/okiraku-camera.tokyo\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}