<?php/** * @author Jerome Izard * @version 1.2 * @package package_name */class NewsObject{ public $id = NULL; public $titre = NULL; public $contenu = NULL; public $auteur = NULL; public $date = NULL; public function __construct($array=NULL) { if (is_array($array)) { foreach ($array as $key=>$val ) { if ( property_exists($this, $key) ) $this->$key = $val; } } $this->id = (int) $this->id; } public function checkFields() { if ( !isset($this->titre) ) throw new MyException ('Le champ titre n\'est pas rempli !'); if ( !isset($this->contenu) ) throw new MyException ('Le champ contenu n\'est pas rempli !'); }}class News{ private $db; private $flag = FALSE; public function __tostring() { return 'toto'; } public function __construct() { $this->db = singleton::getInstance('mysql','mysql'); } public function addNews(NewsObject $object) { $objet->checkFields(); $this->db->query('INSERT INTO news (titre, contenu, auteur) VALUES (\''.$object->title.'\', \''.$object->content.'\', \''.$object->login.'\')'); } public function delNews($id) { $this->db->query('DELETE FROM news WHERE id=\''.$id.'\' LIMIT 1'); } public function updateNews(NewsObject $object) { $this->db->query('UPDATE news SET titre=\''.$object->title.'\', contenu=\''.$object->content.'\', auteur=\''.$object->login.'\', WHERE id=\''.$object->id.'\''); } public function getSeveralNews($start, $limit) { if (!$this->flag) { $this->db->query('SELECT DATE_FORMAT(time,"%d-%m-%Y à %Hh%i") as date, titre, auteur, contenu, id FROM news ORDER BY id DESC LIMIT '.$start.', '.$limit.''); $this->flag = TRUE; } return $this->toObject($this->db->getArray()); } public function getOneNews($id) { $this->db->query('SELECT DATE_FORMAT(time,"%d-%m-%Y à %Hh%i") as date, titre, auteur, contenu, id FROM news WHERE id = \''.$id.'\''); return $this->toObject($this->db->getArray()); } public function countAllNews() { $this->db->query('SELECT COUNT(id) FROM news'); $data = $this->db->getRow(); return ((int)$data[0]); } private function toObject($array) { if ( $array == FALSE ) { $this->flag = FALSE; return FALSE; } else { return new NewsObject($array); } }}?>