Call to undefined method mysqli_result::fetch()

by

The variable $stmt is an object of the mysqli_stmt class. This class has a method called fetch() which returns a boolean (true/false). It is used only in conjunction with bind_result() 

$stmt = $conn->prepare('SELECT myCol, myOtherCol FROM myTable WHERE dt=?');
$stmt->bind_param("s", $date);
$stmt->execute();
// The columns in SQL will be bound to the PHP variables
$stmt->bind_result($variable1, $variable2);
while ($stmt->fetch()) {
    // This will fetch each record from the prepared statement one by one
    printf ("myCol is %s and myOtherCol is %s\n", $variable1, $variable1);
}

$stmt->get_result() returns an object of class mysqli_result (which by the way is traversable using foreach). This class has different methods, but it doesn’t have fetch() method.

  • fetch_all() return an array of arrays. As the name suggests it returns all records from the result set at once. 
    $result = $stmt->get_result();
$allRecords = $result->fetch_all(\MYSQLI_ASSOC);
echo json_encode($allRecords);
  • fetch_array() returns each record one by one as an 1D array 
    $row = $result->fetch_array();
printf("%s (%s)\n", $row["myCol"], $row["myOtherCol"]);
  • fetch_assoc() is the equivalent to fetch_array(\MYSQLI_ASSOC)
  • fetch_row() is the equivalent to fetch_array(\MYSQLI_NUM)
  • fetch_object() returns each record one by one as an object. 
    $row = $result->fetch_object();
printf("%s (%s)\n", $row->myCol, $row->myOtherCol);

However, to keep it simple you can just loop on the mysqli_result directly which will get you each row as an associative array.

foreach($stmt->get_result() as $row) {
    printf("%s (%s)\n", $row["myCol"], $row["myOtherCol"]);
}

More Related Contents:

  1. Insert Mutiple Record into Database Using Php Mysql
  2. mysqli or PDO – what are the pros and cons? [closed]
  3. Commands out of sync; you can’t run this command now
  4. mysqli_query() expects at least 2 parameters, 1 given
  5. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  6. Strict Standards: mysqli_next_result() error with mysqli_multi_query
  7. Why does mysqli num_rows always return 0?
  8. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  9. What is the difference between MySQL, MySQLi and PDO? [closed]
  10. parameters in MySQLi
  11. Retrieving Multiple Result sets with stored procedure in php/mysqli
  12. Mysql No connection could be made because the target machine actively refused it
  13. How to connect to MySQL database in PHP using mysqli extension?
  14. How do I count query result rows?
  15. Bind Param with array of parameters
  16. How do you use IN clauses with mysqli prepared statements [duplicate]
  17. What to do with mysqli problems? Errors like mysqli_fetch_array(): Argument #1 must be of type mysqli_result and such
  18. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  19. How to fetch all in assoc array from a prepared statement?
  20. Fatal error: Call to undefined function mysqli_result()
  21. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  22. Why I am getting an error when using w3school tutorial? [duplicate]
  23. Using wildcards in prepared statement
  24. mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
  25. How to remove the fatal error when fetching an assoc array
  26. Fatal error: Call to undefined method mysqli_stmt::get_result()
  27. PHP MySQLi Multiple Inserts
  28. Fatal error: Call to a member function prepare() on a non-object in
  29. MySqli Commands out of sync; you can’t run this command now [duplicate]
  30. PHP and MySQLi – Cannot pass parameter 2 by reference in [duplicate]

Leave a Comment