Warning mysqli query expects parameter 1 to be mysqli null given in

Question

I am trying to build a simple custom CMS  but I m getting an error      Warning  mysqli query   expects parameter 1 to be MySQLi  null given in   Why am I getting this error  All my code is already MySQLi and I am using two parameters  not one    con mysqli connect  localhost   xxxx   xxxx   xxxxx       check connection if  mysqli connect errno  con         echo  Failed to connect to MySQL     mysqli connect error       function getPosts          query   mysqli query  con  SELECT   FROM Blog        while  row   mysqli fetch array  query                 echo   lt div class   blogsnippet   gt            echo   lt h4 gt      row  Title       lt  h4 gt      row  SubHeading            echo   lt  div gt

User · Accepted Answer

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

User · Answer

use global scope on your  con and put it inside your getPosts   function like so   function getPosts     global  con   query   mysqli query  con  SELECT   FROM Blog    while  row   mysqli fetch array  query                 echo   lt div class   blogsnippet   gt            echo   lt h4 gt      row  Title       lt  h4 gt      row  SubHeading            echo   lt  div gt

User · Answer

The getPosts   function seems to be expecting  con to be global  but you re not declaring it as such    A lot of programmers regard bald global variables as a  code smell   The alternative at the other end of the scale is to always pass around the connection resource  Partway between the two is a singleton call that always returns the same resource handle

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

Examples related to php

Examples related to mysqli