|
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 |