php显示属于用户名的变量

Question

I want to show the variable "points" which belongs to a certain username,.

This is a part of my login2.php file:

if(isset($_SESSION['username'])){
    $username=$_SESSION['username'];
    $points = $mysqli->query("SELECT points FROM account_information WHERE username = '".$username."'");

}

I dont know how to show the points now. I know that the outcome of $points is not the amount of points that belongs to a username. I actually want to know how to do this and what the outcome is of the $points. How can I show the actual result of the query I am running?(which would be the amount of points stored in my database So of course if you would run this query in mysql then the outcome will be :"Amount of points", but in this situation I dont know how to show the amount of points actually.

Answer 1

while ($row = mysqli_fetch_assoc($points)) {
    echo $row['points'];
}

Just put the results into an array called $row then access the parts of the array with $row['points'].