自己写的php mysql类 备份下 class db_mysql{ public $link,$key,$values,$error,$return; function __construct($host,$user,$pw,$db,$encode){ $this->connect($host,$user,$pw,$db,$encode); } function __destruct(){ if (is_resource($this->link)){ mysql_close($this->link); } } function connect($host,$user,$pw,$db,$encode){ if (!$this->link = @mysql_connect($host,$user,$pw)){ $this->error = mysql_error(); } if (!@mysql_select_db($db,$this->link)){ $this->error = 'Unknown MySQL database /''.$db.'/''; } if (!@mysql_query("SET NAMES '".$encode."'",$this->link)){ $this->error = mysql_error(); } } function query($sql){ $result = mysql_query($sql,$this->link); if (is_resource($result)){ $this->return = array(); while($tmp = mysql_fetch_array($result)){ $this->return[] = $tmp; } } else { $this->return = $result; } } function format($arr){ $len = sizeof($arr); for($i=0;$i<$len;$i++){ $tmp = each($arr); $mark = $i !== $len-1 ? ',' : NULL; $this->keys .= $tmp['key'].$mark; $this->values .= '"'.mysql_real_escape_string($tmp['value']).'"'.$mark; } } }