PHP, PDO, MySQL, and phpMyAdmin for Beginners

Coding Academy, National Award-Winning Teacher

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
26 Videos (2h 34m)
    • Introduction

      1:20
    • How to create a database in phpMyAdmin

      7:56
    • How to retrieve data from a database table

      8:55
    • How to crate a database table in phpMyAdmin

      8:37
    • TASK 1: Creating the Teacher Table

      0:48
    • TASK 1: Creating the Teacher Table - SOLUTION

      2:47
    • How to update records in phpMyAdmin

      4:04
    • How to make a PDO connection to the a MySQL database

      7:46
    • How to use a try catch block

      3:22
    • How to create a database record using PHP

      6:43
    • How to retrieve database records using PHP

      7:20
    • How to update database records using PHP

      5:05
    • How to delete a database record using PHP

      3:02
    • TASK 2: The Book Store

      3:24
    • TASK 2: The Book Store - SOLUTION

      8:08
    • How to integrate PHP and HTML

      12:04
    • Adding an edit icon

      5:33
    • How to create the edit page

      3:31
    • How to populate the edit page

      10:18
    • How to use fetch

      4:59
    • Error trapping

      6:28
    • How to update a database record via a HTML form

      12:15
    • TASK 3: Deleting a Record

      1:15
    • TASK 3: Deleting a Record - SOLUTION

      10:14
    • TASK 4: Creating the form and script to INSERT a record

      1:12
    • TASK 4: Creating the form and script to INSERT a record - SOLUTION

      6:35

About This Class

In this course you will learn how to use PHP, PDO, MySQL and phpMyAdmin to create, read, update, and delete records in a database.

You will learn how to:

  • create a database using phpMyAdmin
  • upload a SQL dump
  • create a database table using a SQL dump
  • populate a database table using a SQL dump
  • create a table using a CSV file
  • populate a database table using a CSV file
  • CRUD
  • create, retrieve, upload and delete records using phpMyAdmin
  • create, retrieve, upload and delete records using PHP
  • create a HTML formĀ 
  • use Bootstrap to style your form
  • use Font Awesome icons
  • use a HTML form to edit a record
  • set user permissions

If you are a beginner to using MySQL then this is the course for you.

I will guide you through the basic steps involved in securely creating a connection to a MySQL database.

2

Students

--

Projects

Coding Academy

National Award-Winning Teacher