PHP Tutorials - Herong's Tutorial Examples - v5.13, 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:
C:\herong> \mysql\bin\mysqld C:\herong> \mysql\bin\mysqladmin ping mysqld is alive
Note that php_mysql.dll was removed as of PHP 7.0.0 and replaced by php_mysqli.dll. So I need to edit \php\php.ini with:
# for PHP 7 extension=mysqli # for PHP 5 extension=php_mysqli.dll
Then I added \php\ext to the PATH system environment variable, because php_mysqli.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) HerongYang.com. All Rights Reserved. # $con = mysqli_connect('localhost'); print "MySQL server info = ".mysqli_get_server_info($con)."\n"; print "MySQL status = ".mysqli_stat($con)."\n"; mysqli_close($con); ?>
I got this output:
C:\herong> php MySqlTest.php MySQL server info = 5.6.28 MySQL status = Uptime: 1167 Threads: 1 Questions: 5 Slow queries... 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.
Table of Contents