close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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.

Thread began 5/22/2018 2:02 am by lr_leal239405 | Last modified 6/12/2018 12:28 pm by Ray Borduin | 822 views | 54 replies |

lr_leal239405

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 4.5.

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

lr_leal239405

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.

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post

lr_leal239405

oh, sorry. I sent it on private email.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

lr_leal239405

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

lr_leal239405

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.

Sign in to reply to this post

lr_leal239405

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...