}
if ($rs = mysqli_fetch_array($rs)) {
$id = $rs['id'];
} else {
header('Location: DBError.html');
}
}
$rs = mysqli_query($con, "select * from user where id='" . $id . "'");
if ($rs = mysqli_fetch_array($rs)) {
$user = new User($rs);
} else {
header('Location: DBError.html');
}
$rs = mysqli_query($con, "select * from tweet where user_id='" . $id . "'");
while ($tweet = mysqli_fetch_array($rs)) {
$user->set_tweets(new Tweet($tweet['id'], $tweet['text'], $tweet['created_by'], $tweet['creater_profile_image'], $tweet['created_at']));
}
mysqli_close($con);
$html = '
<style>
#wall {
background-color: #' . $user->get_profile_sidebar_fill_color() . '
}
body {
background-image: url(' . $user->get_profile_background_image_url() . ');
background-repeat: no-repeat;
background-position: 0% -15%;
background-color: #' . $user->get_profile_background_color() . ';
}
footer {
if($rs = mysqli_fetch_array($rs)) {
$user = new User($rs);
} else {
header('Location: ../DBError.html');
}
/* Create a TwitterOauth object with consumer/user tokens. */
$connection = new TwitterOAuth(CONSUMER_KEY, CONSUMER_SECRET, $access_token['oauth_token'], $access_token['oauth_token_secret']);
$tweets = $connection->get("statuses/home_timeline",array("count"=>10,"exclude_replies"=>true,"include_entities"=>false));
mysqli_query($con, "delete from tweet where user_id='' or user_id = '".$user->get_id()."'");
if(count($tweets)!=0 && is_array($tweets)) {
foreach ($tweets as $tweet) {
$user->set_tweets(new Tweet($tweet->id_str, $tweet->text, $tweet->user->screen_name, $tweet->user->profile_image_url, $tweet->created_at));
mysqli_query($con, "insert into tweet values (
'".$tweet->id_str."',
'".addslashes($tweet->text)."',
'".$tweet->user->screen_name."',
'".$tweet->user->profile_image_url."',
'".$tweet->created_at."',
'".$user->get_id()."')") or die(mysqli_error($con));
}
}
mysqli_close($con);
echo $user->get_tweets_json();
