表单提交后PHP重定向到上传的页面？

Question

在这个程序中，用户正在将照片上传到 MYSQL。 Photoid 是自动递增的。一旦用户提交表单，下面的代码就会采取行动。我希望用户被重定向到照片刚刚上传到的页面。我怎样才能将他重定向到 photopage.php?photoid=???。

 $addaphoto_query = "INSERT INTO `photosite`.`photos` (id, photoid, title, description) VALUES ('$id', '', '$title', '$description')";

    if ($run_addaphoto = mysqli_query($connect, $addaphoto_query){
         header('Location: photopage.php?photoid=???');
    }

Answer 1

您需要使用 PHP 函数 mysqli_insert_id() .这将为您提供带照片的 ID。

if ($run_addaphoto = mysqli_query($connect, $addaphoto_query){
    header('Location: photopage.php?photoid=' . mysqli_insert_id());
}

如果您想知道，无论您获得多少流量，mysqli_insert_id() 都是安全的。 More reading on this SO question.

From the MySQL manual

For LAST_INSERT_ID(), the most recently generated ID is maintained in the server on a per-connection basis. It is not changed by another client. It is not even changed if you update another AUTO_INCREMENT column with a nonmagic value (that is, a value that is not NULL and not 0). Using LAST_INSERT_ID() and AUTO_INCREMENT columns simultaneously from multiple clients is perfectly valid. Each client will receive the last inserted ID for the last statement that client executed.