<form action=”bookDel.php” method=”post”>
<input type=”submit” value=”批量删除”>
......
<tr>
<td><input type="checkbox" value="<?php echo $row['bookName']?>" name="id"></td>
<td><?php echo $row['bookName']?></td>
<td><?php echo $row['bookAuthor']?></td>
<td><?php echo $row['bookPress']?></td>
<td><?php echo $row['bookPrice']?></td>
<td><?php echo $row['bookISBN']?></td>
<td>
<a href="BookEdit.php?bid=<?php echo $row['bookId']?>">修改</a> |
</td>
</tr>
<?php
$ids = $_POST["bid"];
$db = new pdo("mysql:host=localhost;dbname=db_student","root","123456");
$st = $db->prepare("delete from book where find_in_set(bookId,?)");
$st->bindParam(1,$ids);
$st->execute();
?>
评论0
最新资源