Re: PHP, MYSQL and Apache

This sounds very typical of a problem with WHERE in your path MySQL is set. Open up your PATH env variable, and look to see if your PHP ext directory (with the mysql ext) is listed in the path BEFORE your actual MySQL installation. If it isn't, then add it. The dlls that are used by PHP and MySQL have variation and are not actually the same DLL. The path not found error with MySQL is generally a result of a mismatch between dll versions of MySQL, often caused by the location in the path. Same goes for MSSQL. Hopefully that helps. Tom KM wrote:

Yes the directory is in the PATH.... And yes on the second as well.... Keith -----Original Message----- From: Jeff White [mailto:bitslayer@comcast.net] Sent: Monday, August 06, 2007 9:56 PM To: 'KM' Cc: php-windows@lists.php.net Subject: RE: [PHP-WIN] PHP, MYSQL and Apache Hello Keith, I realize this may seem a bit tedious, but is your PHP directory in the Windows PATH environment variable? And, if so, is the "libmysql.dll" file in the PHP directory? Jeff -----Original Message----- From: KM [mailto:thalor@comcast.net] Sent: Monday, August 06, 2007 9:22 PM To: 'Carlton Whitehead' Cc: php-windows@lists.php.net Subject: RE: [PHP-WIN] PHP, MYSQL and Apache Configuration File (php.ini) Path C:\WINDOWS Loaded Configuration File C:\WINDOWS\php.ini This is indeed the ini file I am editing and saving. And yes, any time I've made changes to it, I have restarted apache. Thanks Keith -----Original Message----- From: Carlton Whitehead [mailto:carlton.whitehead@cebesius.com] Sent: Monday, August 06, 2007 9:01 PM To: KM Cc: php-windows@lists.php.net Subject: Re: [PHP-WIN] PHP, MYSQL and Apache Keith, Are you sure that's the same php.ini that is referenced by your phpinfo(); script? Have you restarted Apache since you enabled the extensions? Regards, Carlton Whitehead KM wrote:

Here is the section of my php.ini that contains the information ;extension=php_bz2.dll ;extension=php_curl.dll ;extension=php_dba.dll ;extension=php_dbase.dll ;extension=php_exif.dll ;extension=php_fdf.dll ;extension=php_gd2.dll ;extension=php_gettext.dll ;extension=php_gmp.dll ;extension=php_ifx.dll ;extension=php_imap.dll ;extension=php_interbase.dll ;extension=php_ldap.dll ;extension=php_mbstring.dll ;extension=php_mcrypt.dll ;extension=php_mhash.dll ;extension=php_mime_magic.dll ;extension=php_ming.dll ;extension=php_msql.dll ;extension=php_mssql.dll extension=php_mysql.dll extension=php_mysqli.dll ;extension=php_oci8.dll ;extension=php_openssl.dll ;extension=php_pdo.dll ;extension=php_pdo_firebird.dll ;extension=php_pdo_mssql.dll ;extension=php_pdo_mysql.dll ;extension=php_pdo_oci.dll ;extension=php_pdo_oci8.dll ;extension=php_pdo_odbc.dll ;extension=php_pdo_pgsql.dll ;extension=php_pdo_sqlite.dll ;extension=php_pgsql.dll ;extension=php_pspell.dll ;extension=php_shmop.dll ;extension=php_snmp.dll ;extension=php_soap.dll ;extension=php_sockets.dll ;extension=php_sqlite.dll ;extension=php_sybase_ct.dll ;extension=php_tidy.dll ;extension=php_xmlrpc.dll ;extension=php_xsl.dll ;extension=php_zip.dll Is there something else I am missing? Keith -----Original Message----- From: Carlton Whitehead [mailto:carlton.whitehead@cebesius.com] Sent: Monday, August 06, 2007 5:11 PM To: KM Cc: php-windows@lists.php.net Subject: Re: [PHP-WIN] 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 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007

4:16 PM

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

No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 4:16 PM 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