|
|
Posted by Kenneth Downs on 04/28/07 01:42
fel wrote:
> does anybody know of any *web* query builder in PHP, something like
> the Access query builder, or similar, done in PHP or similar?
> I've looked for it trough the net, but nothing is colse to what I
> need.
>
> I'm not looking forward to build my own,I hardly have any time.
>
I'm guessing you're looking for one of those report writers that we all used
in the '80s and '90s in our LAN-based apps, of which the last man standing
seems to be Crystal Reports.
My own framework, Andromeda, includes a report writer, and the only people
who look for it are those "old folks" > 35 who even know they exist. This
also means it is the least mature part of the framework because it gets the
least pressure from users.
If you want a report writer, you may may be interested in a lot of the other
features we have in Andromeda.
If you don't want to adopt a framework, you are probably looking at rolling
your own report writer. It is easy enough to get a basic flat lister going
if you've got a good data dictionary that defines the columns. You can get
clever and automatically figure out the joins if the dictionary lists
foreign keys. We've got code in Andromeda you can examine. Even grouping
is pretty easy, the trouble doesn't start until you put in the filters. At
this point we punted on that and are having using enter SQL expressions
like "dob < '1990-01-01'".
Try using fpdf to generate the output, it's well documented and gives nice
PDF files, with some smooth stuff for headers, footers, auto page breaks,
page numbers and all of that necessary and cumbersome stuff.
And let us know how it turns out!
--
Kenneth Downs
www.secdat.com
www.andromeda-project.org
Navigation:
[Reply to this message]
|