Overview/Description
Dynamic web sites are highly in demand and are created by using PHP and MySQL. In this course, you will learn to connect PHP with MySQL by using MySQLi and PDO. You will also learn to create, retrieve, update, and delete data in MySQL by using PHP, and display the result on a web page.

Target Audience
This course is targeted toward individuals who wish to create LAMP stacks and use them in Web development.

Prerequisites
None

Expected Duration (hours)
2.8

Lesson Objectives

Building Dynamic Web Sites with MySQL and PHP

start the course

compare different methods to connect MySQL with PHP

install and configure MySQLi

use persistent connections with MySQLi

use prepared statement with MySQLi

use stored procedure with MySQLi

use multiple statements with MySQLi

create transactions with MySQLi

create database and tables by using MySQLi

insert data into database by using MySQLi

retrieve data from database by using MySQLi

update data by using MySQLi

delete data by using MySQLi

insert, update, delete, and retrieve data by using MySQLi

install and configure PDO

create connections by using PDO

create transactions and autocommit by using PDO

use prepared statements with PDO

use stored procedure with PDO

use error handling with PDO

create database and tables in MySQL by using PDO

insert data into database by using PDO

retrieve data from database by using PDO

update data by using PDO

delete data by using PDO

insert, update, delete, and retrieve data by using PDO

Course Number:
wd_lamp_a02_it_enus

Expertise Level
Intermediate