????：創(chuàng)建一張表：money//1.創(chuàng)建PDO對象，連接數據庫$pdo = new PDO('mysql:host=127.0.0.1;dbname=web','root','root');/* 添加數據//2.創(chuàng)建sql語句$sql = 'insert into `money` (`username`,`balance`,`province`,`

創(chuàng)建一張表：money

//1.創(chuàng)建PDO對象，連接數據庫

$pdo = new PDO('mysql:host=127.0.0.1;dbname=web','root','root');

/* 添加數據

//2.創(chuàng)建sql語句

$sql = 'insert into `money` (`username`,`balance`,`province`,`age`,`sex`) values (:name,:balance,:province,:age,:sex)';

//3.驗證sql語句，創(chuàng)建預處理對象

$stmt = $pdo->prepare($sql);

// var_dump($stmt);

//4.參數綁定

$name = '歐陽鋒';

$balance = 234.44;

$province = '陜西';

$age = 50;

$sex = 1;

$stmt->bindParam(':name',$name,PDO::PARAM_STR,20);

$stmt->bindParam(':balance',$balance,PDO::PARAM_STR,20);

$stmt->bindParam(':province',$province,PDO::PARAM_STR,20);

$stmt->bindParam(':age',$age,PDO::PARAM_INT);

$stmt->bindParam(':sex',$sex,PDO::PARAM_INT);

//5.執(zhí)行添加

//規(guī)范寫法

if ($stmt->execute()){

echo ($stmt->rowCount()>0) ? '成功添加'.$stmt->rowCount().'條記錄' : '沒有記錄被添加';

}else {

exit(print_r($stmt->errorInfo(),true));

}

*/

/*更新數據

//2.創(chuàng)建sql語句

$sql = 'update `money` set `balance`=:balance,`username`=:name where `user_id`=:user_id';

//3.驗證sql語句，創(chuàng)建預處理對象

$stmt = $pdo->prepare($sql);

// var_dump($stmt);

//4.參數綁定

$id = 8;

$name = '黃藥師';

$balance = 250.44;

$stmt->bindParam(':user_id',$id,PDO::PARAM_INT);

$stmt->bindParam(':balance',$balance,PDO::PARAM_STR,20);

$stmt->bindParam(':name',$name,PDO::PARAM_STR,20);

//5.執(zhí)行添加

//規(guī)范寫法

if ($stmt->execute()){

echo ($stmt->rowCount()>0) ? '成功更新'.$stmt->rowCount().'條記錄' : '沒有記錄被更新';

}else {

exit(print_r($stmt->errorInfo(),true));

}

*/

/*刪除數據

//2.創(chuàng)建sql語句

$sql = 'delete from `money` where `user_id`=:user_id';

//3.驗證sql語句，創(chuàng)建預處理對象

$stmt = $pdo->prepare($sql);

// var_dump($stmt);

//4.參數綁定

$id = 8;

$stmt->bindParam(':user_id',$id,PDO::PARAM_INT);

//5.執(zhí)行刪除

//規(guī)范寫法

if ($stmt->execute()){

echo ($stmt->rowCount()>0) ? '成功刪除'.$stmt->rowCount().'條記錄' : '沒有記錄被刪除';

}else {

exit(print_r($stmt->errorInfo(),true));

}

*/

?? ???：天蓬老師?? ??：2019-02-20 18:21:27
???? ??：寫得非常的規(guī)范 if ($stmt->execute()){ echo ($stmt->rowCount()>0) ? '成功添加'.$stmt->rowCount().'條記錄' : '沒有記錄被添加'; }else { exit(print_r($stmt->errorInfo(),true)); 實際項目中, 不要做這個檢測,會暴露出系統(tǒng)信息的, 或者自