Apache :: MySQL Problem!

Aznsilvrboy · Joined: 06 Jul 2006 Posts: 11

Well I'm following this book called "PHP and MySQL for Dummies 2nd Edition" and after I tested PHP with test.php (works), i added another line of code

phpinfo();" which displays all information associated with PHP on my system. Many tables were displayed upon running test.php meaning that phpinfo(); is working. The book tells me to check the listing if MySQL is enabled by going to the "MySQL" section. My first problem is that there exists no such section in the tables/information generated by phpinfo():. So how can check that MySQL support is On? Another thing I discovered that the configuration path of the php.ini is still C:\Windows\php.ini rather than C:\php\php.ini. How would I go about changing the configuration path of php.ini?

No big deal, so I go off to test a php program called mysql_up.php which is supposed to generate a long list of variable names and values to indicate that MySQL is working fine. However I get this error when I try to point my brower to mysql_up.php:

Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\mysql_up.php on line 10

The code for the program is as follows:

------------------------------------------------------------------

<html>
<head><title>Test MySQL</title></head>
<body>

<?php
$host="localhost";
$user="root";
$password="mysqlpassword";

mysql_connect($host,$user,$password);
$sql="show status";
$result = mysql_query($sql);
if ($result == 0)
{
echo "<b>Error " . mysql_errno() . ": "
. mysql_error() . "</b>";
}
else
{
?>

<table border="1">
<tr><td><b>Variable_name</b></td><td><b>Value</b>
</td></tr>
<?php
for ($i = 0; $i < mysql_num_rows($result); $i++) {
echo "<TR>";
$row_array = mysql_fetch_row($result);
for ($j = 0; $j < mysql_num_fields($result); $j++)
{
echo "<TD>" . $row_array[$j] . "</td>";
}
echo "</tr>";
}
?>
</table>
<?php } ?>
</body></html>

-----------------------------------------------------------------

Now I dont think there's anything wrong with the code. What is wrong here? Thanks.

Working Environment:

Windows XP Pro
MySQL Server 5.0
Apache 2.2.2
PHP 5.1.4

pnllan · Joined: 05 Dec 2005 Posts: 221

Is the MySQL extension 'uncommented' (the ; indicates a comment - meaning that anything after it on a line is ignored) in your PHP.INI?

If I remember, you are using Apache 2.2.2. Did you include the following directive in your HTTPD.CONF?

PHPIniDir "C:/php"

Aznsilvrboy · Joined: 06 Jul 2006 Posts: 11

pnllan · Joined: 05 Dec 2005 Posts: 221

You can use the PHPIniDir directive after the PHP Loadmodule directive.

After you add the PHPIniDir directive, restart Apache and then check your phpinfo.

You might have the MySQL tables listed in phpinfo now.
..
.

Aznsilvrboy · Joined: 06 Jul 2006 Posts: 11

tk · Joined: 27 Jun 2006 Posts: 10

Please don't be offended by this question, but.... have you actually installed, configured, and tested MySql on this machine? The reason that I ask is because you make no mention of it whatsoever in your post. If MySql is already installed and working, you should ensure that the MySql server is running as well. If this is on a Windows machine then you probably installed MySql as a service, which means you can start, stop, and restart it from the Services tab on your Apache Monitor.

Assuming that all of that is taken care of, you still have one more change to make in your php.ini file to get mysql_connect to work. Somewhere around line 500 or so you will see the following...

extension_dir= whatever it is set to

You need to ensure that this line is uncommented, and that the path is set to the ext directory of your PHP install. If you installed php directly on your C:\ drive, then it should read something like this...

extension_dir = "C:\php\ext"

The ext directory is where the actual mysql driver is located. Simply turning it on won't do you any good unless the path to the driver is set correctly.

Hope this helps.

Aznsilvrboy · Joined: 06 Jul 2006 Posts: 11