PHP MysqliDb::getInstance方法代码示例

 public function SetProperties($lang, $id, $name, $description)
 {
     if ($who = Registry::getInstance()->getUser()) {
         if (isset($who['user_id']) && $who['user_id']) {
             $this_prop = $this->ListProperties(array($lang), array(), array($id));
             $db = MysqliDb::getInstance();
             if ($this_prop) {
                 $data = array($this->_propertyType => $name, 'description' => $description, 'who_last_update' => $who['user_id']);
                 if ($db->where($this->_propertyType . '_id', $id)->where('language', $lang)->update($this->_propertyType . '_data', $data)) {
                     return $name;
                 } else {
                     return false;
                 }
             } else {
                 $data = array($this->_propertyType . '_id' => $id, 'language' => $lang, $this->_propertyType => $name, 'description' => $description, 'who_last_update' => $who['user_id']);
                 if ($db->insert($this->_propertyType . '_data', $data)) {
                     return true;
                 } else {
                     return false;
                 }
             }
         } else {
             return false;
         }
     } else {
         return false;
     }
 }

function showzx()
{
    $zid = req('zid');
    $start = req('start', 0);
    $perpage = req('perpage', 0);
    if ($start < 0) {
        $start = 0;
    }
    if (empty($perpage)) {
        $perpage = 30;
    }
    if (empty($zid)) {
        showjson('zid_not_exist');
    }
    $db = MysqliDb::getInstance();
    $data = $db->rawQueryOne("SELECT z.*, u.username FROM zixun z LEFT JOIN users u ON z.uid=u.uid WHERE z.zid='{$zid}'");
    if ($db->count > 0) {
        $db->where("zid", $zid);
        $stats = $db->getOne("comment", "count(*) as cnt");
        $data['total'] = $stats['cnt'];
        //if($start>=$data['total']) $start=0;
        $comment = $db->rawQuery("SELECT c.*,s.username FROM comment c LEFT JOIN users s ON c.uid=s.uid WHERE c.zid='{$zid}' ORDER BY c.cid LIMIT {$start},{$perpage}");
        $data['count'] = $db->count;
        $data['comment'] = $comment;
        showjson('do_success', 0, array("zixun" => $data));
    }
    showjson('show_error');
}

 public function __construct()
 {
     /** @var array $db */
     include_once 'config.php';
     require_once 'PHP-MySQLi-Database-Class-master/MysqliDb.php';
     new MysqliDb($db);
     $this->db_instance = MysqliDb::getInstance();
     $this->db_config = $db;
 }

 /**
  * constructor
  *
  * @param string $type tipo de datamanager a ser incializado
  *
  * inicializa o objeto de log e de bd
  * inicializa o vetor de dados nulo de acordo com o tipo
  */
 function __construct($type)
 {
     $this->db = MysqliDb::getInstance();
     $this->log = Log::getInstance();
     //tipo de dado valido pra iniciar
     if (array_key_exists($type, $this->_validFields)) {
         $this->type = $type;
         foreach ($this->_validFields[$this->type] as $key => $value) {
             $this->setField($key, null);
         }
     }
 }

/**
 * Created by PhpStorm.
 * User: André
 * Date: 01/04/2015
 * Time: 13:57
 */
function buildOutput($data, $debug = false)
{
    $log = Log::getInstance();
    $db = MysqliDb::getInstance();
    $output = array();
    if ($log->countErrors() > 0) {
        $errors = $log->getErrors();
    }
    $output = $data;
    if (isset($errors) && sizeof($errors) > 0) {
        $output['_ERROR_'] = $errors;
    }
    if ($debug == 'true') {
        $output['_DEBUG_'] = $log->getLogs();
    }
    echo json_encode($output, JSON_PRETTY_PRINT);
}

function login()
{
    $password = req('password');
    $username = req('username');
    $db = MysqliDb::getInstance();
    if ($password && $username) {
        $db->where('username', $username);
        if ($user = $db->getOne('users')) {
            if ($user['password'] == $password) {
                $auth = authcode("{$user['password']}\t{$user['uid']}", 'ENCODE');
                showjson('do_success', 0, array("auth" => rawurlencode($auth)));
            }
            showjson('password_error');
        }
    }
    showjson('login_error');
}

function checkauth()
{
    global $_SGLOBAL;
    $auth = req('auth');
    if ($auth) {
        $db = MysqliDb::getInstance();
        @(list($password, $uid) = explode("\t", authcode($auth, 'DECODE')));
        $_SGLOBAL['uid'] = intval($uid);
        if ($password && $_SGLOBAL['uid']) {
            $db->where('uid', $_SGLOBAL['uid']);
            if ($user = $db->getOne('users')) {
                if ($user['password'] == $password) {
                    $_SGLOBAL['usertype'] = $user['usertype'];
                    $_SGLOBAL['username'] = $user['username'];
                    return;
                }
            }
        }
    }
    showjson('to_login');
}

function comment()
{
    global $_SGLOBAL;
    checkauth();
    //验证登陆
    $op = req('op');
    $db = MysqliDb::getInstance();
    if ($op == 'add') {
        $setarr = array('uid' => $_SGLOBAL['uid']);
        $setarr['message'] = req('message');
        $setarr['zid'] = req('zid', 0);
        if ($setarr['message'] && $setarr['zid']) {
            $id = $db->insert('comment', $setarr);
            //插入数据
            if ($id) {
                showjson('do_success', 0, array("cid" => $id));
            }
            showjson('submit_comment_error');
        }
        showjson('zid_or_message_can_not_empty');
    } elseif ($op == 'del') {
        $cid = req('cid', 0);
        if (empty($cid)) {
            showjson('non_normal_operation');
        }
        $db->where('cid', $cid);
        if ($_SGLOBAL['usertype'] == 1) {
            //是否管理员
        } else {
            $db->where('uid', $_SGLOBAL['uid']);
        }
        $result = $db->delete('comment');
        //删除评论
        if ($result) {
            showjson('do_success', 0);
        }
        showjson('comment_not_exist');
    }
}

 /**
  * @param array $data Data to preload on object creation
  */
 public function __construct($data = null)
 {
     $this->db = MysqliDb::getInstance();
     if (empty($this->dbTable)) {
         $this->dbTable = get_class($this);
     }
     if ($data) {
         $this->data = $data;
     }
 }

 /**
  * @param array $data Data to preload on object creation
  */
 public function __construct($data = null)
 {
     $this->db = MysqliDb::getInstance();
     if ($data) {
         $this->data = $data;
     }
 }