New Participant

Answered

your php server doesn't have the mysql module loaded

Forum|Forum|6 years ago
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+.

Nancy OShea

Community Expert

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 & Moderator

Nancy OSheaCorrect answer

Community Expert

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 & Moderator

tomc31258978Author

New Participant

7.2

Only have a testing server,localhost

Thanks for responding

Tom

tomc31258978Author

New Participant

as already told you Nancy, mysql drivers are not compatible with with PHP+

two solution migrate to mysqli (easiest coming from an already mysql developed solution)

or use PHP 5.6 max... if it's for local purpose only use xampp , unless I'm mistaken, this one should be fine

https://sourceforge.net/projects/xampp/files/XAMPP%20Windows/5.6.40/

Are there any options to use php and record sets

Tom

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

Scanning file for viruses.

This file cannot be downloaded