if (!empty($token) && !empty($users_id2)) {
$users_id1 = getUsersId($token);
if (!empty($users_id1)) {
$sql = "DELETE FROM `follow` WHERE users_id1 = :users_id1 AND users_id2 = :users_id2";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':users_id2', $users_id2);
$stmt->bindParam(':users_id1', $users_id1);
try {
$stmt->execute();
} catch (PDOException $e) {
echo $e->getMessage();
}
$success = "1";
$msg = "Successfully unfollowed!";
$result = getAllFollowRequests($users_id1);
$result1 = getAllFollowers($users_id1);
$result2 = getAllFollowing($users_id1);
if (!empty($result)) {
$data = $result;
}
if (!empty($result1)) {
$followers = $result1;
}
if (!empty($result2)) {
$followings = $result2;
}
// $sql1="SELECT U.id, U.name AS username, CONCAT( '$path', profile_pic )AS profile_pic, U.apn_id
// FROM `follow` AS F
// JOIN users AS U ON F.users_id1 = U.id
// WHERE F.id =:follow_id";
// $sth1=$conn->prepare($sql1);
<?php
//SAE有Cron服务，所以不需要这样循环了
// ignore_user_abort(true);
// set_time_limit(0);
echo "<h1>She Send Weibo</h1>";
date_default_timezone_set('Asia/Shanghai');
echo "</br>------" . date('Y-m-d H:i') . "--------</br>";
$allWeibo = getAllweibo();
$allFollowers = getAllFollowers();
foreach ($allFollowers as $follower) {
$latestWeibo = getLatestWeibo($follower['latestWeibo_createdAt'], $follower['user_idstr'], $allWeibo);
if (count($latestWeibo) > 0) {
for ($i = count($latestWeibo) - 1; $i >= 0; $i--) {
sendMessage($latestWeibo[$i]);
}
updateLatestWeiboCreatedTime($latestWeibo[0]->user->idstr, $latestWeibo[0]->created_at);
} else {
echo "no new weibo</br>";
}
}
echo "</br>--------------------------------------</br>";
function getAllWeibo()
{
$sina_api_url = "https://api.weibo.com/2/statuses/friends_timeline.json?access_token=2.00GAm1DGl5reKC5a97f4101fRNyi3B";
echo "url::::::::::: {$sina_api_url}</br>";
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, $sina_api_url);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$data = curl_exec($curl);
if (!empty($result)) {
$success = "1";
$msg = "Following are the followers";
$data = $result;
} else {
$success = "1";
$msg = "No follower exist";
}
} else {
$success = "0";
$msg = "No such user exist!";
}
} elseif (!empty($others_id)) {
$others_id = checkUsersIdExist($others_id);
if ($others_id) {
$result = getAllFollowers($others_id);
if (!empty($result)) {
$success = "1";
$msg = "Following are the followers";
$data = $result;
} else {
$success = "1";
$msg = "No follower exist";
}
} else {
$success = "0";
$msg = "No such user exist!";
}
} else {
$success = "0";
$msg = "Incomplete parameters!";
