个人小总结,留着用
/*
CREATE TABLE `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
*/
$db=new PDO('mysql:dbname=dbname;host=127.0.0.1','root','123456');
$db->exec("set names utf8");
//增
$name1='测试的例子love1';
$name2='测试的例子love2';
$add=$db->prepare("insert into test(name) values(?),(?)");
$add->execute(array($name1,$name2));
//删
$id=1;
$delete=$db->prepare("delete from test where id=$id");
$delete->execute();
//改
$id2=4;
$nameupdate='修改后的';
$update=$db->prepare("update test set name=? where id=?");
$update->execute(array($nameupdate,$id2));
//查
$limit =3;
$list=$db->query("select id,name from test limit $limit")->fetchAll();
foreach($list as $v){
echo $v['id'].'--'.$v['name']."\r\n";
}