将封装的数据库类,改写成静态属性和方法来访问
<?php
class db{
private static $host;
private static $dbname;
private static $user;
private static $pass;
public function __construct($host,$dbname,$user,$pass){
self::$host=$host;
self::$dbname=$dbname;
self::$user=$user;
self::$pass=$pass;
self::$connect();
}
private static function connect(){
mysql_connect(self::$host,self::$user,self::$pass);
mysql_select_db(self::$dbname);
mysql_query("set names utf8");
}
public function getAll($sql){
$result = mysql_query($sql);
$rows = array();
while($row = mysql_fetch_assoc($result)){
$rows[] = $row;
}
return $rows;
}
public function getOne($sql){
$result = mysql_query($sql);
$total = mysql_fetch_array($result);
$total_row = $total[0];
return $total_row;
}
}
?>
<?php
class db{
private static $host;
private static $dbname;
private static $user;
private static $pass;
public function __construct($host,$dbname,$user,$pass){
self::$host=$host;
self::$dbname=$dbname;
self::$user=$user;
self::$pass=$pass;
self::$connect();
}
private static function connect(){
mysql_connect(self::$host,self::$user,self::$pass);
mysql_select_db(self::$dbname);
mysql_query("set names utf8");
}
public function getAll($sql){
$result = mysql_query($sql);
$rows = array();
while($row = mysql_fetch_assoc($result)){
$rows[] = $row;
}
return $rows;
}
public function getOne($sql){
$result = mysql_query($sql);
$total = mysql_fetch_array($result);
$total_row = $total[0];
return $total_row;
}
}
?>