MySQLi For Beginners Online Course

MySQLi For Beginners Online Courses in South Africa

 

Learn MySQLi online like an expert. 2KO Africa is a network of companies that offers a substantial series of computer courses across the entire African region, and is a leading provider of internationally recognised online IT training, online, IT training from the comfort of home or work.

 

Benefits of MySQLi

An object-oriented interface

Support for prepared statements

Support for multiple statements

Support for transactions

Enhanced debugging support

Embedded server support

 

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. A knowledge of PHP and MySQL is recommended for this course.

 

Class Curriculum

 

Introduction

Introduction

 

Getting Started with MySQLi

Connecting To A Database

Connecting Using PHP

Creating a Database Table

 

Fetching Results

Pulling Single Records

Pulling Multiple Records

Different Result Types

 

Getting Results

Counting Results

Updating and Seeing Affected Rows

 

Security

Escaping

Prepared Statements for Inserting

Selecting Prepared Statements

 

Finishing Up

Freeing Results

Closing the Database Connection