public static function getTweetsPostedBy($idUser) { $connection = new dbconnection(); $sql = "select * from jabaianb.tweet where emetteur='" . $idUser . "'"; $res = $connection->doQueryObject($sql, "tweet"); return $res === false ? false : $res; }
public static function getUsers() { $connection = new dbconnection(); $sql = "select * from jabaianb.utilisateur"; $res = $connection->doQueryObject($sql, "utilisateurTable"); return $res === false ? false : $res; }
public static function getPostbyId($id) { $connection = new dbconnection(); $sql = "select * from jabaianb.post where id='" . $id . "'"; $res = $connection->doQueryObject($sql, "post"); return $res === false ? false : $res; }
public static function getUsersWhoLikeTweetById($tweetId) { $connection = new dbconnection(); $sql = "SELECT U.* FROM jabaianb.utilisateur U\r\n\t\t\t\t\tINNER JOIN jabaianb.vote V ON (U.id = V.utilisateur)\r\n\t\t\t\tWHERE V.message = " . $tweetId; $res = $connection->doQueryObject($sql, "utilisateur"); if ($res === false) { return null; } return $res; }
public static function getVoteByTweetAndUser($tweetId, $userId) { $connection = new dbconnection(); $sql = "SELECT * FROM jabaianb.vote WHERE message = " . $tweetId . " AND utilisateur = " . $userId; $res = $connection->doQueryObject($sql, "vote"); if ($res === false || empty($res)) { return null; } return $res[0]; }
public static function getLastTweets($max = 10, $daysDifference = 30) { $dateLimite = strtotime(date("Y-m-d H:i:s") . "-" . $daysDifference . " day"); $dateLimite = date("Y-m-d H:i:s", $dateLimite); $connection = new dbconnection(); $sql = "SELECT T.* FROM jabaianb.tweet T\n\t\t INNER JOIN jabaianb.post P ON (T.post = P.id)\n\t\t WHERE P.date >= '" . $dateLimite . "'\n\t\t ORDER BY T.id DESC\n\t\t LIMIT " . $max; $res = $connection->doQueryObject($sql, "tweet"); if ($res === false) { return null; } return $res; }