PHP Tutorials - Herong's Tutorial Examples - v5.17, by Herong Yang
Archived: Configuration for php_mysql.dll Library
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
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 2009 (c) 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:
herong> php MySqlTest.php MySQL server info = 5.0.2-alpha 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
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
Managing PHP Engine and Modules on CentOS
Archived: Downloading and Installing PHP 7.0 for Windows
Archived: Downloading and Installing PHP 5.6.6 for Windows
Archived: Downloading and Installing PHP 5.4.3 for Windows
Archived: Downloading and Installing PHP 5.2.2 for Windows
Archived: Downloading and Installing PHP 5.0.4 for Windows
Archived: Adding PHP to IIS as CGI
Archived: Downloading Apache HTTP Server 2.4.12 for Windows
Archived: Installing Apache HTTP Server 2.4.12 on Windows
Archived: Publishing PHP Scripts as Web Pages
►Archived: Configuration for php_mysql.dll Library
Archived: mysql_connect() using php_mysql.dll Library
Archived: MySqlLoop.php using php_mysql.dll Library
Archived: Get_Temperature.php - First Example of SOAP
Archived: Get_Temperature_Dump.php - Dumping Debugging Information