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:
- getDatabases() to retrieve a list of databases from the MySql instance.
- getTables() to retrieve a list of tables for the selected database.
- getRows() to retrieve a list of rows for the selected table.
- 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.
You can download the source code for the Simple Table app at box.net.