More on displaying table data Nov30 '06

I've discussed before the crux of quickly displaying database data in a format that users can understand and absorb.

Ideally, we're talking about a front end for a database table.

After all, raw database data is nothing to look at.

That's why there are tools that help display this data, in a format that people can understand, such as an Excel spreadsheet. An Excel spreadsheet (with rows and columns) is a perfect "visual representation" of what a database would look like. If you give someone an Excel spreadsheet with column headers, and rows of data, they're very likely going to understand the representation of the data.

Excel is just one option for viewing database data. Other tools range from web-based configuration tools, such as phpMyAdmin, and other desktop applications such as Crystal Reports. Crystal, specifically, allows you to perform "grouping" functions, and create reports that "shows" your data in any number of customized templates. However, I'm not looking for something that extensive.

What I'd like is a quick way to display the data as an HTML table, without having to do all of the coding involved.

Here's what I picture:

<?php

    $viewTableData = new HtmlTableViewer;

    $viewTableData -> Query( "SELECT * FROM myTable" );

?>

We could pass the SQL query to the fictional class (HtmlTableViewer), which then queries the database, and outputs all of the data in HTML, with options for sorting, filtering, and searching.

Without the fictional class taking care of the details - the coding manpower taken to re-create such an HTML page from scratch is far beyond my means right now.

In this highly-automated world, I am used to just providing the most scant of details, and in turn, receiving a lot back. This is a prime example of where I need this type of automation.

Categories: Data , Excel , HTML , MySQL , Web Development

Add Feedback (view all)

Leave feedback

Feedback

Input format: The editor controls below will assist with Markdown syntax.

Status

Sub-status

Your info Name: Email (will not show on page):

Follow new comments via email? (You can turn this off any time)

Do you want your comments emailed to yourself?

Home Page (optional):

How about something like this. I thought about making a class to do it but I can't give you everything. <?php $query = mys ... Read more.

matthom is published and produced by Matt Thommes - an independent publishing enthusiast, mobile blogger, content creator, informative writer, web developer from a suburb of Chicago. Never one to conform, Matt intends to promote the effect the web has on our lives, in an effort to intensify, instruct, and clarify all that is happening around us.