php mysql PDO基本操作
2024-08-24 07:27:57
<?php
$dbh = new PDO('mysql:host=localhost;dbname=localhost', 'root', '');
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbh->exec('set names utf8');
/*添加*/
//$sql = "INSERT INTO `user` SET `login`=:login AND `password`=:password";
$sql = "INSERT INTO `user` (`login` ,`password`)VALUES (:login, :password)";
$stmt = $dbh->prepare($sql);
$stmt->execute(array(':login'=>'admin1',':password'=>''));
echo $dbh->lastinsertid();
/*修改*/
$sql = "UPDATE `user` SET `password`=:password WHERE `user_id`=:userId";
$stmt = $dbh->prepare($sql);
$stmt->execute(array(':userId'=>'', ':password'=>'4607e782c4d86fd5364d7e4508bb10d9'));
echo $stmt->rowCount();
/*删除*/
$sql = "DELETE FROM `user` WHERE `login` LIKE 'admin_'"; //admin%
$stmt = $dbh->prepare($sql);
$stmt->execute();
echo $stmt->rowCount();
/*查询*/
$login = 'admin%';
$sql = "SELECT * FROM `user` WHERE `login` LIKE :login";
$stmt = $dbh->prepare($sql);
$stmt->execute(array(':login'=>$login));
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
print_r($row);
}
print_r( $stmt->fetchAll(PDO::FETCH_ASSOC));
?>
最新文章
- mysql配置远程连接方法之一(改表法)
- git使用简单教程
- Java 验证码、二维码
- LightOJ1170 - Counting Perfect BST(卡特兰数)
- 设置Linux下Mysql表名不区分大小写
- Rank() over(partition ... 分组统计的实例
- Java邮件开发(JavaMail)
- HDOJ1021题 Fibonacci Again 应用求模公式
- 【转】SVN linux命令及 windows相关操作(二)
- Adapter 模式
- 字符串查找 strstr
- Git 笔记二-Git安装与初始配置
- Linux_System2
- 实例:基于ListActivity实现列表
- Mongodb系列之--mongodb的启动与关闭
- Debian 命令行方式配置网络
- C博客作业01--分支,顺序结构
- hdu 4339 Query(两种思路求解)
- 吴恩达-coursera-机器学习-week8
- Android沉浸式状态栏兼容4.4手机的实现