如何从INSERT INTO更改为UPDATE - How can I change from INSERT INTO to UPDATE

How can I change from INSERT INTO to UPDATE

本文关键字：UPDATE INTO INSERT | 更新日期: 2023-09-27

（对不起我的英文写作）这是我的插入数据编码

  $insertChecklist = 'INSERT INTO checklists(`ADMIN_ID`, `COMPUTER_ID`) VALUES(?, ?);';
    $stmtChecklist = $connection->prepare($insertChecklist);
    $stmtChecklist->bind_param('ii', $_POST['ADMIN_ID'], $_POST['COMPUTER_ID']);
    $isInsert = $stmtChecklist->execute();
    $lastInsertId = mysqli_insert_id($connection);
    $stmtChecklist->close();
  $insertInstalledProgram = 'INSERT INTO checklist_programs(`CHECKLIST_ID`, `PROGRAM_ID`) VALUES(?, ?);';
  $stmtProgramId = $connection->prepare($insertInstalledProgram);
  $stmtProgramId->bind_param('ii', $lastInsertId, $programId);
  foreach ($_POST['PROGRAM_ID'] as $program)
  {
    $programId = $program;
    $stmtProgramId->execute();
  }
    $stmtProgramId->close();
    $connection->close();
    if ($isInsert) {
      // echo($lastInsertId);
      header('Location: OverViewCheckList.php');
      exit(0);
    }

我需要把这个Insert into改成Update我不知道怎么做。请帮助：(非常感谢。

不清楚您真正想要的是什么也许是这样的：

$updateChecklist = 'UPDATE checklists SET `ADMIN_ID` = ?, `COMPUTER_ID` = ? WHERE id = ?';
$stmtChecklist = $connection->prepare($insertChecklist);
$stmtChecklist->bind_param('iii', $_POST['ADMIN_ID'], $_POST['COMPUTER_ID'], $_POST['ID']);
$res = $stmtChecklist->execute();