$data = array();
$data['image_link'] = $item->images->standard_resolution->url;
if (!empty($item->caption)) {
$data['caption'] = $item->caption->text;
} else {
$data['caption'] = '';
}
if (!empty($item->user)) {
$data['user'] = $item->user->username;
$data['userPicture'] = $item->user->profile_picture;
} else {
$data['user'] = '';
$data['userPicture'] = '';
}
$data['id'] = $item->id;
$likes = $instagram->getMediaLikes($data['id']);
print_r($likes);
echo "xxxx";
$dataLinkArray = array();
$dataLink = "";
foreach ($item->likes->data as $itemLink) {
//$dataLink .= '<a href="https://instagram.com/'. $itemLink->username. '" class="usuarios">' . $itemLink->username . "</a> ";
$dataLink .= $itemLink->username . ", ";
//$dataLinkArray[] = $itemLink->username;
$a = array();
$a['nombre'] = $itemLink->username;
$dataLinkArray[] = $a;
}
$data['dataLink'] = $dataLink;
$data['dataUser'] = $dataLinkArray;
$data['likes'] = $item->likes->count;
$instagram = new Instagram(array('apiKey' => 'ab9ad048ea114512a095a0c3237fc5ca', 'apiSecret' => 'aa4c65fbdcd24065b17fee377da89d3a', 'apiCallback' => 'https://www.misiva.com.ec/vespainstagram/'));
// Receive OAuth code parameter
$code = $_GET['code'];
if (!isset($_GET['code'])) {
$code = "40a5095bb5484217b0f324798c7ad865";
}
// Check whether the user has granted access
if (true === isset($code)) {
// Receive OAuth token object
$data = $instagram->getOAuthToken($code);
// Store user access token
$instagram->setAccessToken($data);
// Now you can call all authenticated user methods
// Get the most recent media published by a user
// 1133961085 id vespa_ecuador
$likes = $instagram->getMediaLikes('1090835460940398909_1640259127');
print_r($item->id);
echo "xxxx";
$media = $instagram->getTagMedia('vespaecuador');
//echo json_encode($media);
$dataTotal = array();
foreach ($media->data as $item) {
// print_r($item);
// echo "xxx";
$data = array();
$data['image_link'] = $item->images->standard_resolution->url;
if (!empty($item->caption)) {
$data['caption'] = $item->caption->text;
} else {
$data['caption'] = '';
}
$sqlTagCheck = "SELECT COUNT(ID) FROM Tags WHERE PostID = '{$postid}'";
$tagcheck = mysqli_query($con, $sqlTagCheck) or die("Error checking for '{$postid}' tags: " . mysqli_error($con) . "<br>{$sqlTagCheck}");
$tagcheck = mysqli_fetch_array($tagcheck);
$count = $tagcheck[0];
if ($count == 0) {
foreach ($media->tags as $tag) {
$sqlTagInsert = "INSERT INTO `Tags`(`Tag`, `PostID`, `Created_at`) VALUES ('{$tag}', '{$postid}', NOW())";
mysqli_query($con, $sqlTagInsert) or die("Error inserting tag '{$tag}': " . mysqli_error($con) . "<br>{$sqlTagInsert}");
// echo "$sqlTagInsert;<br>";
}
}
}
$CommentCount = $media->comments->count;
$LikeCount = $media->likes->count;
if ($LikeCount > 0) {
$medialikes = $instagram->getMediaLikes($postid);
foreach ($medialikes->data as $key => $value) {
$sqlLikeCheck = "SELECT COUNT(ID) FROM LikeUsers WHERE PostID = '{$postid}' AND UserID = '" . $value->id . "'";
$likecheck = mysqli_query($con, $sqlLikeCheck) or die("Error checking liked user '" . $value->id . "': " . mysqli_error($con) . "<br>{$sqlLikeCheck}");
$likecheck = mysqli_fetch_array($likecheck);
$count = $likecheck[0];
if ($count == 0) {
$sqlInsertLikeUsers = "INSERT INTO `LikeUsers`(`PostID`, `UserID`, `UserName`, `FullName`, `Created_at`) VALUES ('{$postid}', '" . $value->id . "','" . $value->username . "','" . urlencode($value->full_name) . "', NOW())";
mysqli_query($con, $sqlInsertLikeUsers) or die("Error inserting liked user '" . $value->id . "': " . mysqli_error($con) . "<br>{$sqlInsertLikeUsers}");
// echo "$sqlInsertLikeUsers;<br>";
}
}
}
$Link = $media->link;
$ImageThumbLink = $media->images->thumbnail->url;
$ImageStandardLink = $media->images->standard_resolution->url;
