Warning: mysqli_query() expects parameter 1 to be mysqli, string given in

by

It’s exactly as the error states as you’re passing arguments to mysqli_query() incorrectly. Assuming $conn is your mysqli connection generated at some point by new mysqli() it should be:

$result = mysqli_query( $conn,$sql) or trigger_error(mysqli_error($conn)));

The way you were calling it you were passing a string, $sql as the first argument.

More Related Contents:

  1. inserting information and image in php and mysql
  2. mysqli or die, does it have to die?
  3. mysqli bind_param for array of strings
  4. MySQL vs MySQLi when using PHP [closed]
  5. PHP error: “Cannot pass parameter 2 by reference”
  6. How to get count of rows in MySQL table using PHP?
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. How to bind mysqli bind_param arguments dynamically in PHP?
  9. How can I enable the MySQLi extension in PHP 7?
  10. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  11. MySQLi Bind Param with an array for IN [duplicate]
  12. Advantages Of MySQLi over MySQL [closed]
  13. check if the query results empty row mysqli [duplicate]
  14. Is mysql_real_escape_string() necessary when using prepared statements?
  15. Updating from MYSQL to MYSQLI [duplicate]
  16. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  17. mysqli_stmt::execute() expects exactly 0 parameters, 1 given
  18. Mysqli get_result alternative
  19. Using fetch_assoc on prepared statements
  20. Object of class mysqli_result could not be converted to string
  21. Single Value Mysqli [duplicate]
  22. How to prepare statement for update query? [duplicate]
  23. mysqli + xdebug breakpoint after closing statement result in many warnings
  24. INSERT query produces “Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given”
  25. php password_verify() hash and pass won’t match
  26. PHP to MySQL SSL Connections
  27. mysqli_fetch_array returning only one result
  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