How to remove the fatal error when fetching an assoc array

by

The variable $stmt is of type mysqli_stmt, not mysqli_result. The mysqli_stmt class doesn’t have a method “fetch_assoc()” defined for it.

You can get a mysqli_result object from your mysqli_stmt object by calling its get_result() method. For this you need the mysqlInd driver installed!

$result = $stmt->get_result();
row = $result->fetch_assoc();

If you don’t have the driver installed you can fetch your results like this:

$stmt->bind_result($dbUser, $dbEmail);
while ($stmt->fetch()) {
    printf("%s %s\n", $dbUser, $dbEmail);
}

So your code should become:

$query = "SELECT Username, Email FROM User WHERE User = ?";
// prepare query
$stmt=$mysqli->prepare($query);
// You only need to call bind_param once
$stmt->bind_param("s",$user);
// execute query
$stmt->execute(); 
// bind variables to result
$stmt->bind_result($dbUser, $dbEmail);
//fetch the first result row, this pumps the result values in the bound variables
if($stmt->fetch()){
    echo 'result is ' . dbEmail;
}

More Related Contents:

  1. Insert Mutiple Record into Database Using Php Mysql
  2. Object of class mysqli_result could not be converted to string
  3. SELECT COUNT(*) AS count – How to use this count
  4. Mysqli update throwing Call to a member function bind_param() error [duplicate]
  5. mysqli bind_param() expected to be a reference, value given
  6. Should I manually check for errors when calling “mysqli_stmt_prepare”?
  7. mysqli_real_escape_string() expects exactly 2 parameters, 1 given
  8. INSERT – Number of bind variables doesn’t match number of fields in prepared statement
  9. Call to a member function execute() on boolean in [duplicate]
  10. SSL operation failed with code 1: dh key too small
  11. Can’t pass mysqli connection in session in php
  12. PHP Fatal error: Call to undefined function mysqli_stmt_get_result()
  13. how to bind multiple parameters to MySQLi query [closed]
  14. mysqli ignoring the first row in a table
  15. Returning Multiple Rows with MySqli and Arrays
  16. mySQLi prepared statement unable to get_result()
  17. mysqli_select_db() expects parameter 1 to be mysqli, string given
  18. What does the mysqli_error() expects parameter 1 to be mysqli, null given mean?
  19. Mysqli prepared statement column with variable [duplicate]
  20. What to do with mysqli problems? Errors like mysqli_fetch_array(): Argument #1 must be of type mysqli_result and such
  21. Using PHP to execute multiple MYSQL Queries
  22. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  23. Mysqli prepared statements build INSERT query dynamically from array
  24. Call to undefined function mysqli_result::num_rows()
  25. Fatal error: Call to undefined method mysqli_stmt::get_result()
  26. PHP MySQLi Multiple Inserts
  27. Fatal error: Call to a member function prepare() on a non-object in
  28. Using Prepared Statement, how I return the id of the inserted row?
  29. Is there any way to print the actual query that mysqli->execute() makes?
  30. When should I close a database connection in PHP?

Leave a Comment