class mysql{ private $host;//����� private $name;//�û��� private $pass;//���� private $database;//��ݿ��� private $ut;//���뷽ʽ function __construct($host,$name,$pass,$database,$ut){ $this->host=$host; $this->name=$name; $this->pass=$pass; $this->database=$database; $this->ut=$ut; $this->connect(); } function connect(){ $link=mysql_connect($this->host,$this->name,$this->pass) or die ($this->error()); mysql_select_db($this->database,$link) or die("û����ݿ⣺".$this->database); mysql_query("SET NAMES '$this->ut'"); } function query($sql, $type = '') { if(!($query = mysql_query($sql))) $this->show('Say:', $sql); return $query; } function show($message = '', $sql = '') { if(!$sql) echo $message; else echo $message.' '.$sql; } function affected_rows() { return mysql_affected_rows(); } function result($query, $row) { return mysql_result($query, $row); } function num_rows($query) { return @mysql_num_rows($query); } function num_fields($query) { return mysql_num_fields($query); } function free_result($query) { return mysql_free_result($query); } function insert_id() { return mysql_insert_id(); } function fetch_row($query) { return mysql_fetch_row($query); } function version() { return mysql_get_server_info(); } function close() { return mysql_close(); } function htmtocode($content){ $content=str_replace("n"," ",str_replace(" "," ",$content)); return $content; } } $db=new mysql("localhost","root","","database","utf8"); ?> |