MySQL用于PHP的库阳飞.doc

MySQL用于PHP的库, 对数据库进行操作 中国PHP自由联盟??2004-10-28 16:39:28 ? /* * Utility routines for MySQL. */ class MySQL_class { var $db, $id, $result, $rows, $data, $a_rows; var $user, $pass, $host; /* Make sure you change the USERNAME and PASSWORD to your name and * password for the DB */ function Setup ($user, $pass) { $this-user = $user; $this-pass = $pass; } function Create ($db) { if (!$this-user) { $this-user = USERNAME; /* 在这里作修改 */ } if (!$this-pass) { $this-pass = PASSWORD; /* 在这里作修改 */ } $this-db = $db; $this-id = @mysql_pconnect($this-host, $this-user, $this-pass) or MySQL_ErrorMsg(Unable to connect to MySQL server: $this-host : $SERVER_NAME); $this-selectdb($db); } function SelectDB ($db) { @mysql_select_db($db, $this-id) or MySQL_ErrorMsg (Unable to select database: $db); } # Use this function is the query will return multiple rows. Use the Fetch # routine to loop through those rows. function Query ($query) { $this-result = @mysql_query($query, $this-id) or MySQL_ErrorMsg (Unable to perform query: $query); $this-rows = @mysql_num_rows($this-result); $this-a_rows = @mysql_affected_rows($this-result); } # Use this function if the query will only return a # single data element. function QueryItem ($query) { $this-result = @mysql_query($query, $this-id) or MySQL_ErrorMsg (Unable to perform query: $query); $this-rows = @mysql_num_rows($this-result); $this-a_rows = @mysql_affected_rows($this-result); $this-data = @mysql_fetch_array($this-result) or MySQL_ErrorMsg (Unable to fetch data from query: $query); return($this-data[0]); } # This function is useful if the query will only return a # single row. function QueryRow ($query) { $this-result = @mysql_query($query, $this-id) or MySQL_ErrorMsg (Unable to perform query: $query); $this-rows = @mysql_num_rows($this-result); $this-a_rows = @mysql_affected_rows($this-result); $this-data = @mysql_fetch_array($this-result) or MySQL_ErrorMsg (Unable to fetch data from query