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

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

//1.創(chuàng)建PDO對(duì)象，連接數(shù)據(jù)庫(kù)

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

/* 添加數(shù)據(jù)

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

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

//3.驗(yàn)證sql語(yǔ)句，創(chuàng)建預(yù)處理對(duì)象

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

// var_dump($stmt);

//4.參數(shù)綁定

$name = '歐陽(yáng)鋒';

$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ī)范寫(xiě)法

if ($stmt->execute()){

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

}else {

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

}

*/

/*更新數(shù)據(jù)

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

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

//3.驗(yàn)證sql語(yǔ)句，創(chuàng)建預(yù)處理對(duì)象

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

// var_dump($stmt);

//4.參數(shù)綁定

$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ī)范寫(xiě)法

if ($stmt->execute()){

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

}else {

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

}

*/

/*刪除數(shù)據(jù)

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

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

//3.驗(yàn)證sql語(yǔ)句，創(chuàng)建預(yù)處理對(duì)象

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

// var_dump($stmt);

//4.參數(shù)綁定

$id = 8;

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

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

//規(guī)范寫(xiě)法

if ($stmt->execute()){

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

}else {

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

}

*/

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