Course Details

Previous Page


Building Dynamic Web Sites with MySQL and PHP


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



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