Building Dynamic Web Sites with MySQLi
Linux
| Intermediate
- 13 Videos | 1h 19m 42s
- Earns a Badge
Dynamic web sites are in high demand and can be created using PHP and MySQL. Learn how to connect PHP with MySQL by using MySQLi, and how to work with data in MySQL using PHP.
WHAT YOU WILL LEARN
-
compare different methods to connect MySQL with PHPinstall and configure MySQLiuse persistent connections with MySQLiuse prepared statement with MySQLiuse stored procedure with MySQLiuse multiple statements with MySQLicreate transactions with MySQLi
-
create database and tables by using MySQLiinsert data into database by using MySQLiretrieve data from database by using MySQLiupdate data by using MySQLidelete data by using MySQLiinsert, update, delete, and retrieve data by using MySQLi
IN THIS COURSE
-
1.Comparing MySQLi and PDO4m 26sUP NEXT
-
2.Installing and Configuring MySQLi4m 22s
-
3.Using Persistent Connections with MySQLi4m 56s
-
4.Using Prepared Statement with MySQLi6m 34s
-
5.Using Stored Procedures with MySQLi5m 35s
-
6.Executing Multiple Statements with MySQLi6m
-
7.Creating Transactions by Using MySQLi6m 19s
-
8.Creating Databases and Tables by Using MySQLi3m 27s
-
9.Inserting Data into a Database by Using MySQLi6m 37s
-
10.Retrieving Data from Database by Using MySQLi5m 21s
-
11.Updating Data by Using MySQLi10m 17s
-
12.Deleting Data by Using MySQLi6m 6s
-
13.Exercise: Connect MySQL with PHP by Using MySQLi9m 43s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.