Collections     Sysadmin & DevOps Collection     Web Application Frameworks     Building Dynamic Web Sites with LAMP Stack

---

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.

---

---

Objectives

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