<?php
//case 36 预处理语句
/**
* 建表sql语句
*create table emp_books(
book_id int unsigned auto_increment primary key,
book_name varchar(20) not null comment '书名',
book_author varchar(15) comment '作者',
pub_time varchar(10) comment '出版日期'
)charset = utf8;
*
* insert into emp_books values(1,'PHP程序设计基础教程','虾米大王产品研发部','2020/08');
insert into emp_books values(2,'PHP程序设计高级教程','虾米大王产品研发部','2020/09');
insert into emp_books values(3,'MySQL数据库入门教程','虾米大王产品研发部','2020/07');
insert into emp_books values(4,'Java入门基础','虾米大王产品研发部','2020/01');
*/
header('content-type:text/html;charset=utf-8');
try
{
//实例化
$pdo = new PDO('mysql:host=localhost;dbname=test;charset=utf8','root','mysql123');
//占位符方式一,?
$stmt = $pdo->prepare('insert into emp_books(`book_name`,`book_author`) values(?,?)');
$stmt->bindParam(1,$name);
$stmt->bindParam(2,$author);
//占位符方式二,:变量名,两种方式不可混用,注意字符的中英文状态
//$stmt = $pdo->prepare('insert into emp_books(`book_name`,`book_author`) values(:book_name,:book_author)');
//$stmt->bindParam(':book_name',$name);
//$stmt->bindParam(':book_author',$author);
$data = array(
array('PHP第一本教材','虾米大王研发部'),
array('PHP第二本教材','虾米大王研发部'),
array('PHP第三本教材','虾米大王研发部'),
array('PHP第四本教材','虾米大王研发部')
);
foreach ($data as $row)
{
$name = $row[0];
$author = $row[1];
$stmt->execute();
}
}
catch (PDOException $ex)
{
echo $ex->getMessage().'<br>';
}
$sql = "select * from emp_books";
$result = $pdo->query($sql);
$book_info = array();
while($row = $result->fetch())
{
$book_info[] = $row;
}
?>
<html>
<head>
<title>预处理语句</title>
</head>
<body>
<h2>书籍信息列表</h2>
<table border="1" style="text-align: center;width:50%;">
<tr>
<td>书名</td>
<td>作者</td>
<td>出版日期</td>
</tr>
<?php foreach ($book_info as $row):?>
<tr>
<td><?= $row['book_name'];?></td>
<td><?= $row['book_author'];?></td>
<td><?= $row['pub_time'];?></td>
</tr>
<?php endforeach;?>
</table>
</body>
</html>