Object of class mysqli result could not be converted to string in

Question

I am getting the error   Object of class mysqli result could not be converted to string  This is my code   result   mysqli query  con   quot SELECT classtype FROM learn users WHERE username  abcde  quot     echo  quot my result  lt a href  data  result php  gt My account lt  a gt  quot

User · Answer

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

User · Answer

The query   function returns an object  you ll want fetch a record from what s returned from that function   Look at the examples on this page to learn how to print data from mysql

User · Answer

mysqli query   returns a mysqli result object  which cannot be serialized into a string  You need to fetch the results from the object  Here s 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- gt query  tourquery       or mysqli query  con   tourquery     tourresult    result- gt fetch array   0            OR  tourresult    result- gt fetch array    roomprice           echo   lt strong gt Per room amount    lt  strong gt    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- gt query  tourquery       or mysqli query  con   tourquery    foreach  result as  row        echo   lt strong gt Per room amount    lt  strong gt    row  roomprice

User · Answer

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 can t directly use it as your  result variable  while   row    result- gt fetch assoc          echo  row  classtype    quot  lt br gt  quot

User · Answer

Try with   row   mysqli fetch assoc  result   echo  quot my result  lt a href  data  quot    htmlentities  row  classtype    ENT QUOTES   UTF-8      quot  php  gt My account lt  a gt  quot

[php] Object of class mysqli_result could not be converted to string in

Examples related to php

Examples related to mysqli