PHP Fatal error: Call to a member function query() on a non-object

[Texan78]

I have a serious issue. I am not sure if I have been hacked or what but my site is completely messed up. I have a ton of these errors in the error log and I am not sure what is causing this. I don't recall this being part of the script

 

 

PHP Notice:  Undefined variable: mysqli in /home2/mesquiu0/public_html/stream/inc/streamNotify.php on line 9

PHP Fatal error:  Call to a member function query() on a non-object in /home2/mesquiu0/public_html/stream/inc/streamNotify.php on line 9

 

Which is referring to this line. 

//lets execute the query
$executingFetchQuery = $mysqli->query("SELECT `StreamStatus` FROM streamdb WHERE 1");
if($executingFetchQuery)
{
   while($arr = $executingFetchQuery->fetch_assoc())
   {
        $resultArr[] = $arr['StreamStatus'];//storing values into an array
   }
}

This is the full code. 

/* Lets connect to the database */     
//include('dbconn.php');
          
$resultArr = array();//to store results


//lets execute the query
$executingFetchQuery = $mysqli->query("SELECT `StreamStatus` FROM streamdb WHERE 1");
if($executingFetchQuery)
{
   while($arr = $executingFetchQuery->fetch_assoc())
   {
        $resultArr[] = $arr['StreamStatus'];//storing values into an array
   }
}


     $counts = array_count_values($resultArr);//lets count the results
     $online = $counts['true'];


// Let's assign the table some styles
     $divStyle = "padding:5px; margin:auto; margin-bottom:20px";


// Lets assemble the banners to display
     $notifyOffline = "<div class='alert alert-danger' style='{$divStyle}' role='alert' data-toggle='tooltip' data-placement='top' title='There are currently no chasers streaming at this time.'> There are currently no chasers streaming at this time.</div>";


     $notify1Online = "<div class='alert alert-success' style='{$divStyle}' role='alert' data-toggle='tooltip' data-placement='top' title='There is currently 1 chaser streaming LIVE...'> There is currently 1 chaser streaming LIVE... </div>";


     $notifyOnline = "<div class='alert alert-success' style='{$divStyle}' role='alert' data-toggle='tooltip' data-placement='top' title='There are currently ".$online." chasers streaming LIVE...'> There are currently ".$online." chasers streaming LIVE... </div>";




//lets display the banners
if ( $online == "1" ) {
    echo $notify1Online;
} elseif ( $online >= "2" ) {
    echo $notifyOnline;
} else {
    echo $notifyOffline;
}

Any and ALL help would be greatly welcomed. 

 

-THANKS!

[Jacques1]

The include statement for the connection is commented out, so where is $mysqli supposed to come from?

[Texan78]

Yes, it is commented out because it was causing serious issues with the page loading so I commented it out until I could get this sorted. 

[Jacques1]

Again: You cannot comment out a database script when the rest of the code needs that script. This -- obviously -- breaks everything.

 

Page loading issues are a separate problem. The above errors are caused by your own changes.

[Texan78]

Again, the errors were happening BEFORE I commented out the code. I commented it out because it was throwing errors in the logs BEFORE commenting it out. It was also causing performance and resource issues on my host which was causing the page not to load. I commented it out in the script AND on the page it was being included on until I could resolve the issue. Once I did both those things the page loaded AND the errors went away. 

[Jacques1]

Cool story, bro.

[Barand]

This will stop that error

//    $executingFetchQuery = $mysqli->query("SELECT `StreamStatus` FROM streamdb WHERE 1");
//    if($executingFetchQuery)
//    {
//       while($arr = $executingFetchQuery->fetch_assoc())
//       {
//            $resultArr[] = $arr['StreamStatus'];//storing values into an array
//       }
//    }

However, it may cause others Edited November 23, 2016 by Barand

[Texan78]

Genius!!!

 

Even better I should just remove the entire query! 

 

That should do the trick!

 

[Jacques1]

It's actually a valid suggestion compared to fantasizing about how evil hackers stole your PHP variables.

 

Sometimes code has to be nuked from orbit.

Edited November 23, 2016 by Jacques1

[Barand]

On a serious note, you cannot run queries without establishing a connection to the database server. If including the file causes an error then you should be looking at the connection code and fixing errors there.

[requinix]

Alright folks, a little less sarcasm if you don't mind.

 

The file has to be included. The variable has to be defined in that file (or some subsequently included file) and has to be done in the global scope. If either of those doesn't happen then $mysqli will be undefined and the code will not work.

[Texan78]

So I guess I just fantasized that someone gained root access via shell.

 

So I guess it is completely valid to comment out the entire query which renders the entire script useless. 

 

So I guess that if I uncomment the DB connection it will work perfectly fine with no errors correct? That is what you're saying right? 

 

Guess what, it is uncommented, the errors have returned. So now what all mighty know it all? What does your magic 8 ball have to say about that? 

 

Cool story bro? Yeah stick it keyboard warrior.

Edited November 23, 2016 by Texan78

[mac_gyver]

Guess what, it is uncommented, the errors have returned. So now what all mighty know it all? What does your magic 8 ball have to say about that? 

 

 

 

if you would post those exact errors w/line numbers, someone COULD help you with what's causing them, because the magic 8 ball we resort to using when someone doesn't think it's necessary to share specific information they have about a problem doesn't show us what you are seeing in front of you.. it's likely they are not exactly the same errors/line numbers as what you posted at the top of this thread.

[Texan78]

it's likely they are not exactly the same errors/line numbers as what you posted at the top of this thread.

 

 

They are EXACTLY the same line numbers. I copy and pasted them into a notepad to save for later then commented out the DB connection to stop it from making connections. 

 

This.... 

/* Lets connect to the database */     
//include('dbconn.php');

Has zero to do with the error as I still get the SAME error regardless if it is commented out or not. So ignore it even exists. Had I not posted that part at all then I am sure I would be getting completely different responses. 

 

No worries, thanks for the help. Its apparent no one is looking BEYOND what I am saying and only focusing on that being commented out instead of listening to what I am saying that it doesn't matter. I get the same error regardless even with waiting a couple hours which is plenty of time for the varnish cache to clear. 

[mac_gyver]

^^^ then you should have posted the original code that didn't have the include statement commented out. by posting adulterated code, you wasted everyone's time making off topic attempts at helping you. the help you get is only as good as the information you supply.