PHP Archives

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.

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.

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.

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

This six-minute video shows how I created a table and then inserted data from an HTML form into 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.

MySQL is an open source database management system. (Say that ten times fast!) Since it’s so popular and it works so well with PHP, I’d be crazy not to learn how to use it! So here’s what I’ve learned so far.

I’ve set my eye on the WordPress Custom Fields Contest from Technosailor. The deadline is March 30th, and the prize includes $200!

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.

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