Ajax，从函数中检索插入的ID

Question

我正在尝试使用Ajax将表单数据插入数据库并返回插入的ID。

它目前可以插入(我可以在数据库中看到它(，但我正在使用alert来测试它是否正在获取插入的ID，它只是说未定义。

我取回身份证是不是做错了什么？

<script type="text/javascript">
$(document).ready(function(){
$("#submitForm").click(function(){
var string = $('#pageForm').serialize();
// AJAX Code To Submit Form.
$.ajax({
type: "POST",
url: "addPage.php",
data: string,
cache: false,
success: function(result){
alert(result.id);//this will alert you the last_id
}
});
});
});
</script>

addPage.php

$title = $_POST['addTitle'];
$page_type = $_POST['pageType'];
$display_id = $_POST['displayId'];
$duration = $_POST['durationSet'];
$addpage = "
INSERT INTO pages (title, page_type_id, display_id, duration)
VALUES ('$title','$page_type','$display_id','$duration');
";
if ($mysqlConn->query($addpage) === TRUE) {
$last_id = $mysqlConn->insert_id;
echo json_encode(['id'=>$last_id]);
echo "New record created successfully" . $last_id;
} else {
echo "Error: " . $addpage . "<br>" . $mysqlConn->error;
}

Answer 1

尝试返回最后插入的数据id

$title = $_POST['addTitle'];
$page_type = $_POST['pageType'];
$display_id = $_POST['displayId'];
$duration = $_POST['durationSet'];
$addpage = "
INSERT INTO pages (title, page_type_id, display_id, duration)
VALUES ('$title','$page_type','$display_id','$duration');
";
if ($mysqlConn->query($addpage) === TRUE) {
$last_id = $mysqlConn->insert_id;
$data = json_encode(['id'=>$last_id]);
echo "New record created successfully" . $data ;
} else {
echo "Error: " . $addpage . "<br>" . $mysqlConn->error;
}

Answer 2

https://www.w3schools.com/PHP/php_mysql_insert_lastid.asp

提问前请先搜索

if ($mysqlConn->query($addpage) === TRUE) {
$last_id = $mysqlConn->insert_id;
echo "New record created successfully" . $last_id;
} else {
echo "Error: " . $addpage . "<br>" . $mysqlConn->error;
}