当我们插入值时,有一个在mySQL中自动生成的列名代码。我想在弹出窗口中显示最后一个插入的值代码列。
<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
require_once 'db.php';
// Escape user inputs for security
$company = mysqli_real_escape_string($test_db, $_POST['company']);
$project = mysqli_real_escape_string($test_db, $_POST['project']);
$revision = mysqli_real_escape_string($test_db, $_POST['revision']);
// attempt insert query execution
$sql = "INSERT INTO live (company, project, revision, code) VALUES ('$company', '$project', '$revision', '')";
if(mysqli_query($test_db , $sql)){
echo '
<script type="text/javascript">
alert("i want to show last inserted code here and redirected to a page on clicking close button");
</script>';
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($test_db);
}
// close connection
mysqli_close($test_db);
?>
假设您的" live"表具有主键自动插件,那么这应该有效:
if(mysqli_query($test_db , $sql)){
echo '
<script type="text/javascript">
alert("ID of last inserted row: '.mysqli_insert_id($test_db).'");
</script>';
}