Building Dynamic Web Sites with PDO

Linux    |    Intermediate
  • 12 videos | 1h 16m 7s
  • Earns a Badge
Rating 4.5 of 20 users Rating 4.5 of 20 users (20)
PHP Data Objects (PDO) is an API available for accessing MySQL databases in PHP. Let's look at how to install, configure, and work with PDO, and how to manage data by connecting MySQL with PHP using PDO.

WHAT YOU WILL LEARN

  • 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
  • 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
    Insert, update, delete, and retrieve data by using pdo

IN THIS COURSE

  • 2m 43s
    In this video, you will learn how to install and configure PDO. FREE ACCESS
  • 2m 1s
    In this video, you will learn how to create connections using PDO. FREE ACCESS
  • Locked
    3.  Creating Transactions and Autocommit by Using PDO
    4m 50s
    In this video, you will create transactions and autocommit by using PDO. FREE ACCESS
  • Locked
    4.  Using Prepared Statements with PDO
    5m 14s
    Learn how to use prepared statements with PDO. FREE ACCESS
  • Locked
    5.  Using Stored Procedures with PDO
    4m 39s
    In this video, learn how to use stored procedures with PDO. FREE ACCESS
  • Locked
    6.  Handling Errors by Using PDO
    6m 14s
    In this video, you will learn how to use error handling with PDO. FREE ACCESS
  • Locked
    7.  Creating Database and Tables by Using PDO
    5m 20s
    In this video, you will create a database and tables in MySQL by using PDO. FREE ACCESS
  • Locked
    8.  Inserting Data into a Database by Using PDO
    10m 15s
    In this video, find out how to insert data into a database by using PDO. FREE ACCESS
  • Locked
    9.  Retrieving Data from Database by Using PDO
    7m 2s
    Find out how to retrieve data from a database by using PDO. FREE ACCESS
  • Locked
    10.  Updating Data by Using PDO
    10m 56s
    In this video, learn how to update data by using PDO. FREE ACCESS
  • Locked
    11.  Deleting Data by Using PDO
    6m 49s
    In this video, you will learn how to delete data by using PDO. FREE ACCESS
  • Locked
    12.  Exercise: Connect MySQL with PHP by Using PDO
    10m 5s
    Learn how to insert, update, delete, and retrieve data using PDO. 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.