seeking php/mysql reporting scripts

Anon

Anyone know of any reliable scripts that will run reports using a mysql database?

Your feedback will be greatly appreciated.

Thanks,

Andrew

Anon

UMMMMMMMMMMMMMMMMMMMM..........

what data is in the database?

if the database has a table like this

table person
name varchar(64)
age INT

then this would be a reliable report script for this server using a mysql database:

<?php

$result = mysql_query("SELECT name, age FROM person ORDER BY age");
while(list($name, $age) = mysql_fetch_row($result) {
echo "$name - $age<br />";
}

gees, i hope that helps 🙂

Anon

I'm just looking to save some time. I have a medium size online store, where I want to generate some on-demand reports. I was hoping that someone had already created a script that will read a database, determine the fields, then allow the user to create a report based on the fields that he/she chooses. Perhaps someone has found something like this.

Thanks,

Andrew

Anon

i'm sure everyone has MADE something like this. you really have to customize it to your database to get the feel right.

getting some input and querying a database based on the input and spitting out the result set is REALLY simple. if you could get the fields, and how to sort you are set.

so just make an interface that list the available fields, let them choose the ones they want. then query the database and spit out the results unsorted. then let them click on the column names to sort. all you need is a simple front end, and an easier back end... 1 query and 1 while loop, 2 lines!

if you want complicated reports like the average time between purchases, then your interface will be a bit trickier, and probably impossible for some numbers you may want, for that reason also, you have to make this yourself. or post your database and what you want and hope someone has a light workload and some time to do it for you.

cordex

Or, if you don't want to take the time and/or it will be complicated for you, you could always hire someone.