dbh = new PDO($dsn, $user, $password,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8';"));
} catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
}
}
public function sRow($sql){
$sth = $this->dbh->prepare($sql);
$sth->execute();
$ret = $sth->fetchAll(PDO::FETCH_ASSOC);
return $ret[0];
}
public function sRows($sql){
$sth = $this->dbh->prepare($sql);
$sth->execute();
return $sth->fetchAll(PDO::FETCH_ASSOC);
}
public function dbInsert($sql){
$sth = $this->dbh;
$count = $sth->exec($sql);
if($count){
return true;
}else {
return false;
}
}
//insert update
public function dbIUD($sql){
$sth = $this->dbh;
$count = $sth->exec($sql);
if($count){
return true;
}else {
return false;
}
}
}
php免费学习视频：立即使用
踏上前端学习之旅，开启通往精通之路！从前端基础到项目实战，循序渐进，一步一个脚印，迈向巅峰！
