PHP, MYSQL and Apache

------=_NextPart_000_0003_01C7D84B.09F4BF50
Content-Type: text/plain;
charset="windows-1250"
Content-Transfer-Encoding: quoted-printable

I am attempting to use the following together=85.

=20

MYSQL 5.0

Apache 2.2.4

PHP 5.2.3

=20

PHP info I can get. I get the following statement whenever trying to =
get to
mysql

=20

=20

Here is the PHP code for what I=92m trying to do=85

=20


// Connect to the database

$dbhost =3D 'localhost';

$dbusername =3D 'root';

$dbpasswd =3D 'joker';

$database_name =3D 'simple';

$connection =3D mysql_connect("$dbhost","$dbusername","$dbpasswd")

or die ('Couldn\'t connect to server.');

$db =3D mysql_select_db("$database_name", $connection)

or die('Couldn\'t select database.');

=20

// Generate SQL code to store data on database.

$insert_sql =3D 'INSERT INTO simple_table (text) VALUES (\'test text,
1,2,3\')';

=20

// Execute SQL code.

mysql_query( $insert_sql )

or die ( 'It Didn\=92t Work: ' . mysql_error() );

=20

// Tell User we are done.

echo 'Code Inserted';

?>

=20

=20

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

=20

Anyone had this before and have a solution, it would be appreciated.

=20

Keith


No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007
4:16 PM
=20

------=_NextPart_000_0003_01C7D84B.09F4BF50--

RE: PHP, MYSQL and Apache

Looks like the mysql extension isn't enable in your php.ini. Make sure
it is enabled in the .ini and that the extension is in the appropriate
folder.



-----Original Message-----
From: KM [mailto:thalor@comcast.net]=20
Sent: Monday, August 06, 2007 3:59 PM
To: php-windows@lists.php.net
Subject: [PHP-WIN] PHP, MYSQL and Apache

I am attempting to use the following together....

=20

MYSQL 5.0

Apache 2.2.4

PHP 5.2.3

=20

PHP info I can get. I get the following statement whenever trying to
get to
mysql

=20

=20

Here is the PHP code for what I'm trying to do...

=20


// Connect to the database

$dbhost =3D 'localhost';

$dbusername =3D 'root';

$dbpasswd =3D 'joker';

$database_name =3D 'simple';

$connection =3D mysql_connect("$dbhost","$dbusername","$dbpasswd")

or die ('Couldn\'t connect to server.');

$db =3D mysql_select_db("$database_name", $connection)

or die('Couldn\'t select database.');

=20

// Generate SQL code to store data on database.

$insert_sql =3D 'INSERT INTO simple_table (text) VALUES (\'test text,
1,2,3\')';

=20

// Execute SQL code.

mysql_query( $insert_sql )

or die ( 'It Didn\'t Work: ' . mysql_error() );

=20

// Tell User we are done.

echo 'Code Inserted';

?>

=20

=20

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

=20

Anyone had this before and have a solution, it would be appreciated.

=20

Keith


No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007
4:16 PM
=20

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

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_conn=
ect command to work. You may need to edit your php.ini and enable the php_=
mysql.dll module. =20

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"
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â€=A6.

=20

MYSQL 5.0

Apache 2.2.4

PHP 5.2.3

=20

PHP info I can get. I get the following statement whenever trying to get t=
o
mysql

=20

=20

Here is the PHP code for what Iâ€=99m trying to doâ€=A6

=20


// Connect to the database

$dbhost =3D 'localhost';

$dbusername =3D 'root';

$dbpasswd =3D 'joker';

$database_name =3D 'simple';

$connection =3D mysql_connect("$dbhost","$dbusername","$dbpasswd")

or die ('Couldn\'t connect to server.');

$db =3D mysql_select_db("$database_name", $connection)

or die('Couldn\'t select database.');

=20

// Generate SQL code to store data on database.

$insert_sql =3D 'INSERT INTO simple_table (text) VALUES (\'test text,
1,2,3\')';

=20

// Execute SQL code.

mysql_query( $insert_sql )

or die ( 'It Didn\â€=99t Work: ' . mysql_error() );

=20

// Tell User we are done.

echo 'Code Inserted';

?>

=20

=20

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

=20

Anyone had this before and have a solution, it would be appreciated.

=20

Keith


No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007
4:16 PM
=20

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

RE: PHP, MYSQL and Apache

Here is the section of my php.ini that contains the information

;extension=3Dphp_bz2.dll
;extension=3Dphp_curl.dll
;extension=3Dphp_dba.dll
;extension=3Dphp_dbase.dll
;extension=3Dphp_exif.dll
;extension=3Dphp_fdf.dll
;extension=3Dphp_gd2.dll
;extension=3Dphp_gettext.dll
;extension=3Dphp_gmp.dll
;extension=3Dphp_ifx.dll
;extension=3Dphp_imap.dll
;extension=3Dphp_interbase.dll
;extension=3Dphp_ldap.dll
;extension=3Dphp_mbstring.dll
;extension=3Dphp_mcrypt.dll
;extension=3Dphp_mhash.dll
;extension=3Dphp_mime_magic.dll
;extension=3Dphp_ming.dll
;extension=3Dphp_msql.dll
;extension=3Dphp_mssql.dll
extension=3Dphp_mysql.dll
extension=3Dphp_mysqli.dll
;extension=3Dphp_oci8.dll
;extension=3Dphp_openssl.dll
;extension=3Dphp_pdo.dll
;extension=3Dphp_pdo_firebird.dll
;extension=3Dphp_pdo_mssql.dll
;extension=3Dphp_pdo_mysql.dll
;extension=3Dphp_pdo_oci.dll
;extension=3Dphp_pdo_oci8.dll
;extension=3Dphp_pdo_odbc.dll
;extension=3Dphp_pdo_pgsql.dll
;extension=3Dphp_pdo_sqlite.dll
;extension=3Dphp_pgsql.dll
;extension=3Dphp_pspell.dll
;extension=3Dphp_shmop.dll
;extension=3Dphp_snmp.dll
;extension=3Dphp_soap.dll
;extension=3Dphp_sockets.dll
;extension=3Dphp_sqlite.dll
;extension=3Dphp_sybase_ct.dll
;extension=3Dphp_tidy.dll
;extension=3Dphp_xmlrpc.dll
;extension=3Dphp_xsl.dll
;extension=3Dphp_zip.dll

Is there something else I am missing?

Keith


-----Original Message-----
From: Carlton Whitehead [mailto:carlton.whitehead@cebesius.com]=20
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. =20

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"
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â€=A6.

=20

MYSQL 5.0

Apache 2.2.4

PHP 5.2.3

=20

PHP info I can get. I get the following statement whenever trying to =
get to
mysql

=20

=20

Here is the PHP code for what Iâ€=99m trying to doâ€=A6

=20


// Connect to the database

$dbhost =3D 'localhost';

$dbusername =3D 'root';

$dbpasswd =3D 'joker';

$database_name =3D 'simple';

$connection =3D mysql_connect("$dbhost","$dbusername","$dbpasswd")

or die ('Couldn\'t connect to server.');

$db =3D mysql_select_db("$database_name", $connection)

or die('Couldn\'t select database.');

=20

// Generate SQL code to store data on database.

$insert_sql =3D 'INSERT INTO simple_table (text) VALUES (\'test text,
1,2,3\')';

=20

// Execute SQL code.

mysql_query( $insert_sql )

or die ( 'It Didn\â€=99t Work: ' . mysql_error() );

=20

// Tell User we are done.

echo 'Code Inserted';

?>

=20

=20

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

=20

Anyone had this before and have a solution, it would be appreciated.

=20

Keith


No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007
4:16 PM
=20

No virus found in this incoming message.
Checked by AVG Free Edition.=20
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 =
4:16 PM
=20

No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 =
4:16 PM
=20

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

Re: PHP, MYSQL and Apache

Keith,

Are you sure that's the same php.ini that is referenced by your=20
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
>=20
> ;extension=3Dphp_bz2.dll
> ;extension=3Dphp_curl.dll
> ;extension=3Dphp_dba.dll
> ;extension=3Dphp_dbase.dll
> ;extension=3Dphp_exif.dll
> ;extension=3Dphp_fdf.dll
> ;extension=3Dphp_gd2.dll
> ;extension=3Dphp_gettext.dll
> ;extension=3Dphp_gmp.dll
> ;extension=3Dphp_ifx.dll
> ;extension=3Dphp_imap.dll
> ;extension=3Dphp_interbase.dll
> ;extension=3Dphp_ldap.dll
> ;extension=3Dphp_mbstring.dll
> ;extension=3Dphp_mcrypt.dll
> ;extension=3Dphp_mhash.dll
> ;extension=3Dphp_mime_magic.dll
> ;extension=3Dphp_ming.dll
> ;extension=3Dphp_msql.dll
> ;extension=3Dphp_mssql.dll
> extension=3Dphp_mysql.dll
> extension=3Dphp_mysqli.dll
> ;extension=3Dphp_oci8.dll
> ;extension=3Dphp_openssl.dll
> ;extension=3Dphp_pdo.dll
> ;extension=3Dphp_pdo_firebird.dll
> ;extension=3Dphp_pdo_mssql.dll
> ;extension=3Dphp_pdo_mysql.dll
> ;extension=3Dphp_pdo_oci.dll
> ;extension=3Dphp_pdo_oci8.dll
> ;extension=3Dphp_pdo_odbc.dll
> ;extension=3Dphp_pdo_pgsql.dll
> ;extension=3Dphp_pdo_sqlite.dll
> ;extension=3Dphp_pgsql.dll
> ;extension=3Dphp_pspell.dll
> ;extension=3Dphp_shmop.dll
> ;extension=3Dphp_snmp.dll
> ;extension=3Dphp_soap.dll
> ;extension=3Dphp_sockets.dll
> ;extension=3Dphp_sqlite.dll
> ;extension=3Dphp_sybase_ct.dll
> ;extension=3Dphp_tidy.dll
> ;extension=3Dphp_xmlrpc.dll
> ;extension=3Dphp_xsl.dll
> ;extension=3Dphp_zip.dll
>=20
> Is there something else I am missing?
>=20
> Keith
>=20
>=20
> -----Original Message-----
> From: Carlton Whitehead [mailto:carlton.whitehead@cebesius.com]=20
> Sent: Monday, August 06, 2007 5:11 PM
> To: KM
> Cc: php-windows@lists.php.net
> Subject: Re: [PHP-WIN] PHP, MYSQL and Apache
>=20
> Keith,
>=20
> 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 mysq=
l_connect command to work. You may need to edit your php.ini and enable =
the php_mysql.dll module. =20
>=20
> Refer to the results of phpinfo(); for the path to the active php.ini f=
ile, since sometimes this can be an unexpected location on Windows machin=
es, at least in my experience.
>=20
> Regards,
> Carlton Whitehead
>=20
> ----- Original Message -----
> From: "KM"
> 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
>=20
> I am attempting to use the following togetherâ€=A6.
>=20
> =20
>=20
> MYSQL 5.0
>=20
> Apache 2.2.4
>=20
> PHP 5.2.3
>=20
> =20
>=20
> PHP info I can get. I get the following statement whenever trying to g=
et to
> mysql
>=20
> =20
>=20
> =20
>=20
> Here is the PHP code for what Iâ€=99m trying to doâ€=A6
>=20
> =20
>=20
> >=20
> // Connect to the database
>=20
> $dbhost =3D 'localhost';
>=20
> $dbusername =3D 'root';
>=20
> $dbpasswd =3D 'joker';
>=20
> $database_name =3D 'simple';
>=20
> $connection =3D mysql_connect("$dbhost","$dbusername","$dbpasswd")
>=20
> or die ('Couldn\'t connect to server.');
>=20
> $db =3D mysql_select_db("$database_name", $connection)
>=20
> or die('Couldn\'t select database.');
>=20
> =20
>=20
> // Generate SQL code to store data on database.
>=20
> $insert_sql =3D 'INSERT INTO simple_table (text) VALUES (\'test text,
> 1,2,3\')';
>=20
> =20
>=20
> // Execute SQL code.
>=20
> mysql_query( $insert_sql )
>=20
> or die ( 'It Didn\â€=99t Work: ' . mysql_error() );
>=20
> =20
>=20
> // Tell User we are done.
>=20
> echo 'Code Inserted';
>=20
> ?>
>=20
> =20
>=20
> =20
>=20
> 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
>=20
> =20
>=20
> Anyone had this before and have a solution, it would be appreciated.
>=20
> =20
>=20
> Keith
>=20
>=20
> No virus found in this outgoing message.
> Checked by AVG Free Edition.=20
> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/200=
7
> 4:16 PM
> =20
>=20
> No virus found in this incoming message.
> Checked by AVG Free Edition.=20
> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/200=
7 4:16 PM
> =20
>=20
> No virus found in this outgoing message.
> Checked by AVG Free Edition.=20
> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/200=
7 4:16 PM
> =20
>=20

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

RE: PHP, MYSQL and Apache

Configuration File (php.ini) Path C:\WINDOWS =20
Loaded Configuration File C:\WINDOWS\php.ini =20

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]=20
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=20
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
>=20
> ;extension=3Dphp_bz2.dll
> ;extension=3Dphp_curl.dll
> ;extension=3Dphp_dba.dll
> ;extension=3Dphp_dbase.dll
> ;extension=3Dphp_exif.dll
> ;extension=3Dphp_fdf.dll
> ;extension=3Dphp_gd2.dll
> ;extension=3Dphp_gettext.dll
> ;extension=3Dphp_gmp.dll
> ;extension=3Dphp_ifx.dll
> ;extension=3Dphp_imap.dll
> ;extension=3Dphp_interbase.dll
> ;extension=3Dphp_ldap.dll
> ;extension=3Dphp_mbstring.dll
> ;extension=3Dphp_mcrypt.dll
> ;extension=3Dphp_mhash.dll
> ;extension=3Dphp_mime_magic.dll
> ;extension=3Dphp_ming.dll
> ;extension=3Dphp_msql.dll
> ;extension=3Dphp_mssql.dll
> extension=3Dphp_mysql.dll
> extension=3Dphp_mysqli.dll
> ;extension=3Dphp_oci8.dll
> ;extension=3Dphp_openssl.dll
> ;extension=3Dphp_pdo.dll
> ;extension=3Dphp_pdo_firebird.dll
> ;extension=3Dphp_pdo_mssql.dll
> ;extension=3Dphp_pdo_mysql.dll
> ;extension=3Dphp_pdo_oci.dll
> ;extension=3Dphp_pdo_oci8.dll
> ;extension=3Dphp_pdo_odbc.dll
> ;extension=3Dphp_pdo_pgsql.dll
> ;extension=3Dphp_pdo_sqlite.dll
> ;extension=3Dphp_pgsql.dll
> ;extension=3Dphp_pspell.dll
> ;extension=3Dphp_shmop.dll
> ;extension=3Dphp_snmp.dll
> ;extension=3Dphp_soap.dll
> ;extension=3Dphp_sockets.dll
> ;extension=3Dphp_sqlite.dll
> ;extension=3Dphp_sybase_ct.dll
> ;extension=3Dphp_tidy.dll
> ;extension=3Dphp_xmlrpc.dll
> ;extension=3Dphp_xsl.dll
> ;extension=3Dphp_zip.dll
>=20
> Is there something else I am missing?
>=20
> Keith
>=20
>=20
> -----Original Message-----
> From: Carlton Whitehead [mailto:carlton.whitehead@cebesius.com]=20
> Sent: Monday, August 06, 2007 5:11 PM
> To: KM
> Cc: php-windows@lists.php.net
> Subject: Re: [PHP-WIN] PHP, MYSQL and Apache
>=20
> Keith,
>=20
> 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. =20
>=20
> 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.
>=20
> Regards,
> Carlton Whitehead
>=20
> ----- Original Message -----
> From: "KM"
> 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
>=20
> I am attempting to use the following togetherâ€=A6.
>=20
> =20
>=20
> MYSQL 5.0
>=20
> Apache 2.2.4
>=20
> PHP 5.2.3
>=20
> =20
>=20
> PHP info I can get. I get the following statement whenever trying to =
get to
> mysql
>=20
> =20
>=20
> =20
>=20
> Here is the PHP code for what Iâ€=99m trying to doâ€=A6
>=20
> =20
>=20
> >=20
> // Connect to the database
>=20
> $dbhost =3D 'localhost';
>=20
> $dbusername =3D 'root';
>=20
> $dbpasswd =3D 'joker';
>=20
> $database_name =3D 'simple';
>=20
> $connection =3D mysql_connect("$dbhost","$dbusername","$dbpasswd")
>=20
> or die ('Couldn\'t connect to server.');
>=20
> $db =3D mysql_select_db("$database_name", $connection)
>=20
> or die('Couldn\'t select database.');
>=20
> =20
>=20
> // Generate SQL code to store data on database.
>=20
> $insert_sql =3D 'INSERT INTO simple_table (text) VALUES (\'test text,
> 1,2,3\')';
>=20
> =20
>=20
> // Execute SQL code.
>=20
> mysql_query( $insert_sql )
>=20
> or die ( 'It Didn\â€=99t Work: ' . mysql_error() );
>=20
> =20
>=20
> // Tell User we are done.
>=20
> echo 'Code Inserted';
>=20
> ?>
>=20
> =20
>=20
> =20
>=20
> 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
>=20
> =20
>=20
> Anyone had this before and have a solution, it would be appreciated.
>=20
> =20
>=20
> Keith
>=20
>=20
> No virus found in this outgoing message.
> Checked by AVG Free Edition.=20
> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: =
8/5/2007
> 4:16 PM
> =20
>=20
> No virus found in this incoming message.
> Checked by AVG Free Edition.=20
> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: =
8/5/2007 4:16 PM
> =20
>=20
> No virus found in this outgoing message.
> Checked by AVG Free Edition.=20
> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: =
8/5/2007 4:16 PM
> =20
>=20

No virus found in this incoming message.
Checked by AVG Free Edition.=20
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 =
4:16 PM
=20

No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 =
4:16 PM
=20

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

RE: PHP, MYSQL and Apache

Not sure if this is the cause but I get this error in my apache error =
log

PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Program =
Files\\PHP\\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:\\Program =
Files\\PHP\\ext\\php_mysqli.dll' - The specified module could not be =
found.\r\n in Unknown on line 0

The files are there but should it be trying to access them with the =
path? It shouldnâ€=99t have all those double \ should it?

-----Original Message-----
From: Carlton Whitehead [mailto:carlton.whitehead@cebesius.com]=20
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=20
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
>=20
> ;extension=3Dphp_bz2.dll
> ;extension=3Dphp_curl.dll
> ;extension=3Dphp_dba.dll
> ;extension=3Dphp_dbase.dll
> ;extension=3Dphp_exif.dll
> ;extension=3Dphp_fdf.dll
> ;extension=3Dphp_gd2.dll
> ;extension=3Dphp_gettext.dll
> ;extension=3Dphp_gmp.dll
> ;extension=3Dphp_ifx.dll
> ;extension=3Dphp_imap.dll
> ;extension=3Dphp_interbase.dll
> ;extension=3Dphp_ldap.dll
> ;extension=3Dphp_mbstring.dll
> ;extension=3Dphp_mcrypt.dll
> ;extension=3Dphp_mhash.dll
> ;extension=3Dphp_mime_magic.dll
> ;extension=3Dphp_ming.dll
> ;extension=3Dphp_msql.dll
> ;extension=3Dphp_mssql.dll
> extension=3Dphp_mysql.dll
> extension=3Dphp_mysqli.dll
> ;extension=3Dphp_oci8.dll
> ;extension=3Dphp_openssl.dll
> ;extension=3Dphp_pdo.dll
> ;extension=3Dphp_pdo_firebird.dll
> ;extension=3Dphp_pdo_mssql.dll
> ;extension=3Dphp_pdo_mysql.dll
> ;extension=3Dphp_pdo_oci.dll
> ;extension=3Dphp_pdo_oci8.dll
> ;extension=3Dphp_pdo_odbc.dll
> ;extension=3Dphp_pdo_pgsql.dll
> ;extension=3Dphp_pdo_sqlite.dll
> ;extension=3Dphp_pgsql.dll
> ;extension=3Dphp_pspell.dll
> ;extension=3Dphp_shmop.dll
> ;extension=3Dphp_snmp.dll
> ;extension=3Dphp_soap.dll
> ;extension=3Dphp_sockets.dll
> ;extension=3Dphp_sqlite.dll
> ;extension=3Dphp_sybase_ct.dll
> ;extension=3Dphp_tidy.dll
> ;extension=3Dphp_xmlrpc.dll
> ;extension=3Dphp_xsl.dll
> ;extension=3Dphp_zip.dll
>=20
> Is there something else I am missing?
>=20
> Keith
>=20
>=20
> -----Original Message-----
> From: Carlton Whitehead [mailto:carlton.whitehead@cebesius.com]=20
> Sent: Monday, August 06, 2007 5:11 PM
> To: KM
> Cc: php-windows@lists.php.net
> Subject: Re: [PHP-WIN] PHP, MYSQL and Apache
>=20
> Keith,
>=20
> 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. =20
>=20
> 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.
>=20
> Regards,
> Carlton Whitehead
>=20
> ----- Original Message -----
> From: "KM"
> 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
>=20
> I am attempting to use the following togetherâ€=A6.
>=20
> =20
>=20
> MYSQL 5.0
>=20
> Apache 2.2.4
>=20
> PHP 5.2.3
>=20
> =20
>=20
> PHP info I can get. I get the following statement whenever trying to =
get to
> mysql
>=20
> =20
>=20
> =20
>=20
> Here is the PHP code for what Iâ€=99m trying to doâ€=A6
>=20
> =20
>=20
> >=20
> // Connect to the database
>=20
> $dbhost =3D 'localhost';
>=20
> $dbusername =3D 'root';
>=20
> $dbpasswd =3D 'joker';
>=20
> $database_name =3D 'simple';
>=20
> $connection =3D mysql_connect("$dbhost","$dbusername","$dbpasswd")
>=20
> or die ('Couldn\'t connect to server.');
>=20
> $db =3D mysql_select_db("$database_name", $connection)
>=20
> or die('Couldn\'t select database.');
>=20
> =20
>=20
> // Generate SQL code to store data on database.
>=20
> $insert_sql =3D 'INSERT INTO simple_table (text) VALUES (\'test text,
> 1,2,3\')';
>=20
> =20
>=20
> // Execute SQL code.
>=20
> mysql_query( $insert_sql )
>=20
> or die ( 'It Didn\â€=99t Work: ' . mysql_error() );
>=20
> =20
>=20
> // Tell User we are done.
>=20
> echo 'Code Inserted';
>=20
> ?>
>=20
> =20
>=20
> =20
>=20
> 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
>=20
> =20
>=20
> Anyone had this before and have a solution, it would be appreciated.
>=20
> =20
>=20
> Keith
>=20
>=20
> No virus found in this outgoing message.
> Checked by AVG Free Edition.=20
> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: =
8/5/2007
> 4:16 PM
> =20
>=20
> No virus found in this incoming message.
> Checked by AVG Free Edition.=20
> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: =
8/5/2007 4:16 PM
> =20
>=20
> No virus found in this outgoing message.
> Checked by AVG Free Edition.=20
> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: =
8/5/2007 4:16 PM
> =20
>=20

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

No virus found in this incoming message.
Checked by AVG Free Edition.=20
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 =
4:16 PM
=20

No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 =
4:16 PM
=20

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

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@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"
> 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.
>
>
>
> >
> // 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

RE: PHP, MYSQL and Apache

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"
> 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.
>
>
>
> >
> // 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

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

RE: PHP, MYSQL and Apache

I always have 'small' issues configuring mysql extensions for PHP in windows.

What does you extension_dir directive look like in the php.ini config
file? is it something like this...

extension_dir="C:\Program Files\PHP\ext"

> Not sure if this is the cause but I get this error in my apache error log
>
> PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Program
> Files\\PHP\\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:\\Program
> Files\\PHP\\ext\\php_mysqli.dll' - The specified module could not be
> found.\r\n in Unknown on line 0
>
> The files are there but should it be trying to access them with the path?
> It shouldn’t have all those double \ should it?
>
> -----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"
>> 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…
>>
>>
>>
>> >>
>> // 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
>>
>>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> 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

RE: PHP, MYSQL and Apache

WWVzIGl0IGlzIGV4YWN0bHkgbGlrZSB0aGF0IGFzIGEgbWF0dGVyIG9mIGZh Y3QuICBJdCBwb2ludH
MgdG8gdGhlIGNvcnJlY3QgDQpkaXJlY3Rvcnkgd2hlcmUgdGhlIGRsbHMgYX JlLg0KDQotLS0tLSBP
cmlnaW5hbCBNZXNzYWdlIC0tLS0tDQpGcm9tOiBoYnVydG9uQG1yYWVudGVy dGFpbm1lbnQuY29tDQ
pUbzogIktNIiA8dGhhbG9yQGNvbWNhc3QubmV0Pg0KQ2M6ICInQ2FybHRvbi BXaGl0ZWhlYWQnIiA8
Y2FybHRvbi53aGl0ZWhlYWRAY2ViZXNpdXMuY29tPiwgIA0KcGhwLXdpbmRv d3NAbGlzdHMucGhwLm
5ldA0KRGF0ZTogVHVlLCA3IEF1ZyAyMDA3IDE3OjMxOjM5ICsxMDAwIChFU1 QpDQpTdWJqZWN0OiBS
RTogW1BIUC1XSU5dIFBIUCwgTVlTUUwgYW5kIEFwYWNoZQ0KDQo+IEkgYWx3 YXlzIGhhdmUgJ3NtYW
xsJyBpc3N1ZXMgY29uZmlndXJpbmcgbXlzcWwgZXh0ZW5zaW9ucyBmb3IgUE hQIGluIA0KPiB3aW5k
b3dzLg0KPiANCj4gV2hhdCBkb2VzIHlvdSBleHRlbnNpb25fZGlyIGRpcmVj dGl2ZSBsb29rIGxpa2
UgaW4gdGhlIHBocC5pbmkgY29uZmlnDQo+IGZpbGU/IGlzIGl0IHNvbWV0aG luZyBsaWtlIHRoaXMu
Li4NCj4gDQo+IGV4dGVuc2lvbl9kaXI9IkM6XFByb2dyYW0gRmlsZXNcUEhQ XGV4dCINCj4gDQo+ID
4gTm90IHN1cmUgaWYgdGhpcyBpcyB0aGUgY2F1c2UgYnV0IEkgZ2V0IHRoaX MgZXJyb3IgaW4gbXkg
YXBhY2hlIGVycm9yIGxvZw0KPiA+DQo+ID4gUEhQIFdhcm5pbmc6ICBQSFAg U3RhcnR1cDogVW5hYm
xlIHRvIGxvYWQgZHluYW1pYyBsaWJyYXJ5ICdDOlxcUHJvZ3JhbQ0KPiA+IE ZpbGVzXFxQSFBcXGV4
dFxccGhwX215c3FsLmRsbCcgLSBUaGUgc3BlY2lmaWVkIG1vZHVsZSBjb3Vs ZCBub3QgYmUNCj4gPi
Bmb3VuZC5cclxuIGluIFVua25vd24gb24gbGluZSAwDQo+ID4gUEhQIFdhcm 5pbmc6ICBQSFAgU3Rh
cnR1cDogVW5hYmxlIHRvIGxvYWQgZHluYW1pYyBsaWJyYXJ5ICdDOlxcUHJv Z3JhbQ0KPiA+IEZpbG
VzXFxQSFBcXGV4dFxccGhwX215c3FsaS5kbGwnIC0gVGhlIHNwZWNpZmllZC Btb2R1bGUgY291bGQg
bm90IGJlDQo+ID4gZm91bmQuXHJcbiBpbiBVbmtub3duIG9uIGxpbmUgMA0K PiA+DQo+ID4gVGhlIG
ZpbGVzIGFyZSB0aGVyZSBidXQgc2hvdWxkIGl0IGJlIHRyeWluZyB0byBhY2 Nlc3MgdGhlbSB3aXRo
IHRoZSBwYXRoPw0KPiA+IEl0IHNob3VsZG7igJl0IGhhdmUgYWxsIHRob3Nl IGRvdWJsZSBcIHNob3
VsZCBpdD8NCj4gPg0KPiA+IC0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQ o+ID4gRnJvbTogQ2Fy
bHRvbiBXaGl0ZWhlYWQgW21haWx0bzpjYXJsdG9uLndoaXRlaGVhZEBjZWJl c2l1cy5jb21dDQo+ID
4gU2VudDogTW9uZGF5LCBBdWd1c3QgMDYsIDIwMDcgOTowMSBQTQ0KPiA+IF RvOiBLTQ0KPiA+IENj
OiBwaHAtd2luZG93c0BsaXN0cy5waHAubmV0DQo+ID4gU3ViamVjdDogUmU6 IFtQSFAtV0lOXSBQSF
AsIE1ZU1FMIGFuZCBBcGFjaGUNCj4gPg0KPiA+IEtlaXRoLA0KPiA+DQo+ID 4gQXJlIHlvdSBzdXJl
IHRoYXQncyB0aGUgc2FtZSBwaHAuaW5pIHRoYXQgaXMgcmVmZXJlbmNlZCBi eSB5b3VyDQo+ID4gcG
hwaW5mbygpOyBzY3JpcHQ/DQo+ID4NCj4gPiBIYXZlIHlvdSByZXN0YXJ0ZW QgQXBhY2hlIHNpbmNl
IHlvdSBlbmFibGVkIHRoZSBleHRlbnNpb25zPw0KPiA+DQo+ID4gUmVnYXJk cywNCj4gPiBDYXJsdG
9uIFdoaXRlaGVhZA0KPiA+DQo+ID4NCj4gPiBLTSB3cm90ZToNCj4gPj4gSG VyZSBpcyB0aGUgc2Vj
dGlvbiBvZiBteSBwaHAuaW5pIHRoYXQgY29udGFpbnMgdGhlIGluZm9ybWF0 aW9uDQo+ID4+DQo+ID
4+IDtleHRlbnNpb249cGhwX2J6Mi5kbGwNCj4gPj4gO2V4dGVuc2lvbj1waH BfY3VybC5kbGwNCj4g
Pj4gO2V4dGVuc2lvbj1waHBfZGJhLmRsbA0KPiA+PiA7ZXh0ZW5zaW9uPXBo cF9kYmFzZS5kbGwNCj
4gPj4gO2V4dGVuc2lvbj1waHBfZXhpZi5kbGwNCj4gPj4gO2V4dGVuc2lvbj 1waHBfZmRmLmRsbA0K
PiA+PiA7ZXh0ZW5zaW9uPXBocF9nZDIuZGxsDQo+ID4+IDtleHRlbnNpb249 cGhwX2dldHRleHQuZG
xsDQo+ID4+IDtleHRlbnNpb249cGhwX2dtcC5kbGwNCj4gPj4gO2V4dGVuc2 lvbj1waHBfaWZ4LmRs
bA0KPiA+PiA7ZXh0ZW5zaW9uPXBocF9pbWFwLmRsbA0KPiA+PiA7ZXh0ZW5z aW9uPXBocF9pbnRlcm
Jhc2UuZGxsDQo+ID4+IDtleHRlbnNpb249cGhwX2xkYXAuZGxsDQo+ID4+ID tleHRlbnNpb249cGhw
X21ic3RyaW5nLmRsbA0KPiA+PiA7ZXh0ZW5zaW9uPXBocF9tY3J5cHQuZGxs DQo+ID4+IDtleHRlbn
Npb249cGhwX21oYXNoLmRsbA0KPiA+PiA7ZXh0ZW5zaW9uPXBocF9taW1lX2 1hZ2ljLmRsbA0KPiA+
PiA7ZXh0ZW5zaW9uPXBocF9taW5nLmRsbA0KPiA+PiA7ZXh0ZW5zaW9uPXBo cF9tc3FsLmRsbA0KPi
A+PiA7ZXh0ZW5zaW9uPXBocF9tc3NxbC5kbGwNCj4gPj4gZXh0ZW5zaW9uPX BocF9teXNxbC5kbGwN
Cj4gPj4gZXh0ZW5zaW9uPXBocF9teXNxbGkuZGxsDQo+ID4+IDtleHRlbnNp b249cGhwX29jaTguZG
xsDQo+ID4+IDtleHRlbnNpb249cGhwX29wZW5zc2wuZGxsDQo+ID4+IDtleH RlbnNpb249cGhwX3Bk
by5kbGwNCj4gPj4gO2V4dGVuc2lvbj1waHBfcGRvX2ZpcmViaXJkLmRsbA0K PiA+PiA7ZXh0ZW5zaW
9uPXBocF9wZG9fbXNzcWwuZGxsDQo+ID4+IDtleHRlbnNpb249cGhwX3Bkb1 9teXNxbC5kbGwNCj4g
Pj4gO2V4dGVuc2lvbj1waHBfcGRvX29jaS5kbGwNCj4gPj4gO2V4dGVuc2lv bj1waHBfcGRvX29jaT
guZGxsDQo+ID4+IDtleHRlbnNpb249cGhwX3Bkb19vZGJjLmRsbA0KPiA+Pi A7ZXh0ZW5zaW9uPXBo
cF9wZG9fcGdzcWwuZGxsDQo+ID4+IDtleHRlbnNpb249cGhwX3Bkb19zcWxp dGUuZGxsDQo+ID4+ID
tleHRlbnNpb249cGhwX3Bnc3FsLmRsbA0KPiA+PiA7ZXh0ZW5zaW9uPXBocF 9wc3BlbGwuZGxsDQo+
ID4+IDtleHRlbnNpb249cGhwX3NobW9wLmRsbA0KPiA+PiA7ZXh0ZW5zaW9u PXBocF9zbm1wLmRsbA
0KPiA+PiA7ZXh0ZW5zaW9uPXBocF9zb2FwLmRsbA0KPiA+PiA7ZXh0ZW5zaW 9uPXBocF9zb2NrZXRz
LmRsbA0KPiA+PiA7ZXh0ZW5zaW9uPXBocF9zcWxpdGUuZGxsDQo+ID4+IDtl eHRlbnNpb249cGhwX3
N5YmFzZV9jdC5kbGwNCj4gPj4gO2V4dGVuc2lvbj1waHBfdGlkeS5kbGwNCj 4gPj4gO2V4dGVuc2lv
bj1waHBfeG1scnBjLmRsbA0KPiA+PiA7ZXh0ZW5zaW9uPXBocF94c2wuZGxs DQo+ID4+IDtleHRlbn
Npb249cGhwX3ppcC5kbGwNCj4gPj4NCj4gPj4gSXMgdGhlcmUgc29tZXRoaW 5nIGVsc2UgSSBhbSBt
aXNzaW5nPw0KPiA+Pg0KPiA+PiBLZWl0aA0KPiA+Pg0KPiA+Pg0KPiA+PiAt LS0tLU9yaWdpbmFsIE
1lc3NhZ2UtLS0tLQ0KPiA+PiBGcm9tOiBDYXJsdG9uIFdoaXRlaGVhZCBbbW FpbHRvOmNhcmx0b24u
d2hpdGVoZWFkQGNlYmVzaXVzLmNvbV0NCj4gPj4gU2VudDogTW9uZGF5LCBB dWd1c3QgMDYsIDIwMD
cgNToxMSBQTQ0KPiA+PiBUbzogS00NCj4gPj4gQ2M6IHBocC13aW5kb3dzQG xpc3RzLnBocC5uZXQN
Cj4gPj4gU3ViamVjdDogUmU6IFtQSFAtV0lOXSBQSFAsIE1ZU1FMIGFuZCBB cGFjaGUNCj4gPj4NCj
4gPj4gS2VpdGgsDQo+ID4+DQo+ID4+IEJyb3dzZSB0byB5b3VyIHBocGluZm 8oKTsgcGFnZSwgYW5k
IHNlYXJjaCBpdCBmb3IgbXlzcWwuICBJcyBpdCBsaXN0ZWQ/DQo+ID4+IElm IG5vdCwgdGhlIG15c3
FsIG1vZHVsZSBpc24ndCBlbmFibGVkLCBhbmQgeW91IHNob3VsZG4ndCBleH BlY3QgYQ0KPiA+PiBt
eXNxbF9jb25uZWN0IGNvbW1hbmQgdG8gd29yay4gIFlvdSBtYXkgbmVlZCB0 byBlZGl0IHlvdXIgcG
hwLmluaSBhbmQNCj4gPj4gZW5hYmxlIHRoZSBwaHBfbXlzcWwuZGxsIG1vZH VsZS4NCj4gPj4NCj4g
Pj4gUmVmZXIgdG8gdGhlIHJlc3VsdHMgb2YgcGhwaW5mbygpOyBmb3IgdGhl IHBhdGggdG8gdGhlIG
FjdGl2ZSBwaHAuaW5pDQo+ID4+IGZpbGUsIHNpbmNlIHNvbWV0aW1lcyB0aG lzIGNhbiBiZSBhbiB1
bmV4cGVjdGVkIGxvY2F0aW9uIG9uIFdpbmRvd3MNCj4gPj4gbWFjaGluZXMs IGF0IGxlYXN0IGluIG
15IGV4cGVyaWVuY2UuDQo+ID4+DQo+ID4+IFJlZ2FyZHMsDQo+ID4+IENhcm x0b24gV2hpdGVoZWFk
DQo+ID4+DQo+ID4+IC0tLS0tIE9yaWdpbmFsIE1lc3NhZ2UgLS0tLS0NCj4g Pj4gRnJvbTogIktNIi
A8dGhhbG9yQGNvbWNhc3QubmV0Pg0KPiA+PiBUbzogcGhwLXdpbmRvd3NAbG lzdHMucGhwLm5ldA0K
PiA+PiBTZW50OiBNb25kYXksIEF1Z3VzdCA2LCAyMDA3IDQ6NTg6MzYgUE0g KEdNVC0wNTAwKSBBbW
VyaWNhL05ld19Zb3JrDQo+ID4+IFN1YmplY3Q6IFtQSFAtV0lOXSBQSFAsIE 1ZU1FMIGFuZCBBcGFj
aGUNCj4gPj4NCj4gPj4gSSBhbSBhdHRlbXB0aW5nIHRvIHVzZSB0aGUgZm9s bG93aW5nIHRvZ2V0aG
Vy4oCmLg0KPiA+Pg0KPiA+Pg0KPiA+Pg0KPiA+PiBNWVNRTCA1LjANCj4gPj 4NCj4gPj4gQXBhY2hl
IDIuMi40DQo+ID4+DQo+ID4+IFBIUCA1LjIuMw0KPiA+Pg0KPiA+Pg0KPiA+ Pg0KPiA+PiBQSFAgaW
5mbyBJIGNhbiBnZXQuICBJIGdldCB0aGUgZm9sbG93aW5nIHN0YXRlbWVudC B3aGVuZXZlciB0cnlp
bmcgdG8NCj4gPj4gZ2V0IHRvDQo+ID4+IG15c3FsDQo+ID4+DQo+ID4+DQo+ ID4+DQo+ID4+DQo+ID
4+DQo+ID4+IEhlcmUgaXMgdGhlIFBIUCBjb2RlIGZvciB3aGF0IEnigJltIH RyeWluZyB0byBkb+KA
pg0KPiA+Pg0KPiA+Pg0KPiA+Pg0KPiA+PiA8P3BocA0KPiA+Pg0KPiA+PiAg Ly8gQ29ubmVjdCB0by
B0aGUgZGF0YWJhc2UNCj4gPj4NCj4gPj4gICRkYmhvc3QgPSAnbG9jYWxob3 N0JzsNCj4gPj4NCj4g
Pj4gICRkYnVzZXJuYW1lID0gJ3Jvb3QnOw0KPiA+Pg0KPiA+PiAgJGRicGFz c3dkID0gJ2pva2VyJz
sNCj4gPj4NCj4gPj4gICRkYXRhYmFzZV9uYW1lID0gJ3NpbXBsZSc7DQo+ID 4+DQo+ID4+ICAkY29u
bmVjdGlvbiA9IG15c3FsX2Nvbm5lY3QoIiRkYmhvc3QiLCIkZGJ1c2VybmFt ZSIsIiRkYnBhc3N3ZC
IpDQo+ID4+DQo+ID4+ICAgb3IgZGllICgnQ291bGRuXCd0IGNvbm5lY3QgdG 8gc2VydmVyLicpOw0K
PiA+Pg0KPiA+PiAgJGRiID0gbXlzcWxfc2VsZWN0X2RiKCIkZGF0YWJhc2Vf bmFtZSIsICRjb25uZW
N0aW9uKQ0KPiA+Pg0KPiA+PiAgIG9yIGRpZSgnQ291bGRuXCd0IHNlbGVjdC BkYXRhYmFzZS4nKTsN
Cj4gPj4NCj4gPj4NCj4gPj4NCj4gPj4gIC8vIEdlbmVyYXRlIFNRTCBjb2Rl IHRvIHN0b3JlIGRhdG
Egb24gZGF0YWJhc2UuDQo+ID4+DQo+ID4+ICAkaW5zZXJ0X3NxbCA9ICdJTl NFUlQgSU5UTyBzaW1w
bGVfdGFibGUgKHRleHQpIFZBTFVFUyAoXCd0ZXN0IHRleHQsDQo+ID4+IDEs MiwzXCcpJzsNCj4gPj
4NCj4gPj4NCj4gPj4NCj4gPj4gIC8vIEV4ZWN1dGUgU1FMIGNvZGUuDQo+ID 4+DQo+ID4+ICBteXNx
bF9xdWVyeSggJGluc2VydF9zcWwgKQ0KPiA+Pg0KPiA+PiAgIG9yIGRpZSAo ICdJdCBEaWRuXOKAmX
QgV29yazogJyAuIG15c3FsX2Vycm9yKCkgKTsNCj4gPj4NCj4gPj4NCj4gPj 4NCj4gPj4gIC8vIFRl
bGwgVXNlciB3ZSBhcmUgZG9uZS4NCj4gPj4NCj4gPj4gIGVjaG8gJ0NvZGUg SW5zZXJ0ZWQnOw0KPi
A+Pg0KPiA+PiA/Pg0KPiA+Pg0KPiA+Pg0KPiA+Pg0KPiA+Pg0KPiA+Pg0KPi A+PiBGYXRhbCBlcnJv
cjogQ2FsbCB0byB1bmRlZmluZWQgZnVuY3Rpb24gbXlzcWxfY29ubmVjdCgp IGluIEM6XFByb2dyYW
0NCj4gPj4gRmlsZXNcQXBhY2hlIFNvZnR3YXJlIEZvdW5kYXRpb25cQXBhY2 hlMi4yXGh0ZG9jc1x0
ZXN0X2luc2VydF9teXNxbC5waHANCj4gPj4gb24NCj4gPj4gbGluZSA3DQo+ ID4+DQo+ID4+DQo+ID
4+DQo+ID4+IEFueW9uZSBoYWQgdGhpcyBiZWZvcmUgYW5kIGhhdmUgYSBzb2 x1dGlvbiwgaXQgd291
bGQgYmUgYXBwcmVjaWF0ZWQuDQo+ID4+DQo+ID4+DQo+ID4+DQo+ID4+IEtl aXRoDQo+ID4+DQo+ID
4+DQo+ID4+IE5vIHZpcnVzIGZvdW5kIGluIHRoaXMgb3V0Z29pbmcgbWVzc2 FnZS4NCj4gPj4gQ2hl
Y2tlZCBieSBBVkcgRnJlZSBFZGl0aW9uLg0KPiA+PiBWZXJzaW9uOiA3LjUu NDc2IC8gVmlydXMgRG
F0YWJhc2U6IDI2OS4xMS42LzkzOCAtIFJlbGVhc2UgRGF0ZTogOC81LzIwMD cNCj4gPj4gNDoxNiBQ
TQ0KPiA+Pg0KPiA+Pg0KPiA+PiBObyB2aXJ1cyBmb3VuZCBpbiB0aGlzIGlu Y29taW5nIG1lc3NhZ2
UuDQo+ID4+IENoZWNrZWQgYnkgQVZHIEZyZWUgRWRpdGlvbi4NCj4gPj4gVm Vyc2lvbjogNy41LjQ3
NiAvIFZpcnVzIERhdGFiYXNlOiAyNjkuMTEuNi85MzggLSBSZWxlYXNlIERh dGU6IDgvNS8yMDA3DQ
o+ID4+IDQ6MTYgUE0NCj4gPj4NCj4gPj4NCj4gPj4gTm8gdmlydXMgZm91bm QgaW4gdGhpcyBvdXRn
b2luZyBtZXNzYWdlLg0KPiA+PiBDaGVja2VkIGJ5IEFWRyBGcmVlIEVkaXRp b24uDQo+ID4+IFZlcn
Npb246IDcuNS40NzYgLyBWaXJ1cyBEYXRhYmFzZTogMjY5LjExLjYvOTM4IC 0gUmVsZWFzZSBEYXRl
OiA4LzUvMjAwNw0KPiA+PiA0OjE2IFBNDQo+ID4+DQo+ID4+DQo+ID4NCj4g PiAtLQ0KPiA+IFBIUC
BXaW5kb3dzIE1haWxpbmcgTGlzdCAoaHR0cDovL3d3dy5waHAubmV0LykNCj 4gPiBUbyB1bnN1YnNj
cmliZSwgdmlzaXQ6IGh0dHA6Ly93d3cucGhwLm5ldC91bnN1Yi5waHANCj4g Pg0KPiA+IE5vIHZpcn
VzIGZvdW5kIGluIHRoaXMgaW5jb21pbmcgbWVzc2FnZS4NCj4gPiBDaGVja2 VkIGJ5IEFWRyBGcmVl
IEVkaXRpb24uDQo+ID4gVmVyc2lvbjogNy41LjQ3NiAvIFZpcnVzIERhdGFi YXNlOiAyNjkuMTEuNi
85MzggLSBSZWxlYXNlIERhdGU6IDgvNS8yMDA3DQo+ID4gNDoxNiBQTQ0KPi A+DQo+ID4NCj4gPiBO
byB2aXJ1cyBmb3VuZCBpbiB0aGlzIG91dGdvaW5nIG1lc3NhZ2UuDQo+ID4g Q2hlY2tlZCBieSBBVk
cgRnJlZSBFZGl0aW9uLg0KPiA+IFZlcnNpb246IDcuNS40NzYgLyBWaXJ1cy BEYXRhYmFzZTogMjY5
LjExLjYvOTM4IC0gUmVsZWFzZSBEYXRlOiA4LzUvMjAwNw0KPiA+IDQ6MTYg UE0NCj4gPg0KPiA+DQ
o+ID4gLS0NCj4gPiBQSFAgV2luZG93cyBNYWlsaW5nIExpc3QgKGh0dHA6Ly 93d3cucGhwLm5ldC8p
DQo+ID4gVG8gdW5zdWJzY3JpYmUsIHZpc2l0OiBodHRwOi8vd3d3LnBocC5u ZXQvdW5zdWIucGhwDQ
o+ID4NCj4gPg0KPiANCj4g

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"
>> 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.
>>
>>
>>
>> >>
>> // 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

Re: 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
To: KM
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"
> >> 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.
> >>
> >>
> >>
> >> > >>
> >> // 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

Re: 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"
To: "Thomas Hearn"
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
To: KM
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"
> >> 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.
> >>
> >>
> >>
> >> > >>
> >> // 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

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
To: thalor@comcast.net
Cc: bitslayer@comcast.net, php-windows@lists.php.net, Thomas Hearn

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"
> To: "Thomas Hearn"
> 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
> To: KM
> 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"
> > >> 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.
> > >>
> > >>
> > >>
> > >> > > >>
> > >> // 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
>
>

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

Re: PHP, MYSQL and Apache

KM,
Check this out:
http://forums.mysql.com/read.php?52,98383,98383
It may help you.
Regards
Abhisek


KM wrote:
> 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…
>
>
>
> >
> // 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
>
>
>

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