php mysql操作有關問題
來源:互聯網
上載者:User
php mysql操作問題
資料庫連結成功返回,在執行mysqli_query時拋出異常,求解!
錯誤資訊:
Fatal error: Uncaught exception 'DB_Exception' with message '更新失敗:No database selected' in...
php指令碼:
include_once("pay/CommonUtil.php");
include_once dirname(__FILE__).'/db/DbFactory.php';
$db = DbFactory::getInstance();
$sql = "select * from z_user";
$data = $db->query($sql);
var_dump($data);
?>
資料庫單例成功返回
class DbFactory {
private static $db = array();
public static function getInstance($dbKey = 'DEFAULT') {
if (array_key_exists($dbKey, self::$db)) {
return self::$db[$dbKey];
} else {
$newdb = new MysqliDb($dbKey);
if ($newdb->connect()) {
self::$db[$dbKey] = $newdb;
return $newdb;
} else {
return false;
}
}
}
}
$qrs = mysqli_query($this->_conn, $sql, $quick ? MYSQLI_USE_RESULT : MYSQLI_STORE_RESULT);
if (!$qrs) {
throw new DB_Exception('查詢失敗:' . mysqli_error($this->_conn));
} else {
return $qrs;
}
------解決方案--------------------
錯誤資訊很明確:No database selected
沒有選擇資料庫