$servername="localhost";
$username="root";
$password="admin";
//$dbname為我的test數(shù)據(jù)庫
$dbname="test";
try{
  $conn=new PDO("mysql:host=$servername;dbname=$dbname",$username,$password);
  //設置pdo錯誤異常處理
  $conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
  //預處理SQL并綁定參數(shù)
  $stmt=$conn->prepare("INSERT INTO user(user_first,user_last,age)VALUES(:user_first,:user_last,:age)");
  $stmt->bindParam(":user_first",$user_first);
  $stmt->bindParam(":user_last", $user_last);
  $stmt->bindParam(":age",$age);
  //要執(zhí)行的插入記錄
  $user_first="xiao";
  $user_last="liang";
  $age=15;
  $stmt->execute();
  //要執(zhí)行的插入記錄
  $user_first="xiao";
  $user_last="cheng";
  $age=23;
  $stmt->execute();
  echo "News record created successfully!";
}catch(PDOException $e){
  echo "Error:".$e->getMessage();
}
$conn=null;