update() public method

Run an update statement against the database.
public update ( string $query, array $bindings = [] ) : integer
$query string
$bindings array
return integer
Connection Class Documentation
Example #1
0
 /**
  * Update a record in the database.
  *
  * @param  array  $values
  * @return int
  */
 public function update(array $values)
 {
     $sql = $this->grammar->compileUpdate($this, $values);
     return $this->connection->update($sql, $this->cleanBindings($this->grammar->prepareBindingsForUpdate($this->bindings, $values)));
 }
Example #2
0
 /**
  * Update a record in the database.
  *
  * @param  array  $values
  * @return int
  */
 public function update(array $values)
 {
     $bindings = array_values(array_merge($values, $this->getBindings()));
     $sql = $this->grammar->compileUpdate($this, $values);
     return $this->connection->update($sql, $this->cleanBindings($bindings));
 }
Example #3
0
 /**
  * {@inheritdoc}
  */
 public function updatePermission(PermissionInterface $permission)
 {
     $this->connection->update('UPDATE ' . $this->getAclSchema()->getPermissionsTableName() . ' SET mask = :mask WHERE requester = :requester AND resource = :resource', ['mask' => $permission->getMask(), 'requester' => $permission->getRequester()->getAclRequesterIdentifier(), 'resource' => $permission->getResource()->getAclResourceIdentifier()]);
 }