步驟

//1.鏈接pdo//2.使用query設置字符集//3.寫出sql語句//4.預處理prepare$stmt//5.執行execute語句sql//6.取回fetch//7.數量的計數$rows = $stmt->rowCount();

記憶

$pdo = new PDO("mysql:host=localhost;dbname=test1", "root", "root",array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)); $pdo->query("set names utf8"); $sql = "select price from shop_product where id=?"; $stmt = $pdo->prepare($sql); $stmt->execute([$productid]); $data = $stmt->fetch(PDO::FETCH_ASSOC);

代碼?

<?php // 1.接受數據 // 2.處理數據 // 3.完成添加 // 4.返回結果$productid = intval($_POST['productid']); $num = intval($_POST['num']);session_start();$userid = 1;try {//1.鏈接pdo//2.使用query設置字符集//3.寫出sql語句//4.預處理prepare//5.執行execute//6.取回fetch$pdo = new PDO("mysql:host=localhost;dbname=test1", "root", "root",array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));$pdo->query("set names utf8");$sql = "select price from shop_product where id=?";$stmt = $pdo->prepare($sql);$stmt->execute([$productid]);$data = $stmt->fetch(PDO::FETCH_ASSOC);$price = $data['price'];$create = time();$sql = "select * from shop_cart where productid=?";$stmt = $pdo->prepare($sql);$stmt->execute([$productid]);$data = $stmt->fetch(PDO::FETCH_ASSOC);$originnum = $data['num'];$rows = $stmt->rowCount();//如果之前有的話if ($rows) {$sql = "update shop_cart set num=? where productid=?";$stmt = $pdo->prepare($sql);$nownum = $originnum + $num;$stmt->execute([$nownum, $productid]);$rows = $stmt->rowCount();res($rows, []);} else {//如果之前沒有的話$sql = "insert into shop_cart (id,productid,userid,num,price,createtime) values(?,?,?,?,?,?)";$stmt = $pdo->prepare($sql);$stmt->execute([null, $productid, $userid, $num, $price, $create]);$rows = $stmt->rowCount();res($rows, $data);} } catch (PDOException $e) {echo $e->getMessage(); }function res($rows, $data) {if ($rows) {$response = ["code" => 1,"mes" => "success","price" => $data];echo json_encode($response);die();} else {$response = ["code" => 0,"mes" => "fail"];echo json_encode($response);die();} }

?

總結

以上是生活随笔為你收集整理的PHP的PDO方式的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。