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

 About This Book

 Introduction and Installation of PHP

 PHP Script File Syntax

 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

 Arrays - Ordered Maps

 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

 Managing File Upload

 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

 Image and Picture Processing

 Managing ZIP Archive Files

 Managing PHP Engine and Modules on macOS

 Managing PHP Engine and Modules on CentOS

Archived Tutorials

 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

 Archived: MySqlUnicode.php using php_mysql.dll Library

 References

 Full Version in PDF/EPUB