Description
Stone River Elearning – MySQLi For Beginners
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 ed 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)
Sale Page: https://stoneriverelearning.com/p/php-and-mysqli
Archive: https://archive.ph/zLPKU
Reviews
There are no reviews yet.