Skip to main content
Participant
February 20, 2017
Answered

Error making contact with MySql Database

  • February 20, 2017
  • 1 reply
  • 1652 views

Hello people,

I have a problem with setting up a connection in dream weaver with a MySql database.

When testing the connection I get the following error "Your PHP server doesn’t have the MySql module loaded or you can’t use the mysql_(p)connect functions.", which he does both remote server and connecting to localhost.

I use MAMP with Apache server with PHP 7.1.1 and MySQL 5.6.35.

is there anyone who can help me to solve this problem, I've looked up everything and tried but I can not get it done.

Thank you, Derk

This topic has been closed for replies.
Correct answer pziecina

The deprecated Server Behaviours do not work with PHP7+.

You could downgrade to an earlier version, but be warned that your hosting provider will at some point upgrade to PHP 7, and your sites pages using the database connection will stop working.

A better solution would be to learn to write your own, or use a 3rd party extension, such as -

https://www.dmxzone.com/go/22151/database-connectivity-collection-php?utm_source=Extensions&utm_medium=Featured&utm_campaign=Database+Driven+Solutions

1 reply

pziecina
pziecinaCorrect answer
Legend
February 20, 2017

The deprecated Server Behaviours do not work with PHP7+.

You could downgrade to an earlier version, but be warned that your hosting provider will at some point upgrade to PHP 7, and your sites pages using the database connection will stop working.

A better solution would be to learn to write your own, or use a 3rd party extension, such as -

https://www.dmxzone.com/go/22151/database-connectivity-collection-php?utm_source=Extensions&utm_medium=Featured&utm_campaign=Database+Driven+Solutions

DamsterAuthor
Participant
February 20, 2017

Hello, Pziecina Thats true, and that is my hosting provider is doing everything to get geupgade 7.1.1, and now have been updating my site to this version, but I can not figure out what has changed.

I must migrate the old Dreamweaver PHP code to PHP 7

BUT HOW ???

pziecina
Legend
February 20, 2017

Unfortunately there is no simple solution to updating the site.

You could ask your hosting provider if they will have a legacy server that they can use to host your site, but this is a temporary solution, and such servers are often not 'cared for' as much as the normal 'up-to-date' servers.

If you do not wish to learn how to code yourself, then your only option is to purchase the extensions provided by the 3rd party developers, and use those to re-code your pages, (the good news, if you can call it that, is that at least the database remains the same, and requires no extra work).

If you do wish to learn how to code yourself, then there are a number of excellent books available, such as those from -

http://foundationphp.com/

or on-line training video courses -

https://www.lynda.com/David-Powers/310454-1.html