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; }
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; }
/** * 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; }
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; } }
<?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));
/** * 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; }