Re: PHP, MYSQL and Apache

Thomas Hearn <tomh@xxxxxxxxxxxxx> · Tue, 07 Aug 2007 08:53:02 -0400

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@xxxxxxxxxxx] 
Sent: Monday, August 06, 2007 9:56 PM
To: 'KM'
Cc: php-windows@xxxxxxxxxxxxx
Subject: RE:  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@xxxxxxxxxxx] 
Sent: Monday, August 06, 2007 9:22 PM
To: 'Carlton Whitehead'
Cc: php-windows@xxxxxxxxxxxxx
Subject: RE:  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@xxxxxxxxxxxx] 
Sent: Monday, August 06, 2007 9:01 PM
To: KM
Cc: php-windows@xxxxxxxxxxxxx
Subject: Re:  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@xxxxxxxxxxxx] 
Sent: Monday, August 06, 2007 5:11 PM
To: KM
Cc: php-windows@xxxxxxxxxxxxx
Subject: 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@xxxxxxxxxxx>
To: php-windows@xxxxxxxxxxxxx
Sent: Monday, August 6, 2007 4:58:36 PM (GMT-0500) America/New_York
Subject:  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

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php