亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

PDO預(yù)處理對(duì)數(shù)據(jù)操作

增：insert

$username = '劉德華';
$password = password_hash('123456', PASSWORD_BCRYPT);
$sql = "INSERT `iuser` SET `username`= :username,`password`= :password ";
$stmt = $db->prepare($sql);
$stmt->bindValue(":username",$username);
$stmt->bindValue(":password",$password);
$stmt->debugDumpParams();
$stmt->execute();

sql語句打印結(jié)果：（添加成功）

SQL: [63] INSERT `iuser` SET `username`= :username,`password`= :password Params: 2
Key: Name: [9] :username paramno=-1 name=[9] ":username" is_param=1 param_type=2
Key: Name: [9] :password paramno=-1 name=[9] ":password" is_param=1 param_type=2

改：update

$username = '劉德華';
$email = '123456@qq.com';
$sql = "UPDATE `iuser` SET `email`=:email WHERE `username`=:username";
$stmt = $db->prepare($sql);
$stmt->bindValue(":email",$email);
$stmt->bindValue(":username", $username);
$stmt->debugDumpParams();
$stmt->execute();

sql語句打印結(jié)果：（修改成功）

SQL: [60] UPDATE `iuser` SET `email`=:email WHERE `username`=:username Params: 2 Key: Name: [6] :email paramno=-1 name=[6] ":email" is_param=1 param_type=2 Key: Name: [9] :username paramno=-1 name=[9] ":username" is_param=1 param_type=2

查：select

$sql = 'SELECT id,username FROM iuser WHERE id > ?';
$stmt = $db->prepare($sql);
if ($stmt->execute([3])) {
$users = $stmt->fetchAll();
foreach ($users as $user) {
extract($user);
vprintf("%d: %s\n", [$id, $username]);
}
} else {
die('查詢失?。? . $stmt->errorInfo());
}

查詢結(jié)果：

4: 西門慶 5: 易烊千璽 6: 劉德華

刪：delete

$sql = 'delete from iuser where id = ?';
if (!stristr($sql, 'where')) {
die('禁止無條件刪除');
}
$stmt = $db->prepare($sql);
if ($stmt->execute([6])) {
// $stmt->debugDumpParams();
// die;
if ($stmt->rowCount() > 0) {
    echo '刪除成功';
} else {
    echo '沒有記錄被刪除';
}
} else {
die('刪除失敗: ' . $stmt->errorInfo());
}

刪除成功。

總結(jié)：

數(shù)據(jù)庫操作確實(shí)有點(diǎn)麻煩，稍有差錯(cuò)就失敗了；？替代只會(huì)execute時(shí)傳參，：username可以綁定；用的時(shí)候再多練吧！

批改老師：PHPz

批改狀態(tài)：合格

老師批語：