Simple Table #5 – jQuery

This is the final chapter of the Simple Table tutorial. In this chapter we’ll be adding a few visual flourishes to the application using jQuery. We’ll be adding a client-side data filter, a pagination control, dynamic table sizing, and more.

Continue reading

Advertisements

Simple Table #4 – CSS

This is part 4 of the Simple Table tutorial. In this chapter we’ll be styling the application using CSS. If you’ll be following along, I strongly suggest watching the original videos hosted on vimeo as the video is being downsampled when played directly from wordpress. To get to the original videos simply click on the word “Vimeo” in the bottom right hand corner of each clip.

Continue reading

Simple Table #3 – HTML

This is part 3 of the Simple Table tutorial. In this chapter we’ll be marking up our pages with a few nifty HTML5 tags and building out each page’s content using PHP.

If you’ll be following along, I strongly suggest watching the original videos hosted on vimeo as the video is being downsampled when played directly from wordpress. To get to the orginal videos simply click on the word “Vimeo” in the bottom right hand corner of each clip.

Continue reading

Simple Table #2 – PHP

This is part 2 of the Simple Table tutorial. In this chapter we’ll be developing the PHP functions to pull data from MySql. We’ll be developing 4 functions:

  1. getDatabases() to retrieve a list of databases from the MySql instance.
  2. getTables() to retrieve a list of tables for the selected database.
  3. getRows() to retrieve a list of rows for the selected table.
  4. getColumns() to retrieve a list of column names for the selected table.

If you’ll be following along, I strongly suggest watching the original videos hosted on vimeo as the video is being downsampled when played directly from wordpress. To get to the orginal videos simply click on the word “Vimeo” in the bottom right hand corner of each clip.

Continue reading

Simple Table #1 – Introduction

In this tutorial we’ll be creating a table navigator for MySQL using HTML, CSS, PHP, and jQuery. In this chapter we’ll be walking through the final product.

If you’ll be following along, I strongly suggest watching the original videos hosted on vimeo as the video is being downsampled when played directly from wordpress. To get to the orginal videos simply click on the word “Vimeo” in the bottom right hand corner of each clip.

Download

You can download the source code for the Simple Table app at box.net.
Download Source