PHP mysqli查询不返回任何结果 [英] PHP mysqli query doesn't return any results

问题描述

我在这里使用此代码

<?php
error_reporting(1);
$servername = '127.0.0.1';
$username = '';
$password = '';
$dbname = 'splafpoo_users';
$conn = new mysqli($servername, $username, $password, $dbname);

if (mysqli_connect_errno()){
    printf("<b>Connection failed:</b> %s\n", mysqli_connect_error());
    exit;
} 

$key = '';

if(isset($_POST['key'])){
    $key = $_POST['key'];
}

$query = "SELECT * FROM users WHERE serial='$key'";
echo $query;

$result = $mysqli->query($query);
$row = $result->fetch_assoc();

echo $row;
?>

在phpMyAdmin中运行查询SELECT * FROM users WHERE serial='test'会返回所需的结果，但是当尝试使用上面的代码显示结果时，什么也没有显示，而且我不知道怎么做.如何显示结果?

Running the query SELECT * FROM users WHERE serial='test' in phpMyAdmin returns the desired result however when trying to display the result using the code above nothing is displayed and I cannot figure out how. How do I display the result?

推荐答案

在循环时，您将需要一种很好的旧方式

You're gonna need a good old fashion while loop

while($row = $result->fetch_assoc()) {
    echo $row['WHATEVERCOLUMNITISYOUWANT'];
}

这绝对是重复的

这篇关于PHP mysqli查询不返回任何结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！