php - 显示数据库记录 MySQLI

Question

我正在尝试显示我的数据库中的一条记录，但是该页面显示为空白并且没有显示我期望的数据。代码如下:

<?php 
    $mysqli = new mysqli(localhost, root, USERPASS, DBNAME);
    $query = "SELECT * FROM usertable WHERE userID= '" . $_SESSION["sess_uid"] . "'";           
    $result = mysqli_query($mysqli, $query);
    $row   = mysqli_fetch_row($result);

    echo $row['userQuestion'];
?>

如有任何帮助，我们将不胜感激。

谢谢

Answer 1

<?php 
// there need to be strings arguments here
$mysqli = new mysqli('localhost', 'root', USERPASS, DBNAME);
// sql injection friendly query
$query = "SELECT * FROM `usertable`
    WHERE `userID`='{$_SESSION["sess_uid"]}' LIMIT 1;";
// do we have a result
if($result = mysqli_query($mysqli, $query)){
    // fetch a single row
    if($row = mysqli_fetch_row($result)){
        // print the record
        var_dump($row);
    }
}
?>

您需要将 'localhost' 和 'root' 包装为字符串。