php – Object of class mysqli_result could not be converted to string

php – Object of class mysqli_result could not be converted to string

The mysqli_query() method returns an object resource to your $result variable, not a string.

You need to loop it up and then access the records. You just cant directly use it as your $result variable.

while ($row = $result->fetch_assoc()) {
    echo $row[classtype].<br>;
}

Before using the $result variable, you should use $row = mysqli_fetch_array($result) or mysqli_fetch_assoc() functions.

Like this:

$row = mysqli_fetch_array($result);

and use the $row array as you need.

php – Object of class mysqli_result could not be converted to string

mysqli:query() returns a mysqli_result object, which cannot be serialized into a string.

You need to fetch the results from the object. Heres how to do it.

If you need a single value.

Fetch a single row from the result and then access column index 0 or using an associative key. Use the null-coalescing operator in case no rows are present in the result.

$result = $con->query($tourquery);  // or mysqli_query($con, $tourquery);

$tourresult = $result->fetch_array()[0] ?? ;
// OR
$tourresult = $result->fetch_array()[roomprice] ?? ;

echo <strong>Per room amount:  </strong>.$tourresult;

If you need multiple values.

Use foreach loop to iterate over the result and fetch each row one by one. You can access each column using the column name as an array index.

$result = $con->query($tourquery);  // or mysqli_query($con, $tourquery);

foreach($result as $row) {
    echo <strong>Per room amount:  </strong>.$row[roomprice];
}

Leave a Reply

Your email address will not be published.