MySQLi For Beginners – Stone River Elearning

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)