PHP Db::getDb方法代码示例

 /**
  * So far, it only initializes the connection to the database, using the ADOdb API.
  */
 function Model()
 {
     $this->Object();
     $this->_db =& Db::getDb();
     // fetch the database prefix
     $this->_prefix = Db::getPrefix();
     $this->_db->debug = DAO_DEBUG_ENABLED;
 }

 /**
  * Connects to the database using the parameters in the config file.
  *
  */
 function ConfigDbStorage($params = null)
 {
     // initialize the connection
     $this->_db =& Db::getDb();
     // get the prefix
     $this->_dbPrefix = Db::getPrefix();
     // and finally, load the whole data
     $this->_loadData();
 }

function bb2_db_query($query)
{
    include_once PLOG_CLASS_PATH . "class/database/db.class.php";
    $db =& Db::getDb();
    $result = $db->Execute($query);
    if (!$result) {
        return false;
    }
    return $result;
}

 function PluginTopCommentVisitors()
 {
     $this->PluginBase();
     $this->id = "topcommentvisitors";
     $this->author = "Mark Wu";
     $this->desc = "This plugin offers the rank list of visitors by number of comments.";
     $this->prefix = Db::getPrefix();
     $this->db =& Db::getDb();
     $this->locales = array("en_UK", "zh_TW", "zh_CN");
     $this->init();
 }

 public static function getByUsername($username)
 {
     $query = "SELECT * FROM Users WHERE username = :username";
     $stmt = Db::getDb()->prepare($query);
     $stmt->bindParam(":username", $username);
     if ($stmt->execute() && ($row = $stmt->fetch())) {
         $user = new User();
         $user->initFromDb($row);
         return $user;
     }
     return null;
 }

 /**
  * @private
  */
 function _checkTables()
 {
     // create the table to keep track of the voters, so that people cannot vote
     // more than once
     $fields = "\r\n\t\t\t      id I(10) NOTNULL PRIMARY AUTOINCREMENT,\r\n\t\t\t      recipients TEXT NOTNULL DEFAULT '',\n\t\t\t      recipients_cc TEXT NOTNULL DEFAULT '',\n\t\t\t      recipients_bcc TEXT NOTNULL DEFAULT '',\r\n\t\t\t      subject C(255) NOTNULL DEFAULT '',\r\n\t\t\t      body XL NOTNULL DEFAULT '',\r\n\t\t\t\t  date T(14) DEFDATE\r\n\t\t\t\t  ";
     $db =& Db::getDb();
     $dbPrefix = Db::getPrefix();
     $tableName = $dbPrefix . "mailcentre_sent";
     // create the data dictionary and create the table if necessary
     $dict = NewDataDictionary($db);
     $sqlArray = $dict->ChangeTableSQL($tableName, $fields);
     $result = $dict->ExecuteSQLArray($sqlArray);
     if (!$result) {
         die("There was an error creating the plugin tables!");
     }
     return true;
 }

 function _verifyTable()
 {
     $fields = "\n      id I(11) NOTNULL PRIMARY AUTOINCREMENT,\n      blogId I(11) NOTNULL KEY,\n      active C(1) NOTNULL KEY,\n      subject TEXT NOTNULL,\n      responses TEXT NOTNULL,\n      responsedata TEXT NOTNULL,\n      dateadded I(11) NOTNULL";
     $fields2 = "\n      id I(11) NOTNULL KEY,\n      ip I8 NOTNULL KEY,\n      date I(11) NOTNULL KEY";
     $db =& Db::getDb();
     $dbPrefix = Db::getPrefix();
     $tableName = $dbPrefix . "plogpoll_polls";
     $tableName2 = $dbPrefix . "plogpoll_voterips";
     $dict = NewDataDictionary($db);
     $sqlAry = $dict->ChangeTableSQL($tableName, $fields);
     $result = $dict->ExecuteSQLArray($sqlAry);
     if (!$result) {
         die("There was an error creating/updating plogpoll plugin tables!");
     }
     $sqlAry = $dict->ChangeTableSQL($tableName2, $fields2);
     $result = $dict->ExecuteSQLArray($sqlAry);
     if (!$result) {
         die("There was an error creating/updating plogpoll plugin tables!");
     }
 }

 public static function getById($id)
 {
     $modelClass = get_called_class();
     $tableName = $modelClass . "s";
     $query = "\tSELECT\t*\n\t\t\t\t\t\tFROM\t{$tableName}\n\t\t\t\t\t\tWHERE\tid = :id";
     $stmt = Db::getDb()->prepare($query);
     $stmt->bindParam(":id", $id);
     if ($stmt->execute() && ($row = $stmt->fetch())) {
         $model = new $modelClass();
         $model->initFromDb($row);
         return $model;
     }
     return null;
 }

include_once PLOG_CLASS_PATH . "class/object/object.class.php";
include_once PLOG_CLASS_PATH . "class/net/xmlrpc/IXR_Library.lib.php";
include_once PLOG_CLASS_PATH . "class/config/config.class.php";
include_once PLOG_CLASS_PATH . "class/database/db.class.php";
include_once PLOG_CLASS_PATH . "class/dao/users.class.php";
include_once PLOG_CLASS_PATH . "class/dao/article.class.php";
include_once PLOG_CLASS_PATH . "class/dao/articles.class.php";
include_once PLOG_CLASS_PATH . "class/dao/articlecategories.class.php";
include_once PLOG_CLASS_PATH . "class/dao/users.class.php";
include_once PLOG_CLASS_PATH . "class/dao/blogs.class.php";
include_once PLOG_CLASS_PATH . "class/template/cachecontrol.class.php";
include_once PLOG_CLASS_PATH . "class/gallery/dao/galleryresources.class.php";
include_once PLOG_CLASS_PATH . "class/plugin/pluginmanager.class.php";
// init database
$_db = new Db();
$adodb = $_db->getDb();
// config object
$config =& Config::getConfig();
// users object
$users = new Users();
// articles object
$articles = new Articles();
// category object
$category = new ArticleCategories();
// blog object
$blogsG = new Blogs();
function newPost($args)
{
    global $users, $articles, $blogsG;
    $appkey = $args[0];
    $blogid = $args[1];