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