Building Dynamic Web Sites with MySQLi

Linux
  • 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
    FREE ACCESS
  • Locked
    4. 
    Using Prepared Statement with MySQLi
    6m 34s
    FREE ACCESS
  • Locked
    5. 
    Using Stored Procedures with MySQLi
    5m 35s
    FREE ACCESS
  • Locked
    6. 
    Executing Multiple Statements with MySQLi
    6m
    FREE ACCESS
  • Locked
    7. 
    Creating Transactions by Using MySQLi
    6m 19s
    FREE ACCESS
  • Locked
    8. 
    Creating Databases and Tables by Using MySQLi
    3m 27s
    FREE ACCESS
  • Locked
    9. 
    Inserting Data into a Database by Using MySQLi
    6m 37s
    FREE ACCESS
  • Locked
    10. 
    Retrieving Data from Database by Using MySQLi
    5m 21s
    FREE ACCESS
  • Locked
    11. 
    Updating Data by Using MySQLi
    10m 17s
    FREE ACCESS
  • Locked
    12. 
    Deleting Data by Using MySQLi
    6m 6s
    FREE ACCESS
  • Locked
    13. 
    Exercise: Connect MySQL with PHP by Using MySQLi
    9m 43s
    FREE ACCESS

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

COURSE Stored Routines, Triggers, & the InnoDB memcached Plugin
Likes 11 Likes 11  
CHANNEL MySQL
Likes 194 Likes 194  
COURSE SQL Programming with MariaDB: Getting Started with MariaDB for Data Analysis
Likes 3 Likes 3