$stmt = $dbh->prepare('INSERT INTO tweet_2015 (tweet_twitter_id, tweet_instagram_id, tweet_username, tweet_screenname, tweet_text, tweet_image, tweet_created_at)' . 'VALUES (:tweet_twitter_id, :tweet_instagram_id, :tweet_username, :tweet_screenname, :tweet_text, :tweet_image, :tweet_created_at)');
$createdAt = date('Y-m-d H:i:s', strtotime($createdAt));
$stmt->bindParam(':tweet_twitter_id', $twitterId);
$stmt->bindParam(':tweet_instagram_id', $instagramId);
$stmt->bindParam(':tweet_username', $username);
$stmt->bindParam(':tweet_screenname', $screenname);
$stmt->bindParam(':tweet_text', $text);
$stmt->bindParam(':tweet_image', $image);
$stmt->bindParam(':tweet_created_at', $createdAt);
$stmt->execute();
}
/********************************************************************************************+
* application
*/
$latestId = getLatestDbTwitterId($dbh);
$liveTweets = getLatestLiveTweets(CONFIG_HASH, $latestId);
foreach ($liveTweets as $t) {
if ($latestId < $t['id']) {
saveTweet($dbh, $t['id'], null, $t['user']['name'], $t['user']['screenname'], $t['text'], $t['images']['big'], $t['created_at']);
}
}
$latestId = getLatestDbInstagramId($dbh);
$liveGrams = getLatestLiveGrams(CONFIG_HASH, $latestId);
foreach ($liveGrams as $t) {
if ($latestId < $t['id']) {
saveTweet($dbh, null, $t['id'], $t['user']['name'], $t['user']['screenname'], $t['text'], $t['images']['big'], $t['created_at']);
}
}
$tweets = getLatestDbTweets($dbh);
$json['data'] = $tweets;
streamJson($json);
<?php
include 'config.php';
$method = optional_param('m');
switch ($method) {
case 'tweet':
saveTweet(optional_param('text'));
break;
case 'follow':
addFollower(optional_param('userid'));
break;
case 'unfollow':
removeFollower(optional_param('userid'));
break;
default:
# code...
break;
}
function saveTweet($message)
{
$tweets = R::dispense('tweets');
$tweets->userid = $_SESSION['user_id'];
$tweets->tweets = $message;
$id = R::store($tweets);
}
function addFollower($userid)
{
$following = R::dispense('following');
$following->userid = $_SESSION['user_id'];
$following->follows = $userid;
$id = R::store($following);
getFriends();
break;
case 'ADDFRIEND':
addFriend();
break;
case 'USERS':
getUsers();
break;
case 'PROFILE':
getProfile();
break;
case 'ENDSESS':
endSession();
break;
case 'SAVET':
saveTweet();
break;
case 'LOADT':
loadTweets();
break;
case 'EDIT':
editUser();
break;
case 'GET_SES':
getSessionSess();
break;
}
function loginAction()
{
$email = $_POST['email'];
$pass = $_POST['password'];
