PHP Criteria::generateUpdateSQL Examples

Example #1

File: Table.class.php Project: oparoz/thebuggenie

 /**
  * Perform an SQL update
  *
  * @param Criteria $crit
  * @param integer $id
  * 
  * @return Resultset
  */
 public function doUpdateById(Criteria $crit, $id)
 {
     $crit->setFromTable($this);
     $crit->addWhere($this->id_column, $id);
     $crit->setLimit(1);
     $crit->generateUpdateSQL();
     $statement = Statement::getPreparedStatement($crit);
     return $statement->performQuery('update');
 }

Example #2

File: Table.php Project: nrensen/b2db

 /**
  * Perform an SQL update
  *
  * @param Criteria $crit
  * @param integer $id
  *
  * @return Resultset
  */
 public function doUpdateById(Criteria $crit, $id)
 {
     $crit->setFromTable($this);
     $crit->addWhere($this->id_column, $id);
     $crit->setLimit(1);
     $crit->generateUpdateSQL();
     $statement = Statement::getPreparedStatement($crit);
     $value = $statement->performQuery();
     $this->deleteB2DBObjectFromCache($id);
     return $value;
 }