Code: Select all
<?php
$temperature = $_POST['temperature']; // nwas $_GET[]
$humidity = $_POST['humidity']; // nwas $_GET[]
$dbname = 'pabriles_example';
$dbuser = 'pabriles_admin';
$dbpass = '.########>>>';
$dbhost = 'www.redristracards.com';
$connect = @mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
if ($connect->connect_error){
die("Connection failed: $sql"); // my code ...
} else {
echo "YES!! We connnected!<br><br>";
}
$sql = "INSERT INTO iot_project(temperature, humidity) VALUES ('$temperature', '$humidity')";
if ($connect->query($sql) === TRUE) {
echo "ADDED: ".$temperature.", ".$humidity;
} else {
echo "ERROR!!!: ".$sql."<br>".$conn->error;
}
$connect->close();
?>
ANY HELP will be greatly appreciated.
Thank you!