First PHP/MySQL Project Day 1: Connecting to MySQL
This seven-minute video shows how I used PHP to connect to a MySQL database — well, after reading about some functions and getting familiar with phpMyAdmin.
My First PHP/MySQL Project
First PHP/MySQL Project Day 2: Inserting Data into MySQL
This six-minute video shows how I created a table and then inserted data from an HTML form into MySQL.
First PHP/MySQL Project Day 3: Displaying Data
A three-minute video on how to select and display data from MySQL.
First PHP/MySQL Project Day 4: Checkboxes and Deleting Rows
Eight-and-a-half-minute video. Today I learned how to delete rows from a table in MySQL using an HTML form with dynamically generated checkboxes. To do so, I had to learn about a bunch of stuff like primary keys and some new MySQL statements.
First PHP/MySQL Project Day 5: Date Functions, Updating Data, and More
This nine-minute video covers a lot. To add deadlines and recurring tasks to my to-do list, I had to learn about MySQL’s date functions, operators, null values, the UPDATE statement, and the CASE control flow function.
First PHP/MySQL Project Day 6: Joining Tables Together
For the last video in this series, I learned how to join two tables together with cross joins, inner joins, and outer joins. Exciting stuff here! (And I don’t mean that sarcastically. Learning about joins opens up a whole new world of database possibilities!) Anyway, this video is five and a half minutes long.
Subscribe
Get notified of every new tutorial as soon as it's posted! Subscribe via RSS or via email:
About this Series
These video tutorials explain some of the basics of MySQL and how to use it with PHP. I learned by making a simple to-do list program.