public function update($table, $id, array $data, $and = '')
    {
        if (isset($this->prepared[$table])) {
            $data[] = $id;

            return $this->execute($table, $data);
        }
        $first = each($data);
        $single = (is_array($first['value'])) ? $first['value'] : false;
        if ($single) {
            $data = array_keys($single);
        }
        if (stripos($table, ' SET ') !== false) { // eg. 'table SET date = NOW(),'
            $query = "UPDATE {$table} ";
        } else {
            $query = "UPDATE {$table} SET ";
        }
        $query .= implode(' = ?, ', $data).' = ? WHERE '.$id.' = ? '.$and;
        $stmt = $this->prepare($query);
        if ($single && $stmt) {
            $affected = $this->update($stmt, $first['key'], array_values($single));
            $this->close($stmt);

            return $affected;
        }

        return $stmt;
    }
public function update($table, $id, array $data, $and = '')
    {
        if (isset($this->prepared[$table])) {
            $data[] = $id;

            return $this->execute($table, $data);
        }
        $first = each($data);
        $single = (is_array($first['value'])) ? $first['value'] : false;
        if ($single) {
            $data = array_keys($single);
        }
        if (stripos($table, ' SET ') !== false) { // eg. 'table SET date = NOW(),'
            $query = "UPDATE {$table} ";
        } else {
            $query = "UPDATE {$table} SET ";
        }
        $query .= implode(' = ?, ', $data).' = ? WHERE '.$id.' = ? '.$and;
        $stmt = $this->prepare($query);
        if ($single && $stmt) {
            $affected = $this->update($stmt, $first['key'], array_values($single));
            $this->close($stmt);

            return $affected;
        }

        return $stmt;
    }
public function update ( $ table , $ id , array $ data , $ and = '' ) { if ( isset ( $ this -> prepared [ $ table ] ) ) { $ data [ ] = $ id ; return $ this -> execute ( $ table , $ data ) ; } $ first = each ( $ data ) ; $ single = ( is_array ( $ first [ 'value' ] ) ) ? $ first [ 'value' ] : false ; if ( $ single ) { $ data = array_keys ( $ single ) ; } if ( stripos ( $ table , ' SET ' ) !== false ) { // eg. 'table SET date = NOW(),' $ query = "UPDATE {$table} " ; } else { $ query = "UPDATE {$table} SET " ; } $ query .= implode ( ' = ?, ' , $ data ) . ' = ? WHERE ' . $ id . ' = ? ' . $ and ; $ stmt = $ this -> prepare ( $ query ) ; if ( $ single && $ stmt ) { $ affected = $ this -> update ( $ stmt , $ first [ 'key' ] , array_values ( $ single ) ) ; $ this -> close ( $ stmt ) ; return $ affected ; } return $ stmt ; }
Modify records in a database table.

@param string|int $table Either the database table name, or the prepared statement id you got from calling this the first time.  You can also include *'SET'* here which is handy for getting some updates in that we can't otherwise do eg. *'table SET date = NOW(),'*.
@param array      $id    Either the name of the column with the unique identifier you will be referencing (when preparing a statement), or the unique identifier of the column you are updating.
@param array      $data  Either the table column names (when preparing a statement), or a row of values (to update).  If you are only updating one record and want to save yourself some typing, then make this an ``array(name => value, ...)`` of columns.
@param string     $and   Anything you would like to add at the end of the query after the WHERE eg. *'AND approved = "Y"'*.

@return bool|int Either ``false`` if there was an error, a prepared ``$stmt`` to keep passing off as the **$table**, or the ``$num`` of rows affected.  Don't forget to ``$db->close($stmt)``.

```php
if (!$db->update('employees SET id = 101', 'id', array(
106 => array(
'name' => 'Roberto Cratchit',
'title' => 'CEO',
)
))) {
echo $db->log('error'); // A unique id constraint
}

if ($stmt = $db->update('employees', 'id', array('title'))) {
$db->update($stmt, 103, array('Janitor'));
$db->update($stmt, 99, array('Quality Control'));
$db->close($stmt);
}
```
Modify records in a database table .