Re: PHP, MYSQL and Apache

Keith, Browse to your phpinfo(); page, and search it for mysql. Is it listed? If not, the mysql module isn't enabled, and you shouldn't expect a mysql_connect command to work. You may need to edit your php.ini and enable the php_mysql.dll module. Refer to the results of phpinfo(); for the path to the active php.ini file, since sometimes this can be an unexpected location on Windows machines, at least in my experience. Regards, Carlton Whitehead ----- Original Message ----- From: "KM" <thalor@comcast.net> To: php-windows@lists.php.net Sent: Monday, August 6, 2007 4:58:36 PM (GMT-0500) America/New_York Subject: [PHP-WIN] PHP, MYSQL and Apache I am attempting to use the following together…. MYSQL 5.0 Apache 2.2.4 PHP 5.2.3 PHP info I can get. I get the following statement whenever trying to get to mysql Here is the PHP code for what I’m trying to do… <?php // Connect to the database $dbhost = 'localhost'; $dbusername = 'root'; $dbpasswd = 'joker'; $database_name = 'simple'; $connection = mysql_connect("$dbhost","$dbusername","$dbpasswd") or die ('Couldn\'t connect to server.'); $db = mysql_select_db("$database_name", $connection) or die('Couldn\'t select database.'); // Generate SQL code to store data on database. $insert_sql = 'INSERT INTO simple_table (text) VALUES (\'test text, 1,2,3\')'; // Execute SQL code. mysql_query( $insert_sql ) or die ( 'It Didn\’t Work: ' . mysql_error() ); // Tell User we are done. echo 'Code Inserted'; ?> Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\test_insert_mysql.php on line 7 Anyone had this before and have a solution, it would be appreciated. Keith No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 4:16 PM