尉睹晌唉葛交筐维供参垄盗梆
表结构:
新建pdo_pre_insert-1.php
代码:
<?php //1.连接数据库,创建PDO对象 $pdo = new PDO('mysql:dbname=myuser', 'root', 'root'); //2.创建pdo预处理对象 $stmt=$pdo->prepare("insert user set `name`=:name,`email`=:email,`password`=sha1(:password)"); //3.执行新增操作 $stmt->execute()读与写都是这个函数 $stmt->execute(['name'=>'小龙女','email'=>'xln@123.com','password'=>'123']);//成功返回true 失败返回false echo "成功的添加了:".$stmt->rowCount()."条记录<br>";
执行:
小龙女被成功插入
修改代码:
<?php //1.连接数据库,创建PDO对象 $pdo = new PDO('mysql:dbname=myuser', 'root', 'root'); //2.创建pdo预处理对象 $stmt=$pdo->prepare("insert user set `name`=:name,`email`=:email,`password`=sha1(:password)"); //3.执行新增操作 $stmt->execute()读与写都是这个函数 $stmt->execute(['name'=>'老顽童','email'=>'lwt@123.com','password'=>'123']);//成功返回true 失败返回false echo "成功的添加了:".$stmt->rowCount()."条记录<br>"; $stmt->execute(['name'=>'欧阳克','email'=>'oyk@123.com','password'=>'123']);//成功返回true 失败返回false echo "成功的添加了:".$stmt->rowCount()."条记录<br>";
执行:
$stmt=$pdo->prepare(“insert user set `name`=:name,`email`=:email,`password`=sha1(:password)”);
还可以写作:
$stmt=$pdo->prepare(“insert user set name=:name,email=:email,password=sha1(:password)”);
杭慷娠凰贫妮萎犁侗镁匪懈检