public function getAllMessagesByDate($time) { include $_SERVER["DOCUMENT_ROOT"] . "/modele/bdd/connect.php"; $req = $bdd->prepare("SELECT * FROM message WHERE id_message IN " . "(SELECT id_message FROM canalMessage WHERE canalMessage.id_canal=:id_canal) AND date > :time"); $req->execute(array(":id_canal" => $this->_canal->getID(), ":time" => $time)); $messages = array(); while ($messageFetch = $req->fetch()) { $messages[] = MessageSQL::setData($messageFetch); } return $messages; }
/** * * @param type $canal */ public static function getMessageByCanal($canal) { include $_SERVER["DOCUMENT_ROOT"] . "/modele/bdd/connect.php"; $sql = "SELECT * FROM message WHERE id_message IN (SELECT id_message FROM canalMessage WHERE id_canal=:id)"; $req = $bdd->prepare($sql); $req->execute(array(":id" => $canal->getID())); $messages = array(); while ($messageFetch = $req->fetch()) { $messages[] = MessageSQL::setData($messageFetch); } return $messages; }
public function save() { $messageSQL = new MessageSQL($this); $messageSQL->save(); }
public static function getUsersByCanal($user) { include $_SERVER["DOCUMENT_ROOT"] . "/modele/bdd/connect.php"; $sql = "SELECT * FROM user WHERE id_user IN (SELECT id_user FROM canalUser WHERE id_user=:id)"; $req = $bdd->prepare($sql); $req->execute(array(":id" => $user->getID())); while ($userFetch = $req->fetch()) { $users[] = MessageSQL::setData($userFetch); } return $users; }