Programming Archives

A short slideshow explaining the parts that make up an (X)HTML Document, which is basically the skeleton of every web page you see on the internet.

This slideshow covers the general syntax rules for writing (X)HTML: the anatomy of a tag, nesting elements, empty tags, and attributes.

Whether you want to be a web designer or a well-rounded blogger, you need to know the basics of (X)HTML and CSS. They work hand in hand, so I figured I’d make one series of posts that teaches both of them together. This first post will just cover some definitions and background info. At the end, there’s also a slideshow on how to make, view, and edit HTML and CSS files.

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.

I’ve dabbled in CSS for a while now, but I never bothered to read up on the different units of measurement. I’m only familiar with pixels, ems, and percentages, but it turns out that CSS actually has eight units of measurement. They’re divided into relative and absolute length units.

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.