Re: PHP, MYSQL and Apache

Adding the path to the extension and reversing the slashes worked! Thanks to all who replied! K ----- Original Message ----- From: Carlton Whitehead <carlton.whitehead@cebesius.com> To: thalor@comcast.net Cc: bitslayer@comcast.net, php-windows@lists.php.net, Thomas Hearn <tomh@nsoftware.com> Date: Tue, 7 Aug 2007 10:01:16 -0400 (EDT) Subject: Re: [PHP-WIN] PHP, MYSQL and Apache > Keith, > > Go in your php.ini and change that extension path to have / (forward > slashes) instead of \ (backslashes), save it, then restart Apache. > > Regards, > Carlton Whitehead > > ----- Original Message ----- > From: "Keith Mervine" <thalor@comcast.net> > To: "Thomas Hearn" <tomh@nsoftware.com> > Cc: bitslayer@comcast.net, php-windows@lists.php.net > Sent: Tuesday, August 7, 2007 9:56:29 AM (GMT-0500) America/New_York > Subject: Re: [PHP-WIN] PHP, MYSQL and Apache > > > This is from my apache error.log > > [Tue Aug 07 09:53:47 2007] [notice] Parent: Received shutdown signal -- > Shutting down the server. > [Tue Aug 07 09:53:47 2007] [notice] Child 2796: Exit event signaled. Child > process is ending. > [Tue Aug 07 09:53:48 2007] [notice] Child 2796: Released the start mutex > [Tue Aug 07 09:53:49 2007] [notice] Child 2796: Waiting for 250 worker > threads to exit. > [Tue Aug 07 09:53:49 2007] [notice] Child 2796: All worker threads have > exited. > [Tue Aug 07 09:53:49 2007] [notice] Child 2796: Child process is exiting > [Tue Aug 07 09:53:49 2007] [notice] Parent: Child process exited > successfully. > [Tue Aug 07 09:53:50 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.3 > configured > -- resuming normal operations > [Tue Aug 07 09:53:50 2007] [notice] Server built: Jan 9 2007 23:17:20 > [Tue Aug 07 09:53:50 2007] [notice] Parent: Created child process 4720 > PHP Warning: PHP Startup: Unable to load dynamic library > 'C:\\Apache2\\PHP5\\ext\\php_mysql.dll' - The specified module could not be > found.\r\n in Unknown on line 0 > PHP Warning: PHP Startup: Unable to load dynamic library > 'C:\\Apache2\\PHP5\\ext\\php_mysqli.dll' - The specified module could not > be found.\r\n in Unknown on line 0 > [Tue Aug 07 09:53:50 2007] [notice] Child 4720: Child process is running > [Tue Aug 07 09:53:50 2007] [notice] Child 4720: Acquired the start mutex. > [Tue Aug 07 09:53:50 2007] [notice] Child 4720: Starting 250 worker threads. > [Tue Aug 07 09:53:50 2007] [notice] Child 4720: Starting thread to listen > on > port 80. > > > The path doesnt look correct should there be double \ between each folder? > > > > > ----- Original Message ----- > From: Thomas Hearn <tomh@nsoftware.com> > To: KM <thalor@comcast.net> > Cc: bitslayer@comcast.net, php-windows@lists.php.net > Date: Tue, 07 Aug 2007 08:53:02 -0400 > Subject: Re: [PHP-WIN] 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 > > > > > > > > > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >