public function getJSON($sql)
{
$connection = new connectDB();
$conn = $connection->initialDB();
if ($conn === null) {
echo "cannot link db.";
} else {
$result = array();
$queryRes = $conn->query($sql);
$count = 0;
while ($contentRes = $queryRes->fetch()) {
if ($contentRes["message"] !== null) {
$result[$count]["message"] = $contentRes["message"];
} else {
$result[$count]["message"] = "";
}
if ($contentRes["obj_id"] !== null) {
$result[$count]["object_id"] = $contentRes["obj_id"];
} else {
$result[$count]["object_id"] = "";
}
$result[$count]["created_time"] = $contentRes["created_time"];
$count += 1;
}
$result = json_encode($result);
$conn = null;
}
return $result;
}
{
//get Fan's page
public function getPage($url, $target)
{
$webPage = http_get($url, $target);
$webPage = $webPage["FILE"];
return json_decode($webPage, true);
}
}
$storeData = new storeData();
$token = "922569917793667|KTu9S6oja2E6yYbP0fbAD8wnHNA";
$counter = 0;
//get fan's page
$page_arr = array("477809915685496", "476194535860239");
$connection = new connectDB();
$conn = $connection->initialDB();
while ($counter < count($page_arr)) {
$url = "https://graph.facebook.com/" . $page_arr[$counter] . "/feed?access_token=" . $token;
$data = array();
$page = $storeData->getPage($url, "");
$count = count($page["data"]);
while ($count !== 0) {
for ($count_data = 0; $count_data < $count; $count_data++) {
if (isset($page["data"][$count_data]["message"])) {
$message = $page["data"][$count_data]["message"];
} else {
$message = "";
}
if (isset($page["data"][$count_data]["object_id"])) {
$object_id = $page["data"][$count_data]["object_id"];
} else {
