MySQLi For Beginners – Stone River Elearning
Best practices and security considerations
The course teaches MySQLi, a way to connect to databases within PHP. It covers connecting to the database, and using all the features required to build fast, scalable applications that use a database connection. It covers essential concepts like security, and best practices with using the data retrieved from the database.
Benefits of MySQLi
An object-oriented interface
Support for prepared statements
Support for multiple statements
Support for transactions
Enhanced debugging support
Embedded server support
A knowledge of PHP and MySQL is recommended for this course.
Course Curriculum
Introduction
Introduction (5:21)
Getting started with MySQLi
Connecting To A Database (7:55)
Connecting Using PHP (9:44)
Creating a Database Table (3:38)
Fetching Results
Pulling Single Records (4:45)
Pulling Multiple Records (9:11)
Different Result Types (5:26)
Getting Results
Counting Results (9:25)
Updating and Seeing Affected Rows (4:46)
Security
Escaping (12:33)
Prepared Statements for Inserting (8:14)
Selecting Prepared Statements (5:42)
Finishing Up
Freeing Results (2:48)
Closing the Database Connection (2:15)
