无详细内容 mysql ?php class mysql {private $host;private $user;private $pwd;private $dbname;private $charset;private $conn = null;public function __construct() {$this-host = 'localhost';$this-user = 'root';$this-pwd = 'root';$this-dbname =
mysql host = 'localhost'; $this->user = 'root'; $this->pwd = 'root'; $this->dbname = 'test'; $this->connect($this->host,$this->user,$this->pwd); $this->switchdb($this->dbname); $this->setchar($this->charset); } //负责链接 private function connect($h,$u,$p) { $conn = mysql_connect($h,$u,$p); $this->conn = $conn; } //负责切换数据库 public function switchdb($db) { $sql = 'use' . $db; $this->query($sql); } //负责设置字符集 public function setchar($char) { $sql = 'set names' . $char; $this->query($sql); } //负责发送sql查询 public function query($sql) { return mysql_query($sql,$this->conn); } //负责获取多行多列的select结果 public function getall($sql) { $list = array(); $rs = $this->query($sql); if (!$rs) { return false; } while ($row = mysql_fetch_assoc($rs)) { $list[] = $row; } return $list; } public function getrow($sql) { $rs = $this->query($sql); if(!$rs) { return false; } return mysql_fetch_assoc($rs); } public function getone($sql) { $rs = $this->query($sql); if (!$rs) { return false; } return mysql_fetch_assoc($rs); return $row[0]; } public function close() { mysql_close($this->conn); }}echo '';$mysql = new mysql();print_r($mysql);$sql = insert into stu values (4,'wangwu','99998');if($mysql->query($sql)){ echo query成功;}else { echo 失败;}echo
;$sql = select * from stu;$arr = $mysql->getall($sql);print_r($arr);?>