Example #1
0
	public function update(Alert $alert){
    	$query = $this->_db->prepare(' UPDATE t_alert SET 
		alert=:alert, status=:status, updated=:updated, updatedBy=:updatedBy
		WHERE id=:id')
		or die (print_r($this->_db->errorInfo()));
		$query->bindValue(':id', $alert->id());
		$query->bindValue(':alert', $alert->alert());
		$query->bindValue(':status', $alert->status());
		$query->bindValue(':updated', $alert->updated());
		$query->bindValue(':updatedBy', $alert->updatedBy());
		$query->execute();
		$query->closeCursor();
	}