Video Archives

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.

Read more »

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.

Read more »

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.

Read more »

First PHP/MySQL Project Day 3: Displaying Data

A three-minute video on how to select and display data from MySQL.

Read more »

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.

Read more »

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.

Read more »

Drawing Day 7: Bubbles Part 2

Two-and-a-half-minute video. Today I finished my drawing of Bubbles from the Powerpuff Girls, and it’s my best drawing yet!

Read more »

Drawing Day 6: Bubbles Part 1

Two-minute video. To practice drawing accurate proportions, I drew Bubbles from the Powerpuff Girls. As you’ll see in the introduction, I’ve always loved Bubbles — maybe a little too much!

Read more »

PHP Day 15: Sessions

I didn’t know what a session was until a couple days ago, so this video shares what I’ve learned so far. It’s a short introduction, three and a half minutes long.

Read more »

PHP Day 14: Cookies

Today I learned just the basic basics of using cookies with PHP. So, this four-minute video is just an introduction.

Read more »