PHP, PDO, MySQL, and phpMyAdmin for Beginners | Coding Academy | Skillshare

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 Lessons (2h 34m)
    • 1. Introduction

      1:20
    • 2. How to create a database in phpMyAdmin

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

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

      8:37
    • 5. TASK 1: Creating the Teacher Table

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

      2:47
    • 7. How to update records in phpMyAdmin

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

      7:46
    • 9. How to use a try catch block

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

      6:43
    • 11. How to retrieve database records using PHP

      7:20
    • 12. How to update database records using PHP

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

      3:02
    • 14. TASK 2: The Book Store

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

      8:08
    • 16. How to integrate PHP and HTML

      12:04
    • 17. Adding an edit icon

      5:33
    • 18. How to create the edit page

      3:31
    • 19. How to populate the edit page

      10:18
    • 20. How to use fetch

      4:59
    • 21. Error trapping

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

      12:15
    • 23. TASK 3: Deleting a Record

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

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

      1:12
    • 26. 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.

56

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Coding Academy

National Award-Winning Teacher

Report class