There are many occasions where I need to show database data directly on a website. Most of our custom website solutions contain this type of website development.
This type of development allows us to do many of the following:
In this tutorial I'm going to teach you how to display data from a database in an HTML table on a webpage.
I use the MooTools HtmlTable Class to show the data in an HTML Table on the webpage. The MooTools HtmlTable Class makes it easy to add rows, sort data, select rows, and much more. I use many of the options for the HtmlTable Class such as zebra, sort, and select.
I use the MooTools Request Class to perform all of my Ajax calls to the database.
I use Google Charts Visualization to graphically display the data.
There is a lot of information contained in this tutorial. I will try to break it down in simple steps.
You can download all of the files in the tutorial here: