The SQL Class is the meat of the SQL Layer Package, and is what we will be extending in all of our future applications.
We will not be using any static methods from this class, as it would defeat the purpose, and we could just as easily use PEAR::DB static methods.
[line 57]
[line 59]
[line 60]
[line 58]
SQL SQL( )
Currently Empty
void connect( string $dsn)
void disconnect( )
true|false insert( string $table, array $fields)
Wrapper for PEAR DB::autoExecute
void next( [string $format = SQL_INDEX])
void query( string $query, [string $type = SQL_NONE], [string $format = SQL_INDEX])
true|false update( string $table, array $fields, string $where)
Wrapper for PEAR DB::autoExecute() Contrary to DB::autoExecute(), insert() will require a WHERE statement, thus making it even harder to mess up an entire table with a single update statement.