{"id":292234,"date":"2019-07-18T09:02:33","date_gmt":"2019-07-18T09:02:33","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=292234"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=292234","title":{"rendered":"\u0414\u0430\u0442\u0447\u0438\u043a \u0442\u0435\u043c\u043f\u0435\u0440\u0430\u0442\u0443\u0440\u044b \u0438 \u0432\u043b\u0430\u0436\u043d\u043e\u0441\u0442\u0438 \u043d\u0430 \u0430\u0440\u0434\u0443\u0438\u043d\u043e \u0441 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u043e\u0439 \u0438 \u043e\u0442\u0440\u0438\u0441\u043e\u0432\u043a\u043e\u0439 \u0433\u0440\u0430\u0444\u0438\u043a\u0430 (\u0427\u0430\u0441\u0442\u044c1)"},"content":{"rendered":"\n
\u041e\u0441\u043d\u043e\u0432\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439 \u043f\u0440\u043e\u0435\u043a\u0442\u0430 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 \u0442\u0435\u043c\u043f\u0435\u0440\u0430\u0442\u0443\u0440\u044b \u0432 \u0442\u0435\u043f\u043b\u0438\u0446\u0435 \u0443\u0434\u0430\u043b\u0435\u043d\u043d\u043e\u0439 \u043e\u0442 \u0434\u043e\u043c\u0430 \u043d\u0430 11-15 \u043c\u0435\u0442\u0440\u043e\u0432. \u0411\u0435\u0437 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u0438 \u043f\u0440\u043e\u043a\u043b\u0430\u0434\u043a\u0438 UTP \u0438 \u043f\u0438\u0442\u0430\u043d\u0438\u044f \u0434\u043e \u043d\u0435\u0435.
<\/a>
\u0422\u0435\u043f\u043b\u0438\u0447\u043d\u0430\u044f \u0447\u0430\u0441\u0442\u044c:<\/p>\n
    \n
  1. \u0421\u043d\u044f\u0442\u044c \u0442\u0435\u043c\u043f\u0435\u0440\u0430\u0442\u0443\u0440\u0443\/\u0432\u043b\u0430\u0436\u043d\u043e\u0441\u0442\u044c \u0434\u0430\u0442\u0447\u0438\u043a\u043e\u043c DHT-11 \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 pro micro<\/li>\n
  2. \u041e\u0442\u043f\u0440\u0430\u0432\u0438\u0442\u044c fs1000a \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 pro micro<\/li>\n<\/ol>\n

    \u0414\u043e\u043c\u0430\u0448\u043d\u044f\u044f \u0447\u0430\u0441\u0442\u044c:<\/p>\n

      \n
    1. \u041f\u0440\u0438\u043d\u044f\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u043d\u0430 mx-rm-5v \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 Uno<\/li>\n
    2. \u041e\u0442\u043f\u0440\u0430\u0432\u0438\u0442\u044c \u043d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440 \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 Ethernet shield (WIZNET W5100HR911105A<\/s>)<\/li>\n
    3. \u0417\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u0432 \u0431\u0430\u0437\u0443 mysql<\/li>\n
    4. \u041e\u0442\u0440\u0438\u0441\u043e\u0432\u0430\u0442\u044c \u0433\u0440\u0430\u0444\u0438\u043a (jpgraph)<\/li>\n<\/ol>\n

      <\/p>\n

      \u041d\u0430\u0447\u0430\u043b \u043d\u0435\u043c\u043d\u043e\u0433\u043e \u043d\u0435 \u043f\u043e \u043f\u043e\u0440\u044f\u0434\u043a\u0443. \u0414\u043b\u044f \u043c\u0435\u043d\u044f \u0434\u0430\u043d\u043d\u0430\u044f \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u043e\u043a\u0430\u0437\u0430\u043b\u0430\u0441\u044c \u0431\u043e\u043b\u0435\u0435 \u0441\u043b\u043e\u0436\u043d\u043e\u0439 \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u0440\u0435\u0448\u0438\u043b \u0435\u0435 \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u044b\u0432\u0430\u0442\u044c \u0432\u043d\u0430\u0447\u0430\u043b\u0435.<\/p>\n

      \u0421\u043f\u0438\u0441\u043e\u043a \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u044b\u0445 \u043f\u0430\u043a\u0435\u0442\u043e\u0432 \u043d\u0435 \u043e\u0433\u0440\u043e\u043c\u0435\u043d \u0438 \u0437\u0430\u0432\u0438\u0441\u0438\u0442 \u043e\u0442 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u0430, \u0430 \u0438\u043c\u0435\u043d\u043d\u043e nginx, php-gd, php-mysql, mysql-server. \u0414\u043b\u044f jpgraph \u043c\u043e\u0433\u0443\u0442 \u043f\u043e\u043d\u0430\u0434\u043e\u0431\u0438\u0442\u044c\u0441\u044f ttf \u0448\u0440\u0438\u0444\u0442\u044b.<\/p>\n

      \u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u043c nginx<\/b><\/p>\n
      \n
      server { listen 80; listen [::]:80; root \/var\/www\/html;  location \/ {                } location ~ \\.php$ {     include fastcgi_params;     fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;     # With php7.0-cgi alone:     # fastcgi_pass 127.0.0.1:9000;     # With php7.0-fpm:     fastcgi_pass unix:\/var\/run\/php\/php7.2-fpm.sock;     fastcgi_buffer_size 128k;     fastcgi_buffers 256 32k;     fastcgi_busy_buffers_size 256k;     fastcgi_temp_file_write_size 256k;     fastcgi_connect_timeout 1s;     fastcgi_ignore_client_abort off;     fastcgi_next_upstream timeout;     fastcgi_read_timeout 5m;     fastcgi_send_timeout 5m;     } } <\/code><\/pre>\n
        <\/div>\n<\/div>\n
        \u0414\u043b\u044f uno \u043d\u0430\u043c \u043d\u0443\u0436\u043d\u044b \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438:
        SPI.h
        Ethernet.h
        DHT.h<\/p>\n
      \u041a\u043e\u0434 \u0434\u043b\u044f UNO<\/b><\/p>\n
      \n
      #include <SPI.h> #include <Ethernet.h> #include <DHT.h>  \/\/ MAC address for controller byte mac[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED }; \/\/\u0410\u0434\u0440\u0435\u0441 \u0448\u0438\u043b\u0434\u0430 byte ip[] = { 192, 168, 156, 192 }; \/\/\u041c\u0430\u0441\u043a\u0430 byte subnet[] = { 255, 255, 255, 0 }; \/\/\u0428\u043b\u044e\u0437 byte gateway[] = { 192, 168, 0, 1 }; \/\/\u0410\u0434\u0440\u0435\u0441 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0441 \u0431\u0430\u0437\u043e\u0439 char server[] = \"192.168.156.186\"; #define DHTPIN 2 #define DHTTYPE DHT11 DHT dht(DHTPIN, DHTTYPE);   \/\/\u0417\u0430\u043f\u0443\u0441\u043a \u043a\u043b\u0438\u0435\u043d\u0442\u0430 EthernetClient client;  void setup()  {  dht.begin();         Serial.begin(9600);     while (!Serial) {         ; \/\/ wait for serial port to connect     }     {        Ethernet.begin(mac,ip,gateway,subnet);     }      \/\/ give the Ethernet shield a second to initialize     delay(1000);    }  void loop() {   if (client.connect(server, 80))   {   \/\/ give the Ethernet shield a second to initialize   float h = dht.readHumidity();   float t = dht.readTemperature();          Serial.println(\"connected\");         \/\/ \u041e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c GET \u0437\u0430\u043f\u0440\u043e\u0441 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438         client.println(String(\"GET \/index.php?temp=\")+ t +\"&hum=\"+h);            client.println();         Serial.println(\"connection close\");       } else Serial.println(\"connection failed\");       delay(60000); }<\/code><\/pre>\n
        <\/div>\n<\/div>\n
        C\u043a\u0435\u0442\u0447 \u043a\u0430\u0436\u0434\u0443\u044e \u043c\u0438\u043d\u0443\u0442\u0443 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u0442 GET \u0437\u0430\u043f\u0440\u043e\u0441 \u0441\u043a\u0440\u0438\u043f\u0442\u0443 (index.php):<\/p>\n
      index.php<\/b><\/p>\n
      \n
      <?php \/**  * @param string            $message  * @param PDOException|null $exception  *\/ function writeMessage($message, $exception = null) {     $logfile = '\/var\/www\/html\/data\/arduino.log';     $datetime = date('d.m.Y H:i:s', time());      if ($exception !== null) {         $message .= ': ' . $exception->getFile() . ' (line: ' . $exception->getLine() . ') - ' . $exception->getMessage();     }      file_put_contents($logfile, '[' . $datetime . '] ' . $message.\"\\n\", FILE_APPEND); }  \/* \u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043a \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0432\u044b\u0437\u043e\u0432\u0430 \u0434\u0440\u0430\u0439\u0432\u0435\u0440\u0430 *\/ $dsn = 'mysql:dbname=greenhouse;host=localhost'; $user = 'arduino'; $password = '\u043f\u0430\u0440\u043e\u043b';  try {     $dbh = new PDO($dsn, $user, $password, [         PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,         PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,         PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',     ]); } catch (PDOException $e) {     writeMessage('\u041f\u0440\u043e\u0438\u0437\u043e\u0448\u043b\u0430 \u043e\u0448\u0438\u0431\u043a\u0430', $e); }  try {     $sth = $dbh->prepare('INSERT INTO data (sensor, temperature, humidity, created_at) VALUES (?, ?, ?, NOW())');     $sth->execute(['grass', $_REQUEST['temp'], $_REQUEST['hum']]);  } catch (PDOException $e) {     writeMessage('\u041f\u0440\u043e\u0438\u0437\u043e\u0448\u043b\u0430 \u043e\u0448\u0438\u0431\u043a\u0430', $e); } <\/code><\/pre>\n
        <\/div>\n<\/div>\n
        \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432 \u0441\u0432\u043e\u044e \u043e\u0447\u0435\u0440\u0435\u0434\u044c \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0432 \u0431\u0430\u0437\u0443:<\/p>\n
      \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/b><\/p>\n
      \n
      CREATE DATABASE `greenhouse` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;<\/code><\/pre>\n
        <\/p>\n
      CREATE TABLE `table` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `sensor` varchar(255) DEFAULT NULL,   `temperature` decimal(6,3) DEFAULT '0.00',   `humidity` decimal(6,3) DEFAULT '0.00',   `created_at` datetime DEFAULT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;<\/code><\/pre>\n
        <\/div>\n<\/div>\n
      \u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0438 \u0432\u044b\u0434\u0430\u0435\u043c \u043f\u0440\u0430\u0432\u0430<\/b><\/p>\n
      \n
      CREATE USER 'arduino'@''' IDENTIFIED BY '\u043f\u0430\u0440\u043e\u043b';<\/code><\/pre>\n
        <\/p>\n
      GRANT ALL PRIVILEGES ON * . * TO 'arduino'@'';<\/code><\/pre>\n
        <\/p>\n
      FLUSH PRIVILEGES;<\/code><\/pre>\n
        <\/div>\n<\/div>\n
        \u041f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c:<\/p>\n
      select * from data;<\/code><\/pre>\n
        <\/p>\n
      +-----+--------+-------------+----------+---------------------+ | id  | sensor | temperature | humidity | created_at          | +-----+--------+-------------+----------+---------------------+ |   1 | grass  |        NULL |     NULL | 2019-07-15 13:29:13 | |   2 | grass  |      24.100 |   49.000 | 2019-07-15 13:44:44 | |   3 | grass  |      24.100 |   49.000 | 2019-07-15 13:44:54 | |   4 | grass  |      24.000 |   49.000 | 2019-07-15 13:45:04 | |   5 | grass  |      24.000 |   49.000 | 2019-07-15 13:45:15 | |   6 | grass  |      24.100 |   49.000 | 2019-07-15 13:45:25 | |   7 | grass  |      24.100 |   49.000 | 2019-07-15 13:45:35 | |   8 | grass  |      24.100 |   49.000 | 2019-07-15 13:45:45 | |   9 | grass  |      24.100 |   49.000 | 2019-07-15 13:45:55 | |  10 | grass  |      24.100 |   48.000 | 2019-07-15 13:46:47 | |  11 | grass  |      24.100 |   48.000 | 2019-07-15 13:46:58 | |  12 | grass  |      24.100 |   48.000 | 2019-07-15 13:47:08 | <\/code><\/pre>\n
        \u0414\u0430\u043d\u043d\u044b\u0435 \u0432 \u0431\u0430\u0437\u0435!<\/p>\n
        \u0423\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0443 JpGraph<\/a><\/p>\n
        \u0443\u0431\u0438\u0440\u0430\u0435\u043c \u0435\u0433\u043e \u0432 \/var\/www\/src<\/p>\n
        \u0422\u0435\u043f\u0435\u0440\u044c \u0440\u0438\u0441\u0443\u0435\u043c \u0433\u0440\u0430\u0444\u0438\u043a(day.php):<\/p>\n
      day.php<\/b><\/p>\n
      \n
      <?php \/\/ content=\"text\/plain; charset=utf-8\"   \/\/define('__ROOT__', dirname(dirname())); require_once ('\/var\/www\/src\/jpgraph.php'); require_once ('\/var\/www\/src\/jpgraph_line.php'); require_once ('\/var\/www\/src\/jpgraph_error.php'); require_once ('\/var\/www\/src\/jpgraph_date.php');  $x_axis = array(); $y_axis = array(); $i = 0;   $con=mysqli_connect('localhost','arduino','\u043f\u0430\u0440\u043e\u043b','greenhouse'); $result = mysqli_query($con,\"SELECT * FROM data\"); while($row = mysqli_fetch_array($result)) { $x_axis[$i] =  strtotime($row[\"created_at\"]); $y_axis[$i] = $row[\"temperature\"];     $i++; }     mysqli_close($con); $start = time(); $end = $start+NDATAPOINTS*SAMPLERATE;  for( $i=0; $i < NDATAPOINTS; ++$i ) {     $x_axis[$i] = rand(50,70);     $xdata[$i] = $start + $i * SAMPLERATE; }   $graph = new Graph(1000,400); $graph->img->SetMargin(50,30,30,80);   $graph->img->SetAntiAliasing(); $graph->SetScale('datlin'); $graph->xaxis->scale->SetDateFormat('d:m H:i'); $graph->SetShadow(); $graph->title->Set(\"\u0414\u043d\u0435\u0432\u043d\u043e\u0439 \u0433\u0440\u0430\u0444\u0438\u043a \u0442\u0435\u043c\u043f\u0435\u0440\u0430\u0442\u0443\u0440\u044b\"); $graph->xaxis->title->Set('\u0432\u0440\u0435\u043c\u044f'); $graph->xaxis->SetLabelAngle(45); $graph->yaxis->title->Set('\u0442\u0435\u043c\u043f\u0435\u0440\u0430\u0442\u0443\u0440\u0430'); $graph->xaxis->scale->SetTimeAlign(DAYADJ_1); $graph->title->SetFont(FF_TIMES,FS_BOLD);   \/\/ Use 20% \"grace\" to get slightly larger scale then min\/max of \/\/ data $graph->yscale->SetGrace(0);  $p1 = new LinePlot($y_axis,$x_axis); $p1->mark->SetType(MARK_FILLEDCIRCLE); $p1->mark->SetFillColor(\"red\"); $p1->mark->SetWidth(4); $p1->SetColor(\"blue\"); $p1->SetCenter(); $graph->Add($p1);   $graph->Stroke(); <\/code><\/pre>\n
        <\/div>\n<\/div>\n
        \u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0432\u043e\u0442 \u0442\u0430\u043a\u0443\u044e \u043a\u0440\u0430\u0441\u043e\u0442\u0443:<\/p>\n
        <\/p>\n
        \u0412\u043e\u0442 \u0438 \u0432\u0441\u0435 \u043d\u0430 \u0434\u0430\u043d\u043d\u044b\u0439 \u043c\u043e\u043c\u0435\u043d\u0442. \u0421\u0435\u0439\u0447\u0430\u0441 \u0442\u0440\u0443\u0436\u0443\u0441\u044c \u043d\u0430\u0434 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u043e\u0439 \u0441\u0432\u044f\u0437\u043a\u0438 \u0434\u0432\u0443\u0445 \u043f\u043b\u0430\u0442 \u043f\u043e \u0440\u0430\u0434\u0438\u043e\u043a\u0430\u043d\u0430\u043b\u0443 \u043e \u0447\u0435\u043c \u043d\u0430\u043f\u0438\u0448\u0443 \u0432\u043e \u0432\u0442\u043e\u0440\u043e\u0439 \u0447\u0430\u0441\u0442\u0438.<\/p><\/div>\n