<?php
try{
//$dsn 數(shù)據(jù)庫驅(qū)動凝危，
$dsn = "mysql:dbname=classphp;host=127.0.0.1";
$name = "root";
$pwd = "";
$pdo = new PDO($dsn,$name,$pwd);
//設(shè)置錯誤處理模式，推薦為異常處理模式
$pdo -> setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
echo $pdo -> getAttribute(PDO::ATTR_ERRMODE);
$username = "jixue";
$pwd = md5(12345);
$email = "18868831752@163.com";
$sql = "INSERT INTO PERSON(username,pwd,email) VALUE('{$username}','{$pwd}','{$email}')";
//exec只執(zhí)行有影響行數(shù)的語句（通常指增亥啦，刪躯砰，改）
$affected = $pdo -> exec($sql);
//query執(zhí)行有結(jié)果集的語句 (通常指查詢)
$sql = "SELECT * FROM PERSON";
$stmt = $pdo -> query($sql);
var_dump($stmt);
echo "<hr/>";
var_dump($affected);
echo "<hr/>";
foreach ($stmt as $key ) {
echo "{$key['id']}-{$key['username']}-{$key['pwd']}-{$key['email']}-<br/>";
}
// var_dump($pdo);
}
catch(PDOException $e){
echo $e -> getMessage();
echo $e -> getFile();
echo $e -> getLine();
echo $e -> getCode();
}
?>
執(zhí)行后頁面顯示：
上面代碼打印輸出
