Getting PHP to connect to MYSQL

[carlg]

My mysql db is working fine.  I can connect to it using browser tools, create tables, etc.

 

For some reason I can't get php to connect

There is nothing printed by the mysql_error statement; it just dies at that line.

 

What could be wrong?

 

Here is my code:

 

<?php
$dbhost="localhost";
$dbuser="dbuser";
$dbpass="dbuser";
$db="mydb";

$conn = mysql_connect('$dbhost', '$dbuser', '$dbpass') or die (mysql_error());
mysql_select_db("$db", $conn);
print "connected";
?>

[fenway]

Any php errors being raised?

[carlg]

Nothing I get a blank page when the browser loads.

[carlg]

Actually found this in my apache error log

 

 

Call to undefined function mysql_connect()

 

 

 

mysql_connect is not an undefined function.

 

 

 

 

[Wildbug]

Likely the PHP mysql_* library is not installed.

 

PHP 5+

 

MySQL is not enabled by default, nor is the MySQL library bundled with PHP. Read this FAQ for details on why. Use the --with-mysql[=DIR] configure option to include MySQL support. You can download headers and libraries from » MySQL.

[carlg]

Here is how I fixed this for anyone that is watching.

 

I am running on Win XP.

 

I uninstalled PHP and reinstalled it.

 

There is an option during installation to install the mysql extension.  You need to make sure you select that option and then reinstall.

 

That fixed it for me.