实例
<?php
$servername = "localhost";
$username = "root";
$password = "5ac7b1e1ea6eb77f";
$dbname = 'mysqls';
//PDO使用预处理语句批量插入数据
try{
$sql = new PDO("mysql:host=$servername;dbname=$dbname",$username,$password);
$sql->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$stmt = $sql->prepare('INSERT INTO mypdo (id,name) VALUES (:id,:name)');//初始化并定义预处理语句
$stmt->bindparam(':id',$id); //绑定参数
$stmt->bindparam(':name',$name);
$id = 2;
$name = 'php';
$stmt->execute();
$id = 3;
$name = 'echo';
$stmt->execute();
echo '使用预处理语句插入数据成功';
}catch(PDOException $e){
echo 'ERROR:'.$e->getMessage();
}
$stmt = null;
$sql = null;运行结果
数据库截图






还没有评论,来说两句吧...