1 <?php 2 $dbh = new PDO('mysql:host=localhost;dbname=access_control', 'root', '');   3 $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);   4 $dbh->exec('set names utf8');  5 /*添加*/ 6 //$sql = "INSERT INTO `user` SET `login`=:login AND `password`=:password";  7 $sql = "INSERT INTO `user` (`login` ,`password`)VALUES (:login, :password)";  $stmt = $dbh->prepare($sql);  $stmt->execute(array(':login'=>'kevin2',':password'=>''));   8 echo $dbh->lastinsertid();   9 /*修改*/10 $sql = "UPDATE `user` SET `password`=:password WHERE `user_id`=:userId";  11 $stmt = $dbh->prepare($sql);  12 $stmt->execute(array(':userId'=>'7', ':password'=>'4607e782c4d86fd5364d7e4508bb10d9'));  13 echo $stmt->rowCount(); 14 /*删除*/15 $sql = "DELETE FROM `user` WHERE `login` LIKE 'kevin_'"; //kevin%  16 $stmt = $dbh->prepare($sql);  17 $stmt->execute();  18 echo $stmt->rowCount();  19 /*查询*/20 $login = 'kevin%';  21 $sql = "SELECT * FROM `user` WHERE `login` LIKE :login";  22 $stmt = $dbh->prepare($sql);  23 $stmt->execute(array(':login'=>$login));  24 while($row = $stmt->fetch(PDO::FETCH_ASSOC)){     25  print_r($row);  26 }  27 print_r( $stmt->fetchAll(PDO::FETCH_ASSOC)); 28 ?>