Building Dynamic Web Sites with MySQLi

Linux    |    Intermediate
  • 13 videos | 1h 19m 42s
  • Earns a Badge
Rating 4.2 of 30 users Rating 4.2 of 30 users (30)
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

  • 4m 26s
    In this video, find out how to compare different methods of connecting MySQL with PHP. FREE ACCESS
  • 4m 22s
    In this video, you will learn how to install and configure MySQL. FREE ACCESS
  • Locked
    3.  Using Persistent Connections with MySQLi
    4m 56s
    In this video, you will learn how to use persistent connections with MySQL. FREE ACCESS
  • Locked
    4.  Using Prepared Statement with MySQLi
    6m 34s
    Find out how to use prepared statements with MySQLi. FREE ACCESS
  • Locked
    5.  Using Stored Procedures with MySQLi
    5m 35s
    Learn how to use stored procedures with MySQLi. FREE ACCESS
  • Locked
    6.  Executing Multiple Statements with MySQLi
    6m
    In this video, learn how to use multiple statements with MySQLi. FREE ACCESS
  • Locked
    7.  Creating Transactions by Using MySQLi
    6m 19s
    Find out how to create transactions with MySQL. FREE ACCESS
  • Locked
    8.  Creating Databases and Tables by Using MySQLi
    3m 27s
    In this video, you will create a database and tables by using MySQLi. FREE ACCESS
  • Locked
    9.  Inserting Data into a Database by Using MySQLi
    6m 37s
    In this video, you will learn how to insert data into a database by using MySQLi. FREE ACCESS
  • Locked
    10.  Retrieving Data from Database by Using MySQLi
    5m 21s
    In this video, find out how to retrieve data from a database by using MySQLi. FREE ACCESS
  • Locked
    11.  Updating Data by Using MySQLi
    10m 17s
    In this video, you will learn how to update data by using MySQL. FREE ACCESS
  • Locked
    12.  Deleting Data by Using MySQLi
    6m 6s
    In this video, you will learn how to delete data using MySQLi. FREE ACCESS
  • Locked
    13.  Exercise: Connect MySQL with PHP by Using MySQLi
    9m 43s
    In this video, you will learn how to insert, update, delete, and retrieve data by using MySQL. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
Book Getting Started with SQL and Databases: Managing and Manipulating Data with SQL
Book PHP 8 Solutions