A
Anonymous
Guest
i've spent a frustrating day trying to get this going:
<?php
# check for expected parameters
if(!isset($_REQUEST['logger'],$_REQUEST['temperature'],$_REQUEST['leafwetness'])){
exit("ERROR: There was a problem authenticating your request, if this problem continues contact hortplus@gmail.com [error code: 100]");
}
$username = "root";
$password = "l5iNw5EOJ91";
$hostname = "hort.com";
$db_name = "premet";
//connection to the database
$link = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
// setup script parameters
echo "Getting parameters<br>";
$stationID = $_REQUEST['logger'];
date_default_timezone_set('NZ');
$startdate = date('Y/m/d h:m', time());
$stopdate = date('Y/m/d h:m', (time()- (1 * 60)));
$temperature = $_REQUEST['temperature'];
$leafwetness = $_REQUEST['leafwetness'];
echo "$startdate";
// create met data insert
$table = 'met_metdata';
echo "About to insert<br>";
$sql = "INSERT INTO met_metdata (station_id,meteo_var_id,meas_type_id,interval_id,stop_date,start_date,amount) VALUES ('$stationID', 'TD', 'M','M','$stopdate','$startdate','$temperature')";
echo "$sql";
if (mysqli_query($link, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($link);
}
$link->close();
?>
But i get these error messages:
Connected to MySQL
Getting parameters
2017/12/21 09:12About to insert
INSERT INTO met_metdata (station_id,meteo_var_id,meas_type_id,interval_id,stop_date,start_date,amount) VALUES ('123', 'TD', 'M','M','2017/12/21 09:12','2017/12/21 09:12','10')
Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /var/www/htdocs/hortmet/write_met.php on line 32
Warning: mysqli_error() expects parameter 1 to be mysqli, resource given in /var/www/htdocs/hortmet/write_met.php on line 35
Error: INSERT INTO met_metdata (station_id,meteo_var_id,meas_type_id,interval_id,stop_date,start_date,amount) VALUES ('123', 'TD', 'M','M','2017/12/21 09:12','2017/12/21 09:12','10')
Fatal error: Call to a member function close() on a non-object in /var/www/htdocs/hortmet/write_met.php on line 39
What am i doing wrong?
Yours in desperation
Andrew Hodson
<?php
# check for expected parameters
if(!isset($_REQUEST['logger'],$_REQUEST['temperature'],$_REQUEST['leafwetness'])){
exit("ERROR: There was a problem authenticating your request, if this problem continues contact hortplus@gmail.com [error code: 100]");
}
$username = "root";
$password = "l5iNw5EOJ91";
$hostname = "hort.com";
$db_name = "premet";
//connection to the database
$link = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
// setup script parameters
echo "Getting parameters<br>";
$stationID = $_REQUEST['logger'];
date_default_timezone_set('NZ');
$startdate = date('Y/m/d h:m', time());
$stopdate = date('Y/m/d h:m', (time()- (1 * 60)));
$temperature = $_REQUEST['temperature'];
$leafwetness = $_REQUEST['leafwetness'];
echo "$startdate";
// create met data insert
$table = 'met_metdata';
echo "About to insert<br>";
$sql = "INSERT INTO met_metdata (station_id,meteo_var_id,meas_type_id,interval_id,stop_date,start_date,amount) VALUES ('$stationID', 'TD', 'M','M','$stopdate','$startdate','$temperature')";
echo "$sql";
if (mysqli_query($link, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($link);
}
$link->close();
?>
But i get these error messages:
Connected to MySQL
Getting parameters
2017/12/21 09:12About to insert
INSERT INTO met_metdata (station_id,meteo_var_id,meas_type_id,interval_id,stop_date,start_date,amount) VALUES ('123', 'TD', 'M','M','2017/12/21 09:12','2017/12/21 09:12','10')
Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /var/www/htdocs/hortmet/write_met.php on line 32
Warning: mysqli_error() expects parameter 1 to be mysqli, resource given in /var/www/htdocs/hortmet/write_met.php on line 35
Error: INSERT INTO met_metdata (station_id,meteo_var_id,meas_type_id,interval_id,stop_date,start_date,amount) VALUES ('123', 'TD', 'M','M','2017/12/21 09:12','2017/12/21 09:12','10')
Fatal error: Call to a member function close() on a non-object in /var/www/htdocs/hortmet/write_met.php on line 39
What am i doing wrong?
Yours in desperation
Andrew Hodson