PHP Modules Tutorials - Herong's Tutorial Examples

∟MySQLi Module - Accessing MySQL Server

This chapter provides tutorial examples and notes about MySQLi module for MySQL server. Topics include configuring the PHP engine to use the MySQL extension library, commonly used MySQL functions, running SQL statements to create table, insert rows and fetch rows.

MySQLi Module Configuration and Database Access

mysqli_connect() and Other MySQL Functions

MySqlLoop.php - MySQL Functions Test

Takeaways:

• PHP supports MySQL server through MySQLi module.
• Configuring the PHP engine to work with a MySQL server is simple - just turn on the extension=php_mysqli.dll setting in php.ini.
• A database connection resource must be created with the mysqli_connect() function.
• You can execute any SQL statements using the mysqli_query() function.
• php_mysql.dll was removed as of PHP 7.0.0 and replaced by php_mysqli.dll.

Table of Contents

 About This Book

 Introduction and Installation of PHP

 Managing PHP Engine and Modules on macOS

 Managing PHP Engine and Modules on CentOS

 cURL Module - Client for URL

 DOM Module - Parsing HTML Documents

 GD Module - Manipulating Images and Pictures

►MySQLi Module - Accessing MySQL Server

 OpenSSL Module - Cryptography and SSL/TLS Toolkit

 PCRE Module - Perl Compatible Regular Expressions

 SOAP Module - Creating and Calling Web Services

 SOAP Module - Server Functions and Examples

 Zip Module - Managing ZIP Archive Files

 References

 Full Version in PDF/EPUB

MySQLi Module - Accessing MySQL Server - Updated in 2024, by Herong Yang