PDO預(yù)處理對(duì)數(shù)據(jù)的增刪查改

1.增

$sql = "INSERT INTO T_product (proid,proname,price,description) VALUES (?,?,?,?)";
// 預(yù)處理要執(zhí)行的語(yǔ)句
$stmt = $dbh->prepare($sql);
$proid = '120019';
$proname = '筆記本';
$price = 12800;
$description = '華碩筆記本,高配置';
$flag = $stmt->execute([$proid,$proname,$price,$description]);
if($flag){
    echo '添加成功'.$dbh->lastInsertId();
}else{
    echo '添加失敗';
    die();
}

2. 刪除

<?php
//預(yù)處理sql語(yǔ)句
$sql = 'DELETE from T_product WHERE id=?';
//準(zhǔn)備要執(zhí)行的語(yǔ)句
$stmt = $dbh->prepare($sql);
$delid = 2;
$flag= $stmt->execute([$delid]);
if($flag){
    echo '刪除成功';
}else{
    echo '刪除失敗';
    die(;)
}

3. 查

$sql = 'SELECT * FROM T_product  WHERE id>?';
$stmt = $dbh->prepare($sql);
$selectid = 1;
$stmt->execute([$selectid]);
$res = $stmt->fetchAll();
if ($res){
    print_r($res);
}else{
    die('查詢失敗');
}

4. 改

$sql = 'UPDATE T_product SET proid=?,proname=?,price=? WHERE id=?';
$stmt = $dbh->prepare($sql);
$proid = '120016';
$proname = '手機(jī)';
$price = 2600;
$updateid=1;
$flag = $stmt->execute([$proid,$proname,$price,$updateid]);
if($flag){
    echo '更新成功';
}else{
    die('更新失敗');
}

批改老師：PHPz

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

老師批語(yǔ)：