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

[deemurphy]

I decided to upgrade my site which was doing fine, but now I am getting the following: Warning: mysqli_query() expects parameter 1 to be mysqli, null given

in all my PHP files and I do not understand this error.

 

Thank you for any solution to this.

LadyDee

[Pikachu2000]

What do you mean by upgrade?

[deemurphy]

I justed wanted to upgrade the feel and look of the site, it is hosted on 000webhost.com the name of the website is http://ladydee.net23.net/ - If you go to contact me and look at for instance Please View my Calendar and Set an Appointment You will see what I am getting.

 

Thank you

LadyDee

[Alex]

We can't help much without seeing relevant code. The problem is that when using mysqli_query() in procedural style the first parameter needs to be the mysqli link. To be more specific we'll need to see some code.

[deemurphy]

I am attaching the code for the calendar.

 

LadyDee

 

[attachment deleted by admin]

[Pikachu2000]

Did you inadvertently remove the database connection script from showcalendar_withevent.php, or accidentally delete it altogether? Can you post the code within

 . . . 

tags?

 

Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/a3151982/public_html/showcalendar_withevent.php on line 203

[Alex]

After mysqli_connect put something like this to see if it's failing:

 

if (!$mysqli) {
    die('Connect Error (' . mysqli_connect_errno() . ') '
            . mysqli_connect_error());
}

[Pikachu2000]

Did you edit this to post it here, or did you edit it to use during development? I wouldn't expect to see the root user being the account used for DB access on a hosted site. Also, usually (but not always) the database server isn't at localhost.

 

$mysqli = mysqli_connect("localhost", "root", "ladydee", "ladydee");

[deemurphy]

I edited it to upload it here. Here is the actual file.

LadyDee

 

[attachment deleted by admin]

[Alex]

You should edit that file and remove your connection details immediately.

 

Your problem is that $mysqli is never set, you're also mixing mysql and mysqli functions, you can't do that.

[deemurphy]

Thank you, but then how should I fix this.

LadyDee

[Pikachu2000]

If you can't unattach that file from the post, or edit it, you should change your DB password ASAP.

[deemurphy]

I changed the password, I think if I change all of mysli to mysql this will work it that correct.

LadyDee

[Pikachu2000]

The mysql and mysqli extensions use a somewhat different syntax, but it looks like the script was written with the mysql extension originally, then an attempt was made to modify it. If that's the case, you should be able to change the mysqli's back to mysql. If that doesn't work, I'm sure someone here can help out.

[deemurphy]

Now I am getting the following error: Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource

LadyDee

[PFMaBiSmAd]

The second parameter in a mysql_query() function call is an optional mysql link resource. Your's is not one.

 

You would need to troubleshoot why the second parameter you are supplying is not a mysql link resource and make it the one that your mysql_connect() created.

[deemurphy]

I am not sure how to do this as I have never mixed the two.  I got part of this from the All In One PHP Book.

LadyDee

[PFMaBiSmAd]

No one can really help you with what is specifically wrong with your code without seeing the code that produces the error. I told you what the error means, if you don't understand what the parameters are in a function call or where or if they are getting set to the correct values, you will need to post your code.

[deemurphy]

Here is the code.

 

[attachment deleted by admin]

[PFMaBiSmAd]

That code isn't even using mysql_query() so it cannot be the code you were using that produced the error you posted in Reply #14. In fact, it is probably the original code you stared with and it produces the error message in the title of this thread.

 

When your problem is a moving target of randomly changing code and errors that don't even match the code you provide, no one really wants to try to chase down what you are changing in it.

 

You have had both the mysqli and mysql errors explained and been told that you cannot mix mysql and mysqli functions in one script. You must pick one way or the other and all the database related code on any page must use the same type.