Class 8 – More information about databases

Here are some posts that attempt to elucidate the concepts behind working with databases.

Intro to Relational Databases – the concepts behind databases, tables, rows, and fields

Administering MySQL using phpMyAdmin – another post explaining how to use phpMyAdmin to manage your tables

Select Statements in MySQL – reading data from databases can be more sophisticated than simply pulling all the data from a specific table.  This post explains some of the finer techniques of reading from a table.

Debugging PHP and MySQL - some tips on how to figure out where any errors are coming from

Making Timestamps User-Friendly – the “created” field in all of our tables in the database stores the date a row was entered into the table.  This post explains how to output those dates in a user-friendly way.

Pagination in PHP – when you pull lots of data from the database, you often will not want to display it all on one page.  This post explains the concepts behind breaking up the set of results onto multiple pages.   It’s a little advanced at this point, but if you’re brave…

Related posts:

1. Class 8 – Intro to Relational Databases