PHP connectDBの例

コード例 #1

ファイル: getData.php プロジェクト: BeautyInfo/beautyUniversity

 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;
 }

コード例 #2

ファイル: commonFun.php プロジェクト: dimahongkong/Searching-Exploring-with-Speech-Augmented-Map-Information-SESAMI

 public function getQueryResult($table, $queryItem, $condition)
 {
     $DBconnect = new connectDB();
     return $DBconnect->executeQueryRecord("SELECT " . $queryItem . " FROM " . $table . " WHERE " . $condition);
 }

コード例 #3

ファイル: makePackage.php プロジェクト: dimahongkong/Searching-Exploring-with-Speech-Augmented-Map-Information-SESAMI

	<?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;
            }

コード例 #4

ファイル: store_data.php プロジェクト: Ye-Yong-Chi/beautyUniversity

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"];

コード例 #5

ファイル: data.php プロジェクト: Nankym/finances

 /** 
  * Função para conectar ao banco de dados
  */
 protected function getConnection($trader)
 {
     $mongo = new connectDB();
     $db = $mongo->getConnection($trader);
     return $db;
 }