I wrote code for my arduino to use mysql and update a feeds mysql table to input values to monitor my gas, electricity and water usage
but when you directly update the database trough mysql from an arduino, this is not displayed in the emoncms feeds
why?
currently I'm using php scripts on my server running emoncms, the php script is triggered by the arduino, then reads the current value from the emoncms database, and then updates the value by using the feed API,
example for my gas usage
<?php
mysql_connect("127.0.0.1", "root", "tpassword") or die(mysql_error());
mysql_select_db("emoncms") or die(mysql_error());
$handle = mysql_query('SELECT time,data FROM feed_18 ORDER BY time DESC');
$row = mysql_fetch_row($handle);
$gas = $row[1]+0.01;
$gasprice = $row[1]*0.6296+229.95;
$url = 'http://someserver.com/emoncms/api/post?apikey=apikeyhere&json={gasusage:'.$gas.',gasprice:'.$gasprice.'}';
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,$url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$contents = curl_exec ($ch);
curl_close ($ch);
?>
why is it not possible to put data directly into mysql? why doesn't the emoncms read data from the mysql database when data is stored in it directly? now I have to resort to using a php script that is triggered from the arduino, putting the data into mysql directly is more convenient, but the emoncms does not read this data directly from the mysql database.
arduino + mysql
Submitted by Guest on Fri, 28/03/2014 - 21:05I wrote code for my arduino to use mysql and update a feeds mysql table to input values to monitor my gas, electricity and water usage
but when you directly update the database trough mysql from an arduino, this is not displayed in the emoncms feeds
why?
currently I'm using php scripts on my server running emoncms, the php script is triggered by the arduino, then reads the current value from the emoncms database, and then updates the value by using the feed API,
example for my gas usage
<?php
mysql_connect("127.0.0.1", "root", "tpassword") or die(mysql_error());
mysql_select_db("emoncms") or die(mysql_error());
$handle = mysql_query('SELECT time,data FROM feed_18 ORDER BY time DESC');
$row = mysql_fetch_row($handle);
$gas = $row[1]+0.01;
$gasprice = $row[1]*0.6296+229.95;
$url = 'http://someserver.com/emoncms/api/post?apikey=apikeyhere&json={gasusage:'.$gas.',gasprice:'.$gasprice.'}';
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,$url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$contents = curl_exec ($ch);
curl_close ($ch);
?>
why is it not possible to put data directly into mysql? why doesn't the emoncms read data from the mysql database when data is stored in it directly? now I have to resort to using a php script that is triggered from the arduino, putting the data into mysql directly is more convenient, but the emoncms does not read this data directly from the mysql database.