getDeletedTweets();
$searched="";
if(isset($_POST['search']))
{
$sql="";
if(!empty($_POST['search']))
{
$tweet_search=$_POST['search'];
$sql.=" AND u.screen_name='$tweet_search'";
$searched=$tweet_search;
}
$getRes = mysql_query($sql);
$page = (int)(!isset($_GET["page"]) ? 1 : $_GET["page"]);
if ($page <= 0) $page = 1;
$per_page = 5;
$startpoint = ($page * $per_page) - $per_page;
$statement = "tweets AS t
LEFT JOIN users AS u ON u.user_id=t.user_id
WHERE t.is_deleted='Y' ".$sql." ORDER BY t.deleted_at DESC";
$results = mysql_query("SELECT u.screen_name,u.name,u.profile_image_url,t.tweet_id,t.tweet_text,t.created_at,t.deleted_at FROM {$statement} LIMIT {$startpoint} , {$per_page}");
}
else
{
$MySQL = "SELECT u.screen_name,u.name,u.profile_image_url,t.tweet_id,t.tweet_text,t.created_at,t.deleted_at
FROM tweets AS t
LEFT JOIN users AS u ON u.user_id=t.user_id
WHERE t.is_deleted='Y'
ORDER BY t.deleted_at DESC";
$getRes = mysql_query($MySQL);
$page = (int)(!isset($_GET["page"]) ? 1 : $_GET["page"]);
if ($page <= 0) $page = 1;
$per_page = 5;
$startpoint = ($page * $per_page) - $per_page;
$statement = "tweets AS t
LEFT JOIN users AS u ON u.user_id=t.user_id
WHERE t.is_deleted='Y'
ORDER BY t.deleted_at DESC";
$results = mysql_query("SELECT u.screen_name,u.name,u.profile_image_url,t.tweet_id,t.tweet_text,t.created_at,t.deleted_at FROM {$statement} LIMIT {$startpoint} , {$per_page}");
}
?>
Deleted Tweets Monitor - All deleted tweets from politicians
Was Posted at: