Changing Table Data

delete($table, $criteria)

Create DELETE statement and add to queue. Criteria specified in $criteria can be a CriteriaElement object, or a string to use as the where clause.

Returns true on success, or false on error. Additional information may be available using getLastError() and getLastErrNo().

insert($table, $columns, $quoteValue)

Adds an INSERT SQL statement for the table named $table to the work queue. The data to insert is supplied in $columns as an array. Each element in the array is in the form array('column' => 'value').

By default, the value portion of the supplied $columns entries is quoted in the resulting SQL. To supply your own quoting, supply false for $quoteValue. This is especially useful if you are using expressions in the values.

Returns true on success, or false on error. Additional information may be available using getLastError() and getLastErrNo().

update($table, $columns, $criteria, $quoteValue)

Adds an UPDATE SQL statement for the table named $table to the work queue. The data to updated is supplied in $columns as an array. Each element in the array is in the form array('column' => 'value'). Criteria specified in $criteria to limit which rows are updated can be a CriteriaElement object, or a string to use as the where clause.

By default, the value portion of the supplied $columns entries is quoted in the resulting SQL. To supply your own quoting, supply false for $quoteValue. This is especially useful if you are using expressions in the values.

Returns true on success, or false on error. Additional information may be available using getLastError() and getLastErrNo().

truncate($table)

Add statement to empty the table named $table to the work queue.

Returns true on success, or false on error. Additional information may be available using getLastError() and getLastErrNo().