php - 如何用多个id更新mysql中的多条记录

Question

我有一个 html 表单，其中有 2*12 输入字段，其中 name="links[]"和 name="ids[]"...我想使用这 12 个 ID 来更新“链接”列和这 12 个链接我知道我们需要一个循环。但不知道如何进行sql查询。

$ids=mysqli_real_escape_string($conn, $_POST['ids']);
    foreach($ids as $id){....}
$links=mysqli_real_escape_string($conn, $_POST['links']);
    foreach($links as $link){....}

$sql="update query.....";

编辑:

它适用于两个变量 $id 和 $season，但是当我添加两个以上变量(如 $episode 等)时，它不起作用。它不执行其他变量，仅执行前两个变量，并将表中所有条目的 $season 的值设置为 1，有时甚至设置为 0。

for($i=0 ; $i<count($record['id']); $i++){
  $id=mysqli_real_escape_string($conn, $record['id'][$i]);
  $season=mysqli_real_escape_string($conn, $record['season'][$i]);
  $episode=mysqli_real_escape_string($conn, $record['episode'][$i]);
  $rel_id=mysqli_real_escape_string($conn, $record['rel_id'][$i]);
  $link=mysqli_real_escape_string($conn, $record['link'][$i]);

  //sQl Query
  $sql = "UPDATE series SET season='$season' and episode='$episode' and rel_id='$rel_id' and link='$link' WHERE id='$id'";
    if ($conn->query($sql) === TRUE) {} 
        else { echo "Error: " . $sql . "<br>" . $conn->error; };

Answer 1

尝试下面的代码。

<form name="rec" id="rec" method="post">
<input type="text" name="reord[id][]">
<input type="text" name="reord[season][]">
<input type="text" name="reord[episode][]">
<input type="text" name="reord[rel_id][]">
<input type="text" name="reord[link][]">
<br/>

<input type="text" name="reord[id][]">
<input type="text" name="reord[season][]">
<input type="text" name="reord[episode][]">
<input type="text" name="reord[rel_id][]">
<input type="text" name="reord[link][]">

<br/>


<input type="text" name="reord[id][]">
<input type="text" name="reord[season][]">
<input type="text" name="reord[episode][]">
<input type="text" name="reord[rel_id][]">
<input type="text" name="reord[link][]">

</br>

<input type="submit" name="submit"  value="submit">
</form>

<?php
if(isset($_POST['submit'])){
    $record = $_POST['reord'];
    $id = $season = $episode = $rel_id = $link = '';
    for($i=0 ; $i<count($record['id']); $i++){
         $id= mysqli_real_escape_string($conn, $record['id'][$i]);
         $season=mysqli_real_escape_string($conn, $record['season'][$i]);
         $episode=mysqli_real_escape_string($conn, $record['episode'][$i]);
         $rel_id=mysqli_real_escape_string($conn, $record['rel_id'][$i]);
         $link= mysqli_real_escape_string($conn, $record['link'][$i]);
         echo $sql = "UPDATE series SET season='$season' and episode='$episode' and rel_id='$rel_id' and link='$link' WHERE id=$id";
        $conn->query($sql);
    }
}
?>