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 environment to use the MySQLi module; opening connection to MySQL server; running SQL queries; looping through result set.

MySQLi Module and Configuration

mysqli-hello.php - Test MySQLi Module

mysqli_connect() - Open MySQL Connection

mysqli_query() - Run SQL Queries

mysqli_affected_rows() - Count Affected Rows

mysqli_insert_id() - ID from AUTO_INCREMENT

mysqli_fetch_array() - Fetch Row from Query Result

mysqli_fetch_fields() - Fetch Field Information

Escape Escape Characters - \\\\ for \\

Summary of Basic MySQLi Functions

MySQLi Object-Oriented Programming

Takeaways:

• MySQLi module allows you to access MySQL database server.
• Loading MySQLi may require "extension" setting in php.ini.
• mysqli_connect() opens a connection to the MySQL server.
• mysqli_query() runs a MySQL query.
• mysqli_fetch_array() fetches the next row from query result.
• MySQLi module supports object-oriented programming paradigm.

Table of Contents

 About This Book

 Introduction and Installation of PHP

 Managing PHP Environment and Modules on macOS

 Managing PHP Environment and Modules on CentOS

 Configuration and Modules

 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

 Index

 Full Version in PDF/EPUB

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