MySQLi for Beginners

$49.99

Start off this MySQLi for Beginners online course by connecting to a database and creating a database table. Then move on to pulling records, counting results, and preparing statements. Finish up by closing out of the database connection. By the time you're done, you'll be well-versed in MySQLi best practices and security considerations.

Length: 1.5 hrs

This title is available in the
Total Training All-Access library.

Subscribe Now

Description

This MySQLi for Beginners training 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.

Sample clip

CHAPTER 1: INTRODUCTION
Introduction

CHAPTER 2: GETTING STARTED WITH MYSQLI
Connecting To A Database
Connecting Using PHP
Creating a Database Table

CHAPTER 3: FETCHING RESULTS
Pulling Single Records
Pulling Multiple Records
Different Result Types

CHAPTER 4: GETTING RESULTS
Counting Results
Updating and Seeing Affected Rows

CHAPTER 5: SECURITY
Escaping
Prepared Statements for Inserting
Selecting Prepared Statements

CHAPTER 6: FINISHING UP
Freeing Results
Closing the Database Connection

Alex Garrett is a UK-based developer. His experience includes software engineering and web architecture, as well as authoring “The PHP Project Guide”. Alex enjoys teaching Laravel, PHP, MySQL, jQuery, and other coding topics through his online courses.

You may also like…