PHP Tutorials - Herong's Tutorial Examples - Version 4.17, by Dr. Herong Yang
Configuring PHP for MySQL Server Access
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:
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) 2015, HerongYang.com, All Rights Reserved. # $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.
Last update: 2015.
Table of Contents