mysql php no input

Other Hardware Sensors
1

ok, i cant solve this. :frowning:
I try to send a simple number from my nano33iot to my server.
lets say my domain name is m.com.
it connects, that is not a problem.

in my server i have a file called test.php...

<?php $dblink = mysqli_connect("m.com.mysql, m---, ---, m---"); if ($dblink->connect_error) { die("Connection failed: " . $dblink->connect_error); } $query = "INSERT INTO jk (temp, hum) VALUES (".$_GET["t"]."," .$_GET["h"].")"; if ($dblink->query($query) === TRUE) { echo "New record created successfully"; } else { echo "Error: " . $query . " " . $dblink->error; } mysqli_close($dblink); ?>

and the important codeline in arduino editor is this:

client.println("GET /test.php?t=44 HTTP/1.0");

but i got nothing in temp in sql...
maybe i have done something wrong in mysqli_connect.
but if someone can see if i done anything wrong with my arduino code and/or php code?

2

change

$query = "INSERT INTO jk (temp, hum) VALUES (".$_GET["t"]."," .$_GET["h"].")";

to

$myTemp = $_GET['t'];
$myHum = $_GET['h'];

$query = "INSERT INTO jk (temp, hum) VALUES (".$myTemp.",".$myHum.")";

and you're advised to manually check it via a browser, by hitting

www.yourdomain.com/test.php?t=67&h=23

3

tnx! that solved one problem.
i manually checked and found a misstake.
And was able to send to sql via browser..

then i tried via arduino but that failed.
Lets see if i can solve it.