mysql 预处理创建事务_PDO 的事务操作与预处理语句

重复插入

$stmt = $dbh->prepare("INSERT INTO REGISTRY (name, value) VALUES (:name, :value)");

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

$stmt->bindParam(':value', $value);

// 插入一行

$name = 'one';

$value = 1;

$stmt->execute();

// 用不同的值插入另一行

$name = 'two';

$value = 2;

$stmt->execute();

?>

通过序号绑定参数

$stmt = $dbh->prepare("INSERT INTO REGISTRY (name, value) VALUES (?, ?)");

$stmt->bindParam(1, $name);

$stmt->bindParam(2, $value);

// 插入一行

$name = 'one';

$value = 1;

$stmt->execute();

// 用不同的值插入另一行

$name = 'two';

$value = 2;

$stmt->execute();

?>

selec 操作

$stmt = $dbh->prepare("SELECT * FROM REGISTRY where name = ?");

if ($stmt->execute(array($_GET['name']))) {

while ($row = $stmt->fetch()) {

print_r($row);

}

}

?>

绑定列号

function readData($dbh) {

$sql = 'SELECT name, colour, calories FROM fruit';

try {

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

$stmt->execute();

/* 通过列号绑定 */

$stmt->bindColumn(1, $name);

$stmt->bindColumn(2, $colour);

/* 通过列名绑定 */

$stmt->bindColumn('calories', $cals);

while ($row = $stmt->fetch(PDO::FETCH_BOUND)) {

$data = $name . "\t" . $colour . "\t" . $cals . "\n";

print $data;

}

}

catch (PDOException $e) {

print $e->getMessage();

}

}

readData($dbh);

?>