OOP面向对象-用PDO类连接数据库

增删改

//连接数据库
$pdo = new PDO('mysql:host=localhost;dbname=user','root','root');

//设置字符集
$pdo->query('set names utf8');

//添加
//$sql = "insert into info (name,sex,age)values('CC','女','18')";
//$rows = $pdo->exec($sql);//影响行数
//$id = $pdo->lastInsertId();//返回自增id

//删除
//$sql = "delete from info where id = 51 ";
//$rows = $pdo->exec($sql);

//修改
$sql = "update info set name='vv' where id=42";
$rows = $pdo->exec($sql);

if(!$rows){
    echo "失败";die;
}

查

//连接数据库
$pdo = new PDO('mysql:host=localhost;dbname=user','root','root');

//设置字符集
$pdo->query('set names utf8');

//sql语句
$sql = "select * from info";
$result = $pdo->query($sql);

$list = $result->fetch(PDO::FETCH_BOTH);//返回单条
$lists = $result->fetchAll(PDO::FETCH_ASSOC);//返回多条
//FETCH_ASSOC  关联数组
//FETCH_NUM 索引数组
//FETCH_BOTH 混合数组