写一个mysql类

最新推荐文章于 2024-09-14 19:55:29 发布

weixin_33916256

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量80

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/hfframework/blog/816349

版权

2019独角兽企业重金招聘Python工程师标准>>>

class MySQL {
public $link = null;
public function conn() {
$cfg = array(
'host'=>'localhost',
'user'=>'root',
'password'=>'',
'db'=>'test',
'charset'=>'utf8',
);
$this->link = mysqli_connect($cfg['host'] , $cfg['user'] , $cfg
['password'],$cfg['db']);
}
public function query($sql) {
return mysqli_query($this->link,$sql);
}
public function getAll($sql) {
$rs = $this->query($sql);
$data = array();
while($row = mysqli_fetch_assoc($rs)) {
$data[] = $row;
}
return $data;
}
}
$db = new MySQL();
$db->conn();
$user = $db->getAll('select * from user');
var_dump($user)

转载于:https://my.oschina.net/hfframework/blog/816349