I'm currently developing a PHP script to automatically share posts on Facebook. The script runs perfectly when executed directly from the browser, but when I enable cron jobs it executes the file without sharing on my Facebook wall. I'm unsure of what might be causing this issue. Here is a snippet of my script:
<?php
ob_start();
require_once('facebookapi/site-primary-config.php');
require_once('facebookapi/facebook.php');
// configuration
$appid = 'xxxxx';
$appsecret = 'xxxxx';
$pageId = 'xxxx';
//Get Load from Social Video ID
$get_link_sql = mysqli_query($conn,"SELECT tblmevids.vid_code as video_tbl_code,
tblmevids.vid_title as video_tbl_title,
tblmevids.vid_seo_descp as video_tbl_description,
tblmevids.vid_slug as video_tbl_slug,
tblsocial_share.vidsc_code as vid_social_code,
tblsocial_share.vid_fb_sstat as vid_social_fb_status
FROM tblmevids
JOIN tblsocial_share ON tblmevids.vid_code = tblsocial_share.vidsc_code
WHERE tblmevids.vid_act_stat = '1' AND tblsocial_share.vid_fb_sstat = '0' LIMIT 1");
$count_sql = mysqli_num_rows($get_link_sql);
$link_row = mysqli_fetch_array($get_link_sql);
$selected_video = $link_row['video_tbl_code'];
$selected_title = $link_row['video_tbl_title'];
$selected_description = $link_row['video_tbl_description'];
$selected_slug = $link_row['video_tbl_slug'];
if($count_sql > 0 ) {
//Grab Video Details
$msg = $selected_title.' - Watch Now at '.$site_baseurl.'watch?v='.$selected_video;
$title = $selected_title;
$uri = $site_baseurl.$selected_slug;
$desc = $selected_description;
$pic = $site_baseurl.'video_thumbs/'.$selected_video.'.jpg';
$action_name = 'Go to mywebsite.com';
$action_link = 'http://mywebsite.com';
echo $msg."<br/>".$title."<br/>".$uri."<br/>".$desc."<br/>".$pic."<br/>".$action_name."<br/>".$action_link."<br/>";
//Start FB Sharing
$facebook = new Facebook(array(
'appId' => $appid,
'secret' => $appsecret,
'cookie' => false,
));
$user = $facebook->getUser();
if ($user) {
try {
$page_info = $facebook->api("/$pageId?fields=access_token");
if (!empty($page_info['access_token'])) {
$attachment = array(
'access_token' => $page_info['access_token'],
'message' => $msg,
'name' => $title,
'link' => $uri,
'description' => $desc,
'picture'=>$pic,
'actions' => json_encode(array('name' => $action_name,'link' => $action_link))
);
$status = $facebook->api("/$pageId/feed", "post", $attachment);
$get_perfect_status = '1';
$updates = array();
if (is_numeric($get_perfect_status))
$updates[] = '`vid_fb_sstat` ="'.$get_perfect_status.'"';
$updates = implode(', ', $updates);
$sql = "UPDATE `tblsocial_share` SET $updates WHERE vidsc_code = '$selected_video'";
$result=mysqli_query($conn,$sql);
if($result){
echo "Shared on Facebook and updated successfully";
} else {
echo "There was a problem in sharing";
}
} else {
$status = 'No access token received';
}
} catch (FacebookApiException $e) {
error_log($e);
$user = null;
}
} else {
header("Location:{$facebook->getLoginUrl(array('scope' => 'publish_actions,manage_pages'))}");
}
echo $status;
} else {
echo "not found";
}
?>