PHP org\equinox\dao\DaoTemplate::queryForUpdate Examples

Example #1

File: StaticContentDaoImpl.php Project: rousseau-christopher/equinox-core

 public function save(StaticContentDto $content)
 {
     $sql[] = "INSERT INTO static_content";
     $sql[] = "  SET id = :id,";
     $sql[] = "      body = :body,";
     $sql[] = "      date_modification = :date_modification";
     $sql[] = " ON DUPLICATE KEY UPDATE body=VALUES(body)";
     $params[':id'] = $content->id;
     $params[':body'] = $content->body;
     $params[':date_modification'] = time();
     $result = $this->daoTemplate->queryForUpdate(implode("\n", $sql), $params);
     return $result;
 }

Example #2

File: ContentDaoImpl.php Project: rousseau-christopher/equinox-core

 private function updateEdito($idContent)
 {
     $sql = "UPDATE content SET edito=0 WHERE id<>:id";
     $params['id'] = $idContent;
     return $this->daoTemplate->queryForUpdate($sql, $params);
 }