@老虎会游泳mysql.class.php文件
<?php
class Mysql_db{
private $host;
private $user;
private $pwd;
private $dbname;
private $charset;
//保存连接的资源
private $conn = null;
/*****
*构造方法打开配置文件
*****/
public function __construct(){
require_once("web.config.php");
$this->host = DB_HOST;
$this->user = DB_USER;
$this->pwd = DB_PASSWORD;
$this->dbname = DB_DATABASE;
$this->charset = DB_CHARSET;
/*****
*连接数据库
*****/
$this->connect($this->host,$this->user,$this->pwd);
}
/*******
**连接数据库方法
*******/
private function connect($_h,$_u,$_p) {
$conn = mysql_connect($_h,$_u,$_p);
$this->conn = $conn;
}
// 切换数据库
public function switchDb($db) {
$sql = 'use ' . $db;
$this->query($sql);
}
/*******
**发送mysql_query查询方法
*******/
public function query($sql) {
return mysql_query($sql,$this->conn);
}
/********
***查询数据库中的所有结果
********/
public function getAll($sql) {
$list = array();
$rs = $this->query($sql);
if(!$rs) {
return false;
}
while($row = mysql_fetch_assoc($rs)) {
$list[] = $row;
}
return $list;
}
}
echo '<pre />';
$mysql = new Mysql_db();
$sql = 'select * from goods';
$arr = $mysql->getAll($sql);
print_r($arr);
?>
web.config.php文件
<?php
define("DB_HOST","localhost");
define("DB_USER","root");
define("DB_PASSWORD","root");
define("DB_DATABASE","shop");
define("DB_CHARSET","utf-8");
?>
能够成功连接数据库,下面是连接打印结果!
Mysql_db Object
(
[host:Mysql_db:private] => localhost
[user:Mysql_db:private] => root
[pwd:Mysql_db:private] => root
[dbname:Mysql_db:private] => shop
[charset:Mysql_db:private] => utf-8
[conn:Mysql_db:private] => Resource id #4
)
最大的问题是调用getall方法查询数据库shop下面的goods表什么都没有显示,就是一个空白页面!连一个错误提示都没有,无语,,有提示我还可以改,,,可是一个提示都没有!纠结一天了。。。大神们指导下?