Building Dynamic Web Sites with MySQL and PHP

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

Prerequisite
None

Expected Duration
165 minutes

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.

Objective

MySQL Improved Extension

  • 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

Managing MySQL Data by Using 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

Practice: Using MySQLi to Manage Data

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

Working with PHP Data Objects

  • 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

Managing Data by Using 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

Practice: Using PDO to Manage Data

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.