PHP简单数据库展示,php 自己写的简单数据库类

//header('content-type:text/html;charset=utf-8');

class DB{

private $host;

private $port;

private $user;

private $pass;

private $char;

private $db;

public function __construct($arr = array()){

$this ->host = isset($arr['host']) ? $arr['host'] : '127.0.0.1';

$this ->port = isset($arr['port']) ? $arr['port'] : '3306';

$this ->user = isset($arr['user']) ? $arr['user'] : 'root';

$this ->pass = isset($arr['pass']) ? $arr['pass'] : 'root';

$this ->char = isset($arr['char']) ? $arr['char'] : 'utf8';

$this ->db = isset($arr['db']) ? $arr['db'] : 'school';

$this -> conn();

$this -> dbquery("set names {$this->char}");

$this -> dbquery("use {$this->db}");

}

private function conn(){

@mysql_connect($this->host.':'.$this->port,$this->user,$this->pass) or die('数据库连接失败！');

}

public function dbquery($sql){

$res=@mysql_query($sql);

if(!$res){$this->showerr();}

}

public function dbinsert($sql){

$res=@mysql_query($sql);

if(!$res){$this->showerr();}

return mysql_insert_id();

}

public function dbupdate($sql){

$res=@mysql_query($sql);

if(!$res){$this->showerr();}

return mysql_affected_rows();

}

public function dbselect($sql){

$res=@mysql_query($sql);

if(!$res){$this->showerr();}

while($row=mysql_fetch_assoc($res)){

$arr[]=$row;

}

return $arr;

}

private function showerr(){

echo 'SQL请求错误：'.mysql_errno().':'.mysql_error();exit;

}

}

/*

$db=new DB;

var_dump($db);

var_dump($db->dbselect('select * from pr_student'));

var_dump($db->dbinsert("insert into pr_iuser values(null,'xiaodong',{SHA1(789456)})"));

var_dump($db->dbupdate("update pr_iuser set uname = 'xiaoming' where id='9'"));

*/

?>