This section provides a tutorial example on how to configure the PHP engine for MySQL server connection access. Setting, extension=php_mysql.dll, needs to be turned in the configuration file php.ini.
To use PHP with MySQL servers, of course you need to install a MySQL server on you system first.
On my local system, I have a MySQL server installed in \mysql directory. If you need
help on installing a MySQL server on your system, please read my other tutorial book, "Herong's Notes on SQL".
To make sure my MySQL server is running on my local system, I executed commands below to start
my MySQL server and check its status:
>\mysql\bin\mysqld
>\mysql\bin\mysqladmin ping
mysqld is alive
Now edit \php\php.ini with:
extension=php_mysql.dll
Then I added \php\ext to the PATH system environment variable, because php_mysql.dll is located in the \php\ext directory.
When I was ready to test the configuration, I ran this script:
<?php # MySqlTest.php
# Copyright (c) 2002 by Dr. Herong Yang, http://www.herongyang.com/
#
$con = mysql_connect('localhost');
print "MySQL server info = ".mysql_get_server_info()."\n";
print "MySQL status = ".mysql_stat()."\n";
mysql_close($con);
?>
I got this output:
C:\herong\php_20050403\src>php MySqlTest.php
MySQL server info = 5.0.2-alpha
MySQL status = Uptime: 1167 Threads: 1 Questions: 5 Slow querie...
Flush tables: 1 Open tables: 0 Queries per second avg: 0.004
Cool, this confirmed that my PHP engine configured to access my MySQL server.
