Using fetch_assoc on prepared statements

by

That’s because fetch_assoc is not part of a mysqli_stmt object. fetch_assoc belongs to the mysqli_result class. You can use mysqli_stmt::get_result to first get a result object and then call fetch_assoc:

$selectUser = $db->prepare("SELECT `id`,`password`,`salt` FROM `users` WHERE `username`=?");
$selectUser->bind_param('s', $username);
$selectUser->execute();
$result = $selectUser->get_result();
$assoc = $result->fetch_assoc();

Alternatively, you can use bind_result to bind the query’s columns to variables and use fetch() instead:

$selectUser = $db->prepare("SELECT `id`,`password`,`salt` FROM `users` WHERE `username`=?");
$selectUser->bind_param('s', $username);
$selectUser->bind_result($id, $password, $salt);
$selectUser->execute();
while($selectUser->fetch())
{
    //$id, $password and $salt contain the values you're looking for
}

More Related Contents:

  1. Use an array in a mysqli prepared statement: `WHERE .. IN(..)` query [duplicate]
  2. Call to a member function bind_param() on a non-object [duplicate]
  3. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  4. How to use mysqli prepared statements?
  5. MySQLi prepared statements error reporting [duplicate]
  6. Example of how to use bind_result vs get_result
  7. How to bind mysqli bind_param arguments dynamically in PHP?
  8. Call to a member function prepare() on a non-object PHP Help
  9. mysqli: can it prepare multiple queries in one statement?
  10. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  11. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  12. PHP UPDATE prepared statement
  13. using nulls in a mysqli prepared statement
  14. mySQLi prepared statement unable to get_result()
  15. MySQLi prepared statements with IN operator [duplicate]
  16. Is mysql_real_escape_string() necessary when using prepared statements?
  17. store_result() and get_result() in mysql returns false
  18. Using wildcards in prepared statement – MySQLi
  19. bind_param Number of variables doesn’t match number of parameters in prepared statement
  20. How to prepare statement for update query? [duplicate]
  21. Using wildcards in prepared statement
  22. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  23. How to run the bind_param() statement in PHP?
  24. Is using prepared statements necessary? [duplicate]
  25. Using Prepared Statement, how I return the id of the inserted row?
  26. Should I use mysqli_real_escape_string or should I use prepared statements? [duplicate]
  27. Dynamically bind mysqli_stmt parameters and then bind result
  28. Check to see if an email is already in the database using prepared statements
  29. INSERT – Number of bind variables doesn’t match number of fields in prepared statement
  30. Fatal error: Call to a member function prepare() on a non-object in

Leave a Comment