Building Dynamic Web Sites with MySQLi

Linux    |    Intermediate
  • 13 Videos | 1h 23m 42s
  • Earns a Badge
Likes 31 Likes 31
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 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

IN THIS COURSE

  • Playable
    1. 
    Comparing MySQLi and PDO
    4m 26s
    UP NEXT
  • Playable
    2. 
    Installing and Configuring MySQLi
    4m 22s
  • Locked
    3. 
    Using Persistent Connections with MySQLi
    4m 56s
  • Locked
    4. 
    Using Prepared Statement with MySQLi
    6m 34s
  • Locked
    5. 
    Using Stored Procedures with MySQLi
    5m 35s
  • Locked
    6. 
    Executing Multiple Statements with MySQLi
    6m
  • Locked
    7. 
    Creating Transactions by Using MySQLi
    6m 19s
  • Locked
    8. 
    Creating Databases and Tables by Using MySQLi
    3m 27s
  • Locked
    9. 
    Inserting Data into a Database by Using MySQLi
    6m 37s
  • Locked
    10. 
    Retrieving Data from Database by Using MySQLi
    5m 21s
  • Locked
    11. 
    Updating Data by Using MySQLi
    10m 17s
  • Locked
    12. 
    Deleting Data by Using MySQLi
    6m 6s
  • Locked
    13. 
    Exercise: Connect MySQL with PHP by Using MySQLi
    9m 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.

YOU MIGHT ALSO LIKE