<?php
//PDO：数据访问抽象层
//dsn：数据源：
//带有事务功能：
$dsn = "mysql:host=localhost;dbname=mydb"; ——建立数据源
//造pdo对象
$pdo = new PDO($dsn,"root","123");
//设置为异常模式
$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION );try
{
//写SQL语句
$sql = "insert into Nation values('n009','藏族')";
$sql1 = "insert into Nation values('n001','藏族')";
//$sql2 = "insert into Nation values('n012','藏族')";
//启动事务
$pdo->beginTransaction();
//执行SQL语句
$pdo->exec($sql); //exec命令为执行该语句后，返回到该语句的主键位置
$pdo->exec($sql1);
//$pdo->exec($sql2);
//提交事务
$pdo->commit();
}
catch(PDOException $e)
{
//echo $e->getMessage();
//回滚事务
$pdo->rollBack();
}
/*foreach($a as $v)
{
var_dump($v);
}*/
?>
