dbHtmlTable is a PHP class that generates an HTML table from a database query. This utility is geared more towards developers than the average web site owner.
If you already know how to create a query to get the information you want from a database, dbHtmlTable can help you to spruce it up for display. For example, given the query
select Id, Title, Amount, StartDate, EndDate, Image, Status from mytable order by Title
it will produce a default table that looks like this:
then if we add a few options and call the class again, the same query can produce this:
Options include field alignment, automatic row numbers, clickable links, conditional formatting and field totals. For more examples and how to use the class, see dbHtmlTable examples.
This class uses MySQL as the data source by default, but it can easily be extended to use a different database or other data source, for example the contents of a log file.