PHP and MySQL

Scorpo · Post by **Scorpo** » July 3rd, 2005, 12:18 am

Can anyone tell me how to get PHP to work with MySQL so that I can set up phpbb ??

Smartweb · Post by **Smartweb** » July 3rd, 2005, 3:59 am

It would help to know what operating system you are running.

Scorpo · Post by **Scorpo** » July 3rd, 2005, 12:22 pm

I'm running Micorsoft Windows XP Proffesional. PHP5 and apache2.

Smartweb · Post by **Smartweb** » July 3rd, 2005, 2:40 pm

If PHP and Apache are working (you can test this by making a php file with <? phpinfo(); ?>), enable the mysql extension in the php.ini file. In php5, mysql is not installed by default, so you have to use the extension. Change the line ";extension=php_mysql.dll" to "extension=php_mysql.dll". Then mysql should work, though that doesn't set up phpbb yet.

Scorpo · Post by **Scorpo** » July 3rd, 2005, 7:04 pm

Well, now I'm getting the following error message: PHP Startup: Unable to load dynamic library 'C:\Server\PHP\php_mysql.dll' - The specified module could not be found. I checked the location and it is in the correct spot at the exact location that is listed above. Is that file corrupted?

Scorpo · Post by **Scorpo** » July 4th, 2005, 4:45 pm

Sorry for doubleposting, but I figured this would be more clear as it is an update.

Scorpo · Post by **Scorpo** » July 4th, 2005, 4:46 pm

Sorry for doubleposting, but I figured this would be more clear as it is an update. The error message described in my last posting has now dissapeared thanks to some help changing some configuration files that my friend found. Unfortunately, I still can't connect to the database using php. Using the following code:

Code: Select all

[i]
[/i]<?php
// *****************************
// ** database server section **
// *****************************
$sqlserver = "localhost";
$sqluserid = "scorpo";
$sqlpassword = "bultiger";
$sqldatabase = "database";
if( !@mysql_connect($sqlserver, $sqluserid, $sqlpassword) ) {
echo("Unable to connect to the database at this time.<br><br>");
exit();
}
if( !@mysql_select_db($sqldatabase) ) {
echo("Unable to locate the database at this time.<br><br>");
exit();
}
$sql = "SHOW TABLES from $sqldatabase";
$resultset = @mysql_query($sql);
if( !$resultset ) {
echo("Unable to run a query at this time.<br><br>");
exit();
}
$row = mysql_fetch_array($resultset);
echo("Looks good! Success!");
?>

I get the message: Unable to connect to the database at this time. Any ideas? Please?

Smartweb · Post by **Smartweb** » July 4th, 2005, 8:02 pm

PHP's error message from the connect attempt would be more useful than yours, which only tells which line fails. Make sure php is configured to give error details, comment out the if (!@mysql_connect ... exit(); }, and add mysql_connect($sqlserver, $sqluserid, $sqlpassword). Then post the error message you get. Or perhaps get rid of the @ sign.