php 数据查询与连接类

php 数据查询与连接类

?php/*** Class program for yinghua05-2* designer :songsong*/

class MySQL {var $link;var $result;var $querys;function MySQL($host =
”, $user = ”, $pw = ”, $db = ”, $encode = ‘UTF8’) {$this-querys =
0;if($host != ” $user != ” $db != ”)
{$this-connect($host,$user,$pw,$db,$encode);}}/** * connect to
database * * @param unknown_type $host * @param unknown_type $user
* @param unknown_type $pw * @param unknown_type $db * @return
boolean */function connect($host,$user,$pw,$db,$encode = ‘UTF8’)
{$resource = mysql_connect($host,$user,$pw);if(is_resource($resource))
{$this-link = $resource;if(mysql_select_db($db,$this-link))
{unset($resource);if (floatval(mysql_get_server_info($this-link)) 4.1
isset($encode)) {mysql_query(‘SET NAMES ‘.$encode.”);}return true;}
else {unset($resource);return false;}} else {unset($resource);return
false;}}/** * query sql * * @param unknown_type $query * @return
unknown */function query($query) {$result =
mysql_query($query,$this-link);$this-querys ++;if($result)
{$this-result = $result;return true;} else {return false;}}/** *
fetch a row * * @return mixed */function fetch()
{if(is_resource($this-result)) {return
mysql_fetch_array($this-result);} else {return false;}}/** * fetch
all result *澳门新葡亰手机版, * @return mixed */function fetchAll()
{if(is_resource($this-result)) {$temp = array();while ($row =
mysql_fetch_array($this-result)) {$temp[] = $row;}return $temp;}
else {return false;}}/** * return the querys * * @return integer
*/function getQuerys() {return $this-querys;}/** * get the numbers
of the result * * @return int */function getNumberRow() {if
(is_resource($this-result)) {return mysql_num_rows($this-result);}
else {return 0;}}/** * free result * * @return boolean */function
free() {if(is_resource($this-result))
{mysql_free_result($this-result);return true;} else {return
false;}}/** * close mysql connect * * @return boolean */function
close() {if(is_resource($this-link)) {mysql_close($this-link);return
true;} else {return false;}}}

?