PDO
–
教程 获取上一次 insert 操作生成的 id
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
">
<html xmlns="
">
<head>
<title>获取上一次插入数据得到的 id</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<?php
//链接 mysql 数据库
$dsn
= 'mysql:dbname=test;host=127.0.0.1';
$user
= 'root';
$password
= 'root';
try
{
$dbh
=
new
PDO(
$dsn
,
$user
,
$password
);
}
catch
(PDOException
$e
) {
//如果连接失败,抛出异常
echo
'Connection failed: ' .
$e
->getMessage();
}
$sql
= "INSERT INTO `test`.`content` (`id`, `title`, `vote_num`) VALUES (NULL, 'test', '100');";
$dbh
->query(
$sql
);
echo
$dbh
->lastInsertId();
//获取 insert 操作生成的 id
?>
</body>
</html>