MySQLi For Beginners Online Course

MySQLi For Beginners Online Courses in Senegal

 

Learn MySQLi online like an expert. 2KO International offers services, consulting and training in both the business and IT space. Our training can be delivered either as full-time classes or as online e-learning.

 

 

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