Skip to main content
tomc31258978
tomc31258978
New Participant
April 26, 2019
Answered

your php server doesn't have the mysql module loaded

  • April 26, 2019
  • 2 replies
  • 31104 views

Dreamweaver 2018

have spent a week and rebuilt Windows 10 Pro twice.

installed mySql, Apache24, myphpAdmin, all function. created a database with table no problem.

have install database extensions.

when i click + for new recordset fill in the form and click Select for the database, i get the error.

your php server doesn't have the mysql module loaded or you can't use the mysql_(p)connect functions.

this question is all over the web with no answers.

thanks for any help,

tom

This topic has been closed for replies.
Correct answer Nancy OShea

Which PHP version do you have on your remote and local testing servers?  If unsure, add this code to a new PHP test page and run it from your server & localhost.

<?php phpinfo() ?>

The deprecated server behaviors in DW are outdated and no longer compatible with PHP 7+. 

2 replies

Nancy OShea
Nancy OShea
Adobe Expert
April 26, 2019

Try using a MySQLi (improved) conntection string.  Change code in red to your own values.

<?php

$con = mysqli_connect("localhost","your_username","your_password","database_name");

// Check connection

if (mysqli_connect_errno())

  {

  echo "Failed to connect to MySQL: " . mysqli_connect_error();

        }

        else echo "Successfully connected to database, happy coding!"

?>

Nancy O'Shea— Product User, Community Expert &amp; Moderator
Nancy OShea
Nancy OSheaCorrect answer
Adobe Expert
April 26, 2019

Which PHP version do you have on your remote and local testing servers?  If unsure, add this code to a new PHP test page and run it from your server & localhost.

<?php phpinfo() ?>

The deprecated server behaviors in DW are outdated and no longer compatible with PHP 7+. 

Nancy O'Shea— Product User, Community Expert &amp; Moderator
tomc31258978
tomc31258978Author
New Participant
April 26, 2019

7.2

Only have a testing server,localhost

Thanks for responding

Tom

B i r n o u
B i r n o u
Adobe Expert
April 26, 2019

Are there any options to use php and record sets

Tom


yes as we told you... the record set that you use is only compatible until PHP 5.6.... so the only chance to run the record set that you have is to run PHP 5.6 maximum

or manually change code from mysql to mysqli

is this clear ? do you need further explanation ?

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