php - SQLi 代码未使用用户 ID 插入正确的行

Question

我一直在尝试修复此代码，但无论我用它做什么，它都不起作用。它应该插入到数据库中您发现了一个 secret 游戏，使用 session 中存储的用户 ID 进入登录用户的行，有没有办法修复此代码，因为我很困惑。

<?php
$con=mysqli_connect("localhost","username","password","database");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
 mysqli_query($con,"INSERT INTO login (code, link)
VALUES ('You Found a Secret Game!', '/12283719823838hdhj/') WHERE id = " . 
$_SESSION['user']['id'], ENT_QUOTES, 'UTF-8');
mysqli_close($con);
?>

Answer 1

试试这个

mysqli_query($con,"INSERT INTO login (code, link)
                   VALUES ('You Found a Secret Game!', '/12283719823838hdhj/') 
                 WHERE id ='".$_SESSION['user']['id']."' ",ENT_QUOTES, 'UTF-8' );