|
Previous Page |
Solar_Sql_Adapter_Sqlite |
Next Class |
update()
public
int
update (
string $table,
array $data,
string|array $where
)
Updates a table with specified data based on a WHERE clause.
Inherited from Solar_Sql_Adapter.
Parameters
- (string)
$table: The table to udpate. - (array)
$data: An associative array where the key is the column name and the value is the value to use for that column. - (string|array)
$where: The SQL WHERE clause to limit which rows are updated.
Returns
- (int) The number of rows affected.
Description
Updates a table with specified data based on a WHERE clause.
Automatically applies Solar_Sql::quote() to the data values for you.
Local
- Overview
- Constants
- Properties
- Methods
- __construct()
- __destruct()
- _addProfile()
- _bind()
- _buildDsn()
- _checkIdentifier()
- _createSequence()
- _dropIndex()
- _dropSequence()
- _exception()
- _fetchTableCols()
- _fetchTableList()
- _getCacheKey()
- _getTypeSizeScope()
- _modAutoincPrimary()
- _modIndexName()
- _modSelect()
- _modSequenceName()
- _nextSequence()
- _postConnect()
- _prepare()
- _quoteName()
- _quoteNamesIn()
- _select()
- _setDsn()
- _setup()
- _sqlColdef()
- _sqlCreateTable()
- _sqlSelect()
- addColumn()
- apiVersion()
- begin()
- commit()
- connect()
- createIndex()
- createSequence()
- createTable()
- delete()
- disconnect()
- dropColumn()
- dropIndex()
- dropSequence()
- dropTable()
- dump()
- fetchAll()
- fetchAssoc()
- fetchCol()
- fetchOne()
- fetchPairs()
- fetchPdo()
- fetchSql()
- fetchTableCols()
- fetchTableList()
- fetchValue()
- getCache()
- getCacheKeyPrefix()
- getPdo()
- getProfile()
- insert()
- lastInsertId()
- locale()
- nextSequence()
- query()
- quote()
- quoteInto()
- quoteMulti()
- quoteName()
- quoteNamesIn()
- rollback()
- setCache()
- setCacheKeyPrefix()
- setProfiling()
- update()