I can't get this to work with db (new msqli) on php 7 (even though the db is pulling from a db on another host that is using version 5. The files are hosted on server with version 7.

I can't get this to work with db (new msqli) on php 7 (and don't understand because the db is being pulled from another host that is using php version 4.5. The files are hosted on server with version 7. Why would I need to change the php code to v7 if it should be working fine with the db hosted on v4.5 server?

My file is attached and I got a bunch of errors. I am getting "Updating. Please check back later" which is in my code, instead of getting the data from the db. Can't seem to establish the cx with my code properly. See attached file

The php version doesn't matter on the server with the database. The php version used is the one where your .php files are hosted. MySQL and MySQLi aren't different databases, they are different ways php interacts with the database.

It looks like a completely hand coded mysqli page, not using webassist extensions. It is hard for me to say where it is wrong. If you gave me a live url and ftp access I could try to help you debug it.

I tried to rebuild the connection using php7 code/ new msql code. Originally it was using the webassist code. On the private message I've give you ftp. The files are exhibitionsBACKUPWORKINGON.php (original is exhibitionsBACKUPORIG).. Thank you.

What is the url to the page? I'll need the domain name so I can browse and test.

oh, sorry. I sent it on private email.

The errors mean that your database host name, username, or password are incorrect. I would strongly suggest using our extensions to help you build your Connections and MySQLi code. Doing it by hand is time consuming and prone to errors.

Your connection file seems to have strings instead of variable references for all of the connection information. Did you do that on purpose? It isn't using the values you typed in above at all.

Also the values for a mysqli connection should be passed in the order: host, user, pass, database

you seem to have them in the order: host, database, user, password

There is also a random ! at the end of the password value that appears to be a typo. There are so many issues here it is hard to say where to start... I'd start by downloading the DataBridge v2 BETA and use that to recreate your connection and recordsets.

thanks for your help. I'm not home until later today, but, I think you weren't looking at the file I'm testing which is the one named '
exhibitionsBACKUPWORKINGON.php. Not the exhibitions.php. I'm pretty sure the usn/psw should be right in the connection file. For this job I probably wouldn't buy the new data bridge (not getting paid to fix that) but is the Beta version you mentioned a free version? I also see you have on your home page an ad for:

Generate MySQLi code

With this new extension, you can easily create MySQLi recordsets, repeat regions and use various server behaviors to generate MySQLi code.

I was originally trying to rebuild it by hand by looking at some forums.

I was looking at the right file. Open the connection file included on the top of that page you will see all of the issues with it.

ok. I'll purchase the msqli extension for the special price I see. I was probably looking at old forum on the beta version. Thanks.

I've installed the MySqli Server Behaviors extension. When trying to add a db, I get msg 'Your PHP server doesn't have the MySQL or MySQLi module loaded or you can't use the mysqli_(p)connect functions". I'm using Dreamweaver 6 and have Godaddy as host for the DB, but 1and1 hosting for the website. I'm calling host to find out how to activate module and after reading some forums. I haven't been able to make it work. Please advise if you have heard of this issue and have a resolution. Thank you.