|
This project provides
functions for generating SQL
queries, HTML tables, and
XML documents. It consists
of two classes and a set of
utility functions. SQLGen
provides PHP functions for
generating SQL query strings
from arrays. TableMaker
generates an HTML table or
XML document from an ADOdb
result set or an array.
Since the output of each
SQLGen method is a SQL
query string, the library is
compatible with ADOdb, PEAR
DB, PHPLib, and any other
database abstraction layer
that can execute SQL query
strings. Useful for
constructing complicated SQL
queries that vary according
to the situation. Different
if-then clauses can push
items onto from the argument
array - SQLGen will take
care of inserting commas and
"ands" into the
query string as necessary.
Date: Sep, 12 2002 |