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

by

As mentioned in comments, this is a scoping issue. Specifically, $con is not in scope within your getPosts function.

You should pass your connection object in as a dependency, eg

function getPosts(mysqli $con) {
    // etc

I would also highly recommend halting execution if your connection fails or if errors occur. Something like this should suffice

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); // throw exceptions
$con=mysqli_connect("localhost","xxxx","xxxx","xxxxx");

getPosts($con);

More Related Contents:

  1. Turning query errors to Exceptions in MySQLi [duplicate]
  2. Should we ever check for mysqli_connect() errors manually?
  3. How to prevent duplicate usernames when people register?
  4. How to use mysqli prepared statements?
  5. How to solve “Fatal error: Class ‘MySQLi’ not found”?
  6. Why can’t I run two mysqli queries? The second one fails [duplicate]
  7. mysqli bind_param() expected to be a reference, value given
  8. Should I manually check for errors when calling “mysqli_stmt_prepare”?
  9. mysqli_real_escape_string() expects exactly 2 parameters, 1 given
  10. INSERT – Number of bind variables doesn’t match number of fields in prepared statement
  11. Call to a member function execute() on boolean in [duplicate]
  12. Can’t pass mysqli connection in session in php
  13. PHP Fatal error: Call to undefined function mysqli_stmt_get_result()
  14. how to bind multiple parameters to MySQLi query [closed]
  15. mysqli ignoring the first row in a table
  16. Returning Multiple Rows with MySqli and Arrays
  17. mySQLi prepared statement unable to get_result()
  18. mysqli_select_db() expects parameter 1 to be mysqli, string given
  19. What does the mysqli_error() expects parameter 1 to be mysqli, null given mean?
  20. Mysqli prepared statement column with variable [duplicate]
  21. Using PHP to execute multiple MYSQL Queries
  22. Mysqli prepared statements build INSERT query dynamically from array
  23. Call to undefined function mysqli_result::num_rows()
  24. Is using prepared statements necessary? [duplicate]
  25. How to run multiple insert query in SQL using PHP in one go?
  26. PHP prepared statements and transactions in a loop [duplicate]
  27. Warning: mysqli_query() expects at least 2 parameters, 1 given. What? [duplicate]
  28. Should I use mysqli_real_escape_string or should I use prepared statements? [duplicate]
  29. check if the query returns zero rows [duplicate]
  30. Single Result From SUM With MySQLi

Leave a Comment