Skip to main content
E
EddieXX
New Participant
April 9, 2020
Answered

Your PHP server doesn't have the MySQL module loaded or you can't use the mysql_(p)connect function

  • April 9, 2020
  • 1 reply
  • 4203 views

I have just downloaded the 7 days trial of Dreamweaver 2020, to replace the DW CS6 version (now uninstalled). I'm using Xampp as the database.

I create the local host site and a via a simple PHP file I can confirm the connection

It also works in live view

The problem comes when trying to access the database table that I get the above error as I set up the MySQL Connection.

 

Any suggestions would be appreciated

This topic has been closed for replies.
Correct answer osgood_

Xmapp is running PHP 7.4.4

In DW site definition for PHP 7.1 (and not 5.6) is selected


Well if XAMPP is running php 7.4+ then the DW server behaviours which use the old mysql connection will not work. If you can revert to php version 5.6 they will work but as I say its not advisable to do so.

 

Adobe has informed us that they will at some stage be providing new server behaviours for DW but the 'horse has already bolted' Many are abandoning DW as a result of infrequent updates and lack of any understanding about what developers require, for what seems like a decade.

 

Try a programme named 'Wappler' that is up-to-date in terms of database connectivity, plus some BUT only if you are an infrequent developer, someone who has an idea for an app or someone who just manages a company website. Its not a good choice if you are intending to make web-development a long-term career move as you end up without an saleable skills should you wish to ever go an work  for someone else at some point in the future.

1 reply

O
osgood_
Brainiac
April 9, 2020

Have you recently downloaded and installed Xampp?  If the answer is yes then most probably it uses a newer version of php, maybe version 7+

 

The server behaviours in DW wont be compatible with php versions above 5.6, I believe.

 

You really should not be using any DW server behaviours going forward as they are out-dated and are no longer supported in any version of php/mysql, above 5.6

 

Your choice is to either write your own server behaviours or purchase a DW extension from a 3rd party which uses the newer mysqli(improved) or PDO workflows OR drop back to a server which still has php 5.6 running (not recommended)

 

E
EddieXXAuthor
New Participant
April 9, 2020

osgood,

 

Thanks, I was following this tutorial https://helpx.adobe.com/uk/dreamweaver/using/designing-dynamic-pages.html

Basically, I'm just trying to create the recordset

E
EddieXXAuthor
New Participant
April 9, 2020

Well if XAMPP is running php 7.4+ then the DW server behaviours which use the old mysql connection will not work. If you can revert to php version 5.6 they will work but as I say its not advisable to do so.

 

Adobe has informed us that they will at some stage be providing new server behaviours for DW but the 'horse has already bolted' Many are abandoning DW as a result of infrequent updates and lack of any understanding about what developers require, for what seems like a decade.

 

Try a programme named 'Wappler' that is up-to-date in terms of database connectivity, plus some BUT only if you are an infrequent developer, someone who has an idea for an app or someone who just manages a company website. Its not a good choice if you are intending to make web-development a long-term career move as you end up without an saleable skills should you wish to ever go an work  for someone else at some point in the future.


Thanks, I am an infrequent developer and looks DW has had its day for me

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices