mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement

by 
$mysqli->prepare("SELECT username, password FROM users WHERE username = ?");
$username = $_POST['name'];
$stmt->bind_param('s' ,$username);
$stmt->execute();
$stmt->bind_result($username, $password);

Your select syntax was wrong, the correct syntax is
SELECT field1, field2, field3 FROM TABLE WHERE field1 = ? AND field2 = ?

To select more fields simply separate them by a comma and not an AND

More Related Contents:

  1. How to use mysqli prepared statements?
  2. MySQLi prepared statements error reporting [duplicate]
  3. Example of how to use bind_result vs get_result
  4. mysqli: can it prepare multiple queries in one statement?
  5. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  6. using nulls in a mysqli prepared statement
  7. Is mysql_real_escape_string() necessary when using prepared statements?
  8. How to prepare statement for update query? [duplicate]
  9. Using Prepared Statement, how I return the id of the inserted row?
  10. PHP – Using PDO with IN clause array
  11. How to display errors for my MySQLi query? [duplicate]
  12. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  13. When should I use MySQLi instead of MySQL?
  14. How to get count of rows in MySQL table using PHP?
  15. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  16. How to bind mysqli bind_param arguments dynamically in PHP?
  17. MySQL Prepared statements with a variable size variable list
  18. How can I enable the MySQLi extension in PHP 7?
  19. How can I use mysqli_fetch_array() twice?
  20. Advantages Of MySQLi over MySQL [closed]
  21. Updating from MYSQL to MYSQLI [duplicate]
  22. PDO error: SQLSTATE[HY000]: General error: 2031
  23. Using fetch_assoc on prepared statements
  24. store_result() and get_result() in mysql returns false
  25. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  26. How to run the bind_param() statement in PHP?
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. Strange problem with the length of the field gotten from database [duplicate]
  29. PHP prepared statements and transactions in a loop [duplicate]
  30. Should I use mysqli_real_escape_string or should I use prepared statements? [duplicate]

Leave a Comment