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().

Working with Indexes

Interacting with the Work Queue

Last modified 5yr ago