PHP Tutorials - Herong's Tutorial Examples - v5.17, by 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:
herong> \mysql\bin\mysqld 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 2009-2015 (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:
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
Introduction and Installation of PHP
PHP Data Types and Data Literals
Variables, References, and Constants
Expressions, Operations and Type Conversions
Conditional Statements - "if" and "switch"
Loop Statements - "while", "for", and "do ... while"
Function Declaration, Arguments, and Return Values
Interface with Operating System
Introduction of Class and Object
Integrating PHP with Apache Web Server
Retrieving Information from HTTP Requests
Creating and Managing Sessions in PHP Scripts
Sending and Receiving Cookies in PHP Scripts
Controlling HTTP Response Header Lines in PHP Scripts
►MySQL Server Connection and Access Functions
►Configuring PHP for MySQL Server Access
mysqli_connect() and Other MySQL Functions
MySqlLoop.php - MySQL Functions Test
Functions to Manage Directories, Files and Images
SOAP Extension Function and Calling Web Services
SOAP Server Functions and Examples
Localization Overview of Web Applications
Using Non-ASCII Characters in HTML Documents
Using Non-ASCII Characters as PHP Script String Literals
Receiving Non-ASCII Characters from Input Forms
"mbstring" Extension and Non-ASCII Encoding Management
Managing Non-ASCII Character Strings with MySQL Servers
Parsing and Managing HTML Documents
Configuring and Sending Out Emails
Managing PHP Engine and Modules on macOS