your php server doesnt have the mysql module loaded or you c

[DarthSidus]

Hi I am trying to make a connection with the database in dreamweaver cs6 but when i go to do it the following error message is displayed and i have no idea how to fix it:

your php server doesnt have the mysql module loaded or you cant use the mysql_(p) connect functions

[Nobbie]

Which Xampp did you install? Your description lacks any information about that.

I assume, that you have a PHP 7 Version included, because in PHP 7 the mysql_XXXX functions have been removed. Either adapt your PHP script and use mysqli_XXXX functions instead, or do not use PHP 7, you must go back to PHP 5 Version. You will find appropriate installers on Xampps Download Page.

[DarthSidus]

Hi Sorry i have installed xampp 7.0.13 / PHP 7.0.13. How can I adapt my php script and use mysqli_xxxx bearing in mind im a newbie
thanks

Darth

[JJ_Tagy]

As a newbie, you should learn from the manual (you've probably heard RTFM before) or tutorials. Check out http://php.net/manual/en/function.mysqli-connect.php and http://www.w3schools.com/php/func_mysqli_connect.asp

[Nobbie]

How can I adapt my php script and use mysqli_xxxx bearing in mind im a newbie

There are two options:

a) either edit all your scripts and replace all mysql_xxxx by the corresponding mysqli_xxxx call. CAUTION: the parameter of the functions are NOT identical mysql/mysqli, get you the documentation about mysqli and replace all functions carefully

b) do NOT edit all your script by replacing all mysql_xxxx calls, instead create a single PHP script which declares and rebuilds all mysql_xxx functions via mysqli_xxxx functions. For example:

Code: Select all

<?php

function mysql_connect ($server, $username, $password) {

        return mysqli_connect($server, $username, $password);
}

function mysql_xxxx ....
....

...
?>

Finally include this script into all your PHP scripts which handle with mysql_xxxx functions. This second solution is kind of "quick&dirty", it is better to replace all mysql_xxxx directly via mysqli_xxxx and eventually to adapt the parameters for the corresponding call. This is unfortunately not an easy job for a beginner.

Last not least you may of course go back to PHP 5, probably easier for a newbie.

[DarthSidus]

Which version of xampp should i install?

I would also be very grateful if you could give me step by step instructions on option b fir xampp v7

Regards

Darth

[DarthSidus]

How can I adapt my php script and use mysqli_xxxx bearing in mind im a newbie

There are two options:

a) either edit all your scripts and replace all mysql_xxxx by the corresponding mysqli_xxxx call. CAUTION: the parameter of the functions are NOT identical mysql/mysqli, get you the documentation about mysqli and replace all functions carefully

b) do NOT edit all your script by replacing all mysql_xxxx calls, instead create a single PHP script which declares and rebuilds all mysql_xxx functions via mysqli_xxxx functions. For example:

Code: Select all

<?php

function mysql_connect ($server, $username, $password) {

        return mysqli_connect($server, $username, $password);
}

function mysql_xxxx ....
....

...
?>

Finally include this script into all your PHP scripts which handle with mysql_xxxx functions. This second solution is kind of "quick&dirty", it is better to replace all mysql_xxxx directly via mysqli_xxxx and eventually to adapt the parameters for the corresponding call. This is unfortunately not an easy job for a beginner.

Last not least you may of course go back to PHP 5, probably easier for a newbie.

Which version of xampp should i install?

I would also be very grateful if you could give me step by step instructions on option b fir xampp v7

Regards

Darth

[Nobbie]

Which version of xampp should i install?

The latest which includes PHP 5, that is any Xampp 5.x (please simply look at the Download site, you cannot overlook it).

I would also be very grateful if you could give me step by step instructions on option b fir xampp v7

Sorry, no. That is already a very usefull and fully explained solution, the next step whould already result in writing the whole module for you. I am not intended to do that (that exceeds the free and voluntary help in this forum by far) and it also would not improve your own knowledge, you would stay a newbie further. I told you, its not easy for a newbie but thats as it is. We all have been newbies and had to go the long and hard way to become a skilled PHP programmer.

You still have the option to use Xampp 5 instead, which still contains the mysql functions.