<p>class mysql{<br />
private $host;<br />
private $name;<br />
private $pass;<br />
private $table;<br />
private $ut;<br />
function __construct($host,$name,$pass,$table,$ut){<br />
$this->host=$host;<br />
$this->name=$name;<br />
$this->pass=$pass;<br />
$this->table=$table;<br />
$this->ut=$ut;<br />
$this->connect();<br />
<br />
}<br />
<br />
function connect(){<br />
$link=mysql_connect($this->host,$this->name,$this->pass) or die ($this->error());<br />
mysql_select_db($this->table,$link) or die("没该数据库:".$this->table);<br />
mysql_query("SET NAMES '$this->ut'");<br />
}<br />
<br />
function query($sql, $type = '') {<br />
if(!($query = mysql_query($sql))) $this->show('Say:', $sql);<br />
return $query;<br />
}<br />
<br />
function show($message = '', $sql = '') {<br />
if(!$sql) echo $message;<br />
else echo $message.'<br />
'.$sql;<br />
}<br />
<br />
function affected_rows() {<br />
return mysql_affected_rows();<br />
}<br />
<br />
function result($query, $row) {<br />
return mysql_result($query, $row);<br />
}<br />
<br />
function num_rows($query) {<br />
return @mysql_num_rows($query);<br />
}<br />
<br />
function num_fields($query) {<br />
return mysql_num_fields($query);<br />
}<br />
<br />
function free_result($query) {<br />
return mysql_free_result($query);<br />
}<br />
<br />
function insert_id() {<br />
return mysql_insert_id();<br />
}<br />
<br />
function fetch_row($query) {<br />
return mysql_fetch_row($query);<br />
}<br />
<br />
function version() {<br />
return mysql_get_server_info();<br />
}<br />
<br />
function close() {<br />
return mysql_close();<br />
}<br />
<br />
//==============<br />
function fn_insert($table,$name,$value){<br />
<br />
$this->query("insert into $table ($name) value ($value)");<br />
<br />
}<br />
}<br />
<br />
$db = new mysql('localhost','root','','php100job_db',"GBK");<br />
//$db->fn_insert('test','id,title,dates',"'','我插入的信息',now()");</p>