PHP Db::singleton Examples

Example #1

File: Db.php Project: nadiajolanda/esAMM2014

 /**
  *  Restituisce un singleton per la connessione al Db
  * @return \Db
  */
 public static function getInstance()
 {
     if (!isset(self::$singleton)) {
         self::$singleton = new Db();
     }
     return self::$singleton;
 }

Example #2

File: Consumer.class.php Project: AdvancingJusticeLA/TIG-Google-Apps-Integration

 public static function create($key, $secret)
 {
     $pdo = Db::singleton();
     $pdo->exec("insert into oauth_consumer (consumer_key,consumer_secret,active) values ('" . $key . "','" . $secret . "',1)");
     $consumer = new Consumer($pdo->lastInsertId());
     return $consumer;
 }

Example #3

File: User.php Project: Adriangel/omegame

 function __construct()
 {
     $this->db = Db::singleton();
     $this->id = 0;
     $this->user = "";
     $this->pass = "";
     $this->email = "";
 }

Example #4

File: User.class.php Project: AdvancingJusticeLA/TIG-Google-Apps-Integration

 public function __construct($id = 0)
 {
     $this->pdo = Db::singleton();
     if ($id != 0) {
         $this->id = $id;
         $this->load();
     }
 }

Example #5

File: functions.php Project: HighTechTorres/TwilioCookbook

function order_lookup($order_id)
{
    global $statusArray;
    $pdo = Db::singleton();
    $sql = "SELECT * FROM orders where `ID` = '{$order_id}' OR `order_key` = '{$order_id}' LIMIT 1";
    $res = $pdo->query($sql);
    while ($row = $res->fetch()) {
        return $statusArray[$row['status']];
    }
    return 'No Order Matching that ID was found';
}

Example #6

File: functions.php Project: HighTechTorres/TwilioCookbook

function get_user($uid)
{
    if (isset($uid) && !empty($uid)) {
        $pdo = Db::singleton();
        $sql = "SELECT * FROM `user` WHERE `ID`='{$uid}';";
        #		echo $sql;
        $res = $pdo->query($sql);
        while ($row = $res->fetch()) {
            return $row;
        }
    }
    return null;
}

Example #7

File: speaker.php Project: HighTechTorres/TwilioCookbook

<?php

session_start();
include "config.php";
include "pdo.class.php";
include 'Services/Twilio.php';
$pdo = Db::singleton();
$client = new Services_Twilio($accountsid, $authtoken);
$room = $_SESSION['room'];
$sql = "SELECT * FROM conference where `ID` = '{$room}'";
$res = $pdo->query($sql);
$row = $res->fetch();
header('Content-type: text/xml');
echo '<?xml version="1.0" encoding="UTF-8"?>';
?>
<Response>
    <Dial>
        <Conference startConferenceOnEnter='false'><?php 
echo $row['ID'];
?>
</Conference>
    </Dial>
</Response>

Example #8

File: image2.class.php Project: badtux/pmg

 public function __construct($uploadId)
 {
     $this->db = Db::singleton();
     $this->load($uploadId);
 }

Example #9

File: UserGuide.php Project: tomorrowdemo/haojiaolexue

 /**
  * db类 使用示例
  */
 public function dbAction()
 {
     //        $db_conf = RThink_Config::get('db.test');
     $db_conf = array('host' => 'localhost', 'dbname' => 'test', 'username' => 'root', 'password' => '');
     $db = Db::singleton($db_conf);
     $db->getProfiler()->setEnabled(true);
     $db_profilers[] = $db->getProfiler();
     $this->getFrontController()->getRequest()->setParam('db_profilers', $db_profilers);
     $stmt = $db->query('SELECT * FROM story where id > :id limit 1', array("id" => 0));
     $res = $stmt->fetchAll();
 }

Example #10

File: upload.class.php Project: badtux/pmg

 public function __construct($accept = array())
 {
     $this->db = Db::singleton();
     $this->acceptFileTypes = $accept;
 }