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 "); ?>
|