{{ variable.name }}
Introduction: This course explains the specific usage and precautions of MySQLi from both object-oriented and procedural perspectives. Finally, through practical exercises of the no-refresh comment system, it elaborately analyzes how to use MySQLi to operate the database in actual development.
Chapter 1: Installation and Download of MySQLi
Understand the MySQLi extension in PHP and its advantages over MySQL, and master how to enable the MySQLi extension
1-1 MySQLi Extended Advantages and Introduction
1-2 Installation and Configuration of MySQLi Extensions
Course Introduction 1-3
Chapter 2 Object-Oriented Programming in MySQLi (Part One)
This paper introduces the common methods and properties in MySQLi object-oriented programming, implements the addition, deletion, modification and query of the database, as well as the use of preprocessing statements and transactions
2-1 MySQLi Uses parsing
2-2 MySQLi implements record insertion operations
2-3 MySQLi implements record insertion operations
2-4 MySQLi implements record deletion operations
2-5 MySQLi implements query record operations
Case 2-6 - Implementing User List
2-7 User Management - Adding Users
2-8 User Management - Deleting Users
2-9 User Management - Editing Users
Chapter 3 Object-Oriented Programming in MySQLi (Part Two)
This paper introduces the common methods and properties in MySQLi object-oriented programming, implements the addition, deletion, modification and query of the database, as well as the use of preprocessing statements and transactions.
3-1 MySQLi's execution of Multiple SQL statements
3-2 In MySQLi, insert operations are performed using preprocessing statements
3-3 In MySQLi, preprocessing statements are used to prevent SQL injection
3-4 In MySQLi, query operations are executed using preprocessing statements
3-5 Transaction Processing in MySQLi
Chapter 4: Implementing a No-Refresh Comment System Based on MySQLi
MySQLi Object-Oriented Practice: Implementing a no-Refresh Comment System
4-1 Comment on the system effect demonstration
4-2 Form Input filtering
4-3 Form Data Processing
4-4 No refresh display of comment content
Chapter 5 MySQLi: Procedural Programming
MySQLi is based on the commonly used content in procedural programming
5-1 MySQLi Process-oriented Instance Demonstration: Adding Data
5-2 MySQLi Procedural Instance Demonstration: Updating and Deleting Data
5-3 MySQLi Procedural Instance Demonstration for Querying Data