php - 从上次插入表中获取 ID

Question

我正在插入多个表，需要从最后一次插入表 1 中获取 ID，并将其用作表 2 插入中的变量。

ID 会自动递增。

一旦在表单中单击提交按钮，查询就会运行。

查询的:

$sql = "INSERT INTO table1 (Text) VALUES ($T1text);";
$sql = "INSERT INTO table2 (table1ID,Text) VALUES ($table1id, $T2text);";


table1 {id,Text}
table2 {id,table1.id,Text}

Answer 1

有一个 PHP 函数(已弃用，在 7.0 中删除!)或者相应的 mysql/mysqli/pdo 函数。

解决方案

PHP(已弃用)

例子

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
 die('Could not connect: ' . mysql_error());
}
mysql_select_db('mydb');

mysql_query("INSERT INTO mytable (product) values ('kossu')");
printf("Last inserted record has id %d\n", mysql_insert_id());

来源:http://php.net/manual/en/function.mysql-insert-id.php

Mysql/Mysqli/PDO

Mysqli $sql = "INSERT INTO MyGuests (firstname, lastname, email) 值(“约翰”、“母鹿”、“john@example.com”)”；

if (mysqli_query($conn, $sql)) {
    $last_id = mysqli_insert_id($conn);
    echo "New record created successfully. Last inserted ID is: " . $last_id;
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

PDO

$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
// use exec() because no results are returned
$conn->exec($sql);
$last_id = $conn->lastInsertId();

来源:http://www.w3schools.com/php/php_mysql_insert_lastid.asp