PHP MySQL总是得到假的回报

Question

i wrote some PHP stuff and iam stuck here:

$mysql = new mysqli($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASSWORD, $MYSQL_DATABASE);
$result = $mysql->query("SELECT `value` FROM `config` WHERE `config` = 'url' LIMIT 1");

var_dump($result);

The var dump always give me false. I cant fetch the result. I testet the connection, it works. Also i execute the SQL in phpmyadmin and it gives me the value back.

what am i doing wrong?

Answer 1

RUn this code first, then run the query which display in the browser to the mysql apps (eg. phpmyadmin).

$mysql = new mysqli($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASSWORD, $MYSQL_DATABASE);
$qry=""SELECT `value` FROM `config` WHERE `config` = 'url' LIMIT 1"";
die($qry);
$result = $mysql->query($qry);

You will know what the query error message.