bjweb

[Log in to get rid of this advertisement]

I recently purchased "build your own databased driven web site using PHP and MYSQL" and have been working though the exercises.

using PHP 5.0.4
mYSQL 4.1.11

from command line mysql appears to do everything that it should ie create dB, INSERT values etc when logged in under root user

Php is intact that is from phpinfo(); and a basic date script provides correct server date time

However the following script is resulting in a blank firefox web page with no error explanation at all

<?php
$link = mysql_connect ('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'connected successfully';
mysql_close($link);
?>

This is straight out of the PHP MYSQL CONNECT MANUAL

I can see no error in the httpd/error-log

Hence I am at a real loss to explain what is wrong

Any help would be appreciated

datopdog

Turn on display_errors in your php.ini file and the error will be displayed in the browser.

bjweb

Reports the following in the web page

Fatal error. Call to undefined function mysql_connect() in var/www/html/test_connect.php on line 9

line 9 is
$link=mysql_connect('localhost', 'root', 'root_pw');


with all statement rem except for the following

<?php
echo "Hello World";
?>

Displays as expected with no problems

I wonder what the problem is???

datopdog

The error is because you do not have the php mysql module installed, what distro are you running ?

simplicissimus

You need the 'php-mysql' package installed to access MySQL from within PHP. You will not have this available by default.

On RedHat/Fedora or similar systems run:
After installation your script will work.

Regards,
SIMP

Fedora Development

bjweb

Thanks for that