首页 > 代码库 > mysql类
mysql类
class mysql extends db { private static $ins = NULL; private $conn = NULL; private $conf = array(); protected function __construct() { $this->conf = conf::getIns(); $this->connect($this->conf->host,$this->conf->user,$this->conf->pwd); $this->select_db($this->conf->db); $this->setChar($this->conf->char); } public static function getIns() { if(!(self::$ins instanceof self)) { self::$ins = new self(); } return self::$ins; } public function connect($h,$u,$p) { $this->conn = mysql_connect($h,$u,$p); if(!$this->conn) { $err = new Exception(‘连接失败‘); throw $err; } } protected function select_db($db) { $sql = ‘use ‘ . $db; $this->query($sql); } protected function setChar($char) { $sql = ‘set names ‘ . $char; return $this->query($sql); } public function query($sql) { $rs = mysql_query($sql,$this->conn); log::write($sql); return $rs; } public function autoExecute($table,$arr,$mode=‘insert‘,$where = ‘ where 1 limit 1‘) { /* insert into tbname (username,passwd,email) values (‘‘,) /// 把所有的键名用‘,‘接起来 // implode(‘,‘,array_keys($arr)); // implode("‘,‘",array_values($arr)); */ if(!is_array($arr)) { return false; } if($mode == ‘update‘) { $sql = ‘update ‘ . $table .‘ set ‘; foreach($arr as $k=>$v) { $sql .= $k . "=‘" . $v ."‘,"; } $sql = rtrim($sql,‘,‘); $sql .= $where; return $this->query($sql); } $sql = ‘insert into ‘ . $table . ‘ (‘ . implode(‘,‘,array_keys($arr)) . ‘)‘; $sql .= ‘ values (\‘‘; $sql .= implode("‘,‘",array_values($arr)); $sql .= ‘\‘)‘; return $this->query($sql); } public function getAll($sql) { $rs = $this->query($sql); $list = array(); while($row = mysql_fetch_assoc($rs)) { $list[] = $row; } return $list; } public function getRow($sql) { $rs = $this->query($sql); return mysql_fetch_assoc($rs); } public function getOne($sql) { $rs = $this->query($sql); $row = mysql_fetch_row($rs); return $row[0]; } // 返回影响行数的函数 public function affected_rows() { return mysql_affected_rows($this->conn); } // 返回最新的auto_increment列的自增长的值 public function insert_id() { return mysql_insert_id($this->conn); }}
mysql类
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。