PHP mysqli 查询未在 SELECT 语句中返回 mysqli_result 对象

Question

我想知道我做错了什么。我似乎无法弄清楚为什么它没有返回我的行，它只是没有回显语句并在我调用“$grow[”bName 时将其留空“]”。我尝试了我的查询并且它工作正常，它返回两列，用户名和 bName。这是我的 PHP 代码:

<?php
require ("cfd.php");
require ("header.php");
$username = $_SESSION["username"];
echo $username;
    //run the query
    $gsql = "SELECT babysitter.bName, login.username FROM login INNER JOIN babysitter ON login.b_ID=babysitter.b_ID WHERE login.username = '".$username."';";
    $gres = mysqli_query($db, $gsql);
    $grow = mysqli_fetch_assoc($gres);
    echo "<h2>Hello ".$grow["bName"].", Your admin status is ".$_SESSION['admin']."<br>";
    echo $gres->num_rows;
?>


<?php
require("footer.php");
?>

Answer 1

请尝试 $grow[0]["bName"] 否则你可以使用它

while($row = mysqli_fetch_assoc($gres)) 
{
    $row['bNAme'];
}