我正在尝试创建一个验证系统,一切都正常,但是如果我想要得到密钥,它就会返回Null
。
function getLocalKey()
{
$servername = 'localhost';
$username = 'XXX';
$password = 'XXX';
$dbname = 'XXX';
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
breakDown("Failed connection to MySQL-Server please make sure that you've entered all
MySQL-Data correctly into the config.php and that the MySQL-Server is running!", 1);
} else {
$query = "SELECT * FROM `verifykey` WHERE `id`= '1'";
$result = mysqli_query($conn, $query);
if ($result->num_rows > 0) {
while ($row = mysqli_fetch_array($result)) {
return $row['verifykey'];
}
} else {
return '0 results';
}
$conn->close();
}
}
我知道有些事情是不必要的,但那是因为我尝试了很多东西,但每次都会回来Null
。
发布于 2018-06-13 15:21:42
我认为你的列id是一个int,所以不要放‘:
$query = "SELECT * FROM `verifykey` WHERE `id`= 1";
https://stackoverflow.com/questions/-100005362
复制相似问题