<?php
echo '<pre>';
require_once '22-1singleton单例创建PDO对象.php'; //引入单例模式的php文件
$pdo=singletonPDO::getPdo();
$pdo->exec('set names utf8');
//增加
$sql="insert into userinfo values('xiaohei','521123')";
//删除
//$sql="delete from userinfo where username='leon'";
//修改
//$sql="update userinfo set username='fanbingbing',password='888' where username='xiaohong'";
if($pdo->exec($sql)){
echo '操作成功';
}else{
echo '操作失败';
}
//查询
//$sql="select * from userinfo where 1";
$result=$pdo->exec($sql);
var_dump($result);
?>
<?php
class singletonPDO{
private static $pdo=null;
public static function getPdo(){
if(self::$pdo==null){ //self访问静态 并判断
try{
self::$pdo=new PDO('mysql:host=localhost;dbname=librarydb','root','');
self::$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
}catch(PDOException $e){
echo '连接错误信息为:'.$e->getMessage();
}
}
return self::$pdo;
}
}
?>

老师,我这往进添加的时候,为啥总是两行两行的添加,怎么回事??