收藏
批改狀態(tài)：合格
老師批語(yǔ)：
PDO實(shí)現(xiàn)刪除操作
操作流程
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<title> PDO實(shí)現(xiàn)刪除操作</title>
<style type="text/css">
.box {width:90%;line-height:1.2em;border:1px dotted #d6d6d6;padding-left:15px;background-color:#f5f5f5;margin:10px auto;font-family:微軟雅黑;}
.box1 {width:90%;line-height:1.5em;border:1px dotted #d6d6d6;background-color:#f2edd7;font-family:微軟雅黑;}
.box p {margin-left:20px;font-size:14px;}
hr {height:1px;width:95%;border:none;border-top:1px dashed #666;}
</style>
</head>
<body>
<?php
echo '<div class="box">';
echo '<h4>用預(yù)處理方法完成修改操作</h4>';
echo '<div class="box1">';
echo '步驟:<br>
* 1.連接數(shù)據(jù)庫(kù),創(chuàng)建PDO對(duì)象<br>
* 2.準(zhǔn)備預(yù)處理SQL語(yǔ)句,占位符使用命名參數(shù)格式:<br>
* 3.創(chuàng)建PDO預(yù)處理對(duì)象: PDOStatement的實(shí)例<br>
* 4.綁定參數(shù)到SQL語(yǔ)句對(duì)象,預(yù)預(yù)處理對(duì)象<br>
* 5.執(zhí)行新增操作(PDO中,讀寫(xiě)都用execute())<br>
* 6.銷毀PDO對(duì)象(可選)';
echo '</div>';
echo "<br>";
echo '<div class="box1">
<p>1. 連接數(shù)據(jù)庫(kù),創(chuàng)建PDO對(duì)象</p>';
echo "<hr>";
echo "<p>\$pdo = new PDO('mysql:dbname=php', 'root', 'root');</p>";
echo "<br>";
echo '<p>2. 準(zhǔn)備預(yù)處理SQL語(yǔ)句,占位符使用命名參數(shù)格式:</p>';
echo "<hr>";
echo "<p>\$sql = \"DELETE FROM staff WHERE `staff_id`=:id;\";</p>";
echo "<br>";
echo '<p>3. 創(chuàng)建PDO預(yù)處理對(duì)象</p>';
echo "<hr>";
echo "<p>\$stmt = \$pdo->prepare(\$sql);</p>";
echo "<br>";
echo '<p>4. 綁定參數(shù)并執(zhí)行SQL語(yǔ)句</p>';
echo "<hr>";
echo "<p>\$data = ['id'=>'9'];</p>";
echo "<p>直接給execute()傳參數(shù),省去參數(shù)綁定語(yǔ)句 </p>";
echo "<p>\$stmt->execute(\$data); </p>";
echo "<p> '成功刪除了'.\$stmt->rowCount().'條記錄';</p>";
echo "<br>";
echo "<br>";
echo '</div>';
echo "<br>";
?>
</body>
</html>點(diǎn)擊 "運(yùn)行實(shí)例" 按鈕查看在線實(shí)例
PHP 代碼
<?php
//1.連接數(shù)據(jù)庫(kù),創(chuàng)建PDO對(duì)象
$pdo = new PDO('mysql:dbname=php', 'root', 'root');
//2.準(zhǔn)備預(yù)處理SQL語(yǔ)句,占位符使用命名參數(shù)格式:
// $sql = "INSERT `staff` SET `staff_id`=:id";
$sql = "DELETE FROM staff WHERE `staff_id`=:id;";
//3.創(chuàng)建PDO預(yù)處理對(duì)象
$stmt = $pdo->prepare($sql);
//4.綁定參數(shù)并執(zhí)行SQL語(yǔ)句
$data = ['id'=>'9'];
//可直接給execute()傳參數(shù),省去參數(shù)綁定語(yǔ)句
$stmt->execute($data);
echo '<h3>成功刪除了'.$stmt->rowCount().'條記錄</h3>';點(diǎn)擊 "運(yùn)行實(shí)例" 按鈕查看在線實(shí)例
微信掃碼
關(guān)注PHP中文網(wǎng)服務(wù)號(hào)
技術(shù)交流群
QQ掃碼
加入技術(shù)交流群
Copyright 2014-2025 http://ipnx.cn/ All Rights Reserved | php.cn | 湘ICP備2023035733號(hào)