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; }
public function getQueryResult($table, $queryItem, $condition) { $DBconnect = new connectDB(); return $DBconnect->executeQueryRecord("SELECT " . $queryItem . " FROM " . $table . " WHERE " . $condition); }
<?php // include 'includeList.php'; include "./share/connectDB.php"; include "./share/sqlList.php"; //error_reporting(0); $DBConnect = new connectDB(); $sqlList = new sqlList(); class MyDB extends SQLite3 { function __construct() { $this->open("package/indoormap.sqlite"); } } function deleteDirectory($dir) { if (!file_exists($dir)) { return true; } if (!is_dir($dir) || is_link($dir)) { return unlink($dir); } foreach (scandir($dir) as $item) { if ($item == '.' || $item == '..') { continue; } if (!deleteDirectory($dir . "/" . $item)) { chmod($dir . "/" . $item, 0777); if (!deleteDirectory($dir . "/" . $item)) { return false; }
class storeData { //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"];
/** * Função para conectar ao banco de dados */ protected function getConnection($trader) { $mongo = new connectDB(); $db = $mongo->getConnection($trader); return $db; }