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 {