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