<?php
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.'<br>'.$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","<br>",str_replace(" "," ",$content));
return $content;
}
}
$db=new mysql("localhost","root","","database","utf8");
?>
|