Object of class mysqli_result could not be converted to string in

Question

I am executing the below code.

$result = mysqli_query($con, "SELECT classtype FROM learn_users WHERE username='abcde'");

echo "my result <a href='data/$result.php'>My account</a>";

I am getting the following error:

 Object of class mysqli_result could not be converted to string 

Answer 1

The mysqli_query() method will be returning an object resource to your $result variable, not a string value.

You have to loop it up and then access the records. Because you directly can not use it as your $result variable.

while ($row = $result->fetch_assoc()) {

    echo $row['classtype']."<br>";

}

 Want to know more about SQL ? Join this SQL Certification course by Intellipaat.