your php server doesn't have the mysql module loaded

Question

Dreamweaver 2018have 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

Nancy OShea · Accepted Answer

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 OShea · Answer

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 connectionif (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } else echo "Successfully connected to database, happy coding!"?>

<?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!"

?>

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.