Exemple #1
0
 static function contect()
 {
     if (!self::$_connect) {
         @($conn = mysql_connect(HOST, SQLUER, SQLPW)) or die('数据库连接错误' . mysql_error());
         mysql_select_db(SQLDB);
         mysql_query("set character set'utf8'");
         mysql_query("set names 'utf8'");
         self::$_connect = $conn;
     }
     return self::$_connect;
 }
Exemple #2
0
 static function connect()
 {
     if (self::$_connect) {
         $conn = mysql_connect(HOST, SQL_USER, SQL_PWD);
         if ($conn) {
             mysql_select_db(DB_NAME);
             mysql_query("set names'utf8'");
             self::$_connect = $conn;
         } else {
             exit('数据库连接错误');
         }
     }
     return self::$_connect;
 }
Exemple #3
0
 /**
  * connect
  *
  * @return void
  */
 public static function connect()
 {
     if (!self::$_connect) {
         $conn = mysql_connect(DB_HOST, DB_USER, DB_PWD);
         if ($conn) {
             mysql_select_db(DB_NAME, $conn);
             mysql_query("set names 'utf8'");
             self::$_connect = $conn;
         } else {
             exit('database error!');
         }
     }
     return self::$_connect;
 }
Exemple #4
0
 public function connect($dbConfig = array())
 {
     if (!self::$_connect) {
         self::$_connect = mysqli_connect($dbConfig['host'], $dbConfig['user'], $dbConfig['password']);
         if (!self::$_connect) {
             // die('mysql connect error:'.mysqli_errno(self::$_connect));
             // 抛出异常
             throw new Exception(mysqli_errno(self::$_connect));
         }
         mysqli_select_db(self::$_connect, $dbConfig['database']);
         mysqli_query(self::$_connect, 'set names utf8');
         return self::$_connect;
     }
 }
Exemple #5
0
<?php

header("Content-type: text/html; charset=utf-8");
$db = new DB();
$db->_connect();
$id = $_GET['id'];
$sql = "delete from admin where id=" . $id;
// $open=fopen("a.txt","a" );
// fwrite($open,$sql);
// fwrite($open,"Sd");
// fclose($open);
$result = @mysql_query($sql);
$arr = array();
if ($result) {
    $arr = array('statusCode' => 200, 'message' => "删除成功", 'navTabId' => "", 'rel' => "", 'callbackType' => "forward", "forwardUrl" => "");
} else {
    $arr = array('statusCode' => 300, 'message' => "操作失败", 'navTabId' => "", 'rel' => "", 'callbackType' => "closeCurrent", "forwardUrl" => "");
}
foreach ($arr as $key => $value) {
    $arr[$key] = urlencode($value);
}
echo urldecode(json_encode($arr));
Exemple #6
0
 /**
  * Internal read handler, which is used by all read functions
  * It also provides a pagination abstraction to the user
  *
  * @todo Find a better pagination abstraction
  *
  * @param string $query Query format string
  * @param mixed ... Query parameters
  * @return ressource MySQLi result of the query
  */
 public static final function _read($query)
 {
     $query = xsprintf($query, 'DB::_escape', '#');
     foreach (DB::$work as $q => $d) {
         if (isset(DB::$con[$q])) {
             DB::$cur =& DB::$con[$q];
             break;
         }
     }
     DB::$work = DB::$args = array();
     DB::$a = 0;
     if (empty(DB::$con[$q])) {
         $r = apc_fetch('database-' . $q);
         if ($q > 0) {
             $r = $r['slaves'];
             DB::_connect($r[array_rand($r)], $q);
         } else {
             DB::_connect($r, $q);
         }
         DB::$cur =& DB::$con[$q];
     }
     mysqli_select_db(DB::$cur, DB_NAME . $q);
     if (null !== DB::$pre_query) {
         mysqli_query(DB::$cur, DB::$pre_query);
         DB::$pre_query = null;
     }
     $s = microtime(true);
     if (array() === DB::$options) {
         if (false === ($res = mysqli_query(DB::$cur, $query, DB::$result))) {
             DB::_log($query);
         }
         DB::$result = 0;
     } else {
         if (empty(DB::$options['table'])) {
             $table = '_rndtbl' . rand(1000, 9999);
         } else {
             $table = DB::$options['table'];
         }
         $param = DB::$options['sort'];
         if (isset($opt['dir']) && 0 === strcasecmp($opt['dir'], 'desc')) {
             $param .= ' DESC';
         }
         if (false === ($res = mysqli_query(DB::$cur, 'CREATE TEMPORARY TABLE ' . $table . ' (KEY SORT(' . $param . ')) ' . $query))) {
             DB::_log($query);
         } else {
             $res->free();
             if (isset($opt['offset'])) {
                 $offset = (int) $opt['offset'];
             } else {
                 $offset = '0';
             }
             $res = mysqli_query(DB::$cur, 'ALTER TABLE ' . $table . ' ADD OFFSET INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, DROP INDEX SORT, ORDER BY ' . $param);
             $res->free();
             if (isset($opt['limit'])) {
                 $param .= ' LIMIT ';
                 $param .= (int) $opt['limit'];
             }
             $res = mysqli_query(DB::$cur, 'SELECT * FROM ' . $table . ' WHERE OFFSET >=' . $offset . ' ORDER BY OFFSET' . $limit, DB::$result);
         }
         DB::$options = array();
     }
     if (class_exists('FB')) {
         FB::log(microtime(true) - $s . " - " . $query);
     }
     return $res;
 }