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;

}

}

}

?>