MySQLi For Beginners Online Course

MySQLi For Beginners Online Courses in Tanzania


Learn MySQLi online like an expert. 2KO Africa conducts hands-on computer courses on most of the major IT Platforms, and has a sizeable range of online IT courses which are available internationally over the Internet.



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





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




Prepared Statements for Inserting

Selecting Prepared Statements


Finishing Up

Freeing Results

Closing the Database Connection