php - 无法选择特定 ID 来编辑 PHP 中的数据

Question

hal1/view.php

<?php
include "koneksi.php";
include "cek.php";

$result = $koneksi->query("select * from pengunjung");
$baris = $result->fetch_assoc();

echo "Halaman Admin<br>";
echo "Nama Anda adalah : ".$_SESSION['namauser']. "<br><br>";
echo "<li><a href = edit.php?userid=$baris[id]>[Edit Data Diri]</a></li><br>    
      <li><a href=logout.php> Logout</a></li>";
?>

编辑.php

<?php
include("koneksi.php");
include("cek.php");

$id=$_GET['userid'];

$query = "select * from pengunjung where id=$id";
$result = mysqli_query($koneksi,$query);

while ($baris = mysqli_fetch_array($result))
{
    echo "<form method=post action=update.php>";
    echo "Nama : <input type=text name=nama value=$baris[1]>";
    echo "<br>";
    echo "Email : <input type=text name=email value=$baris[2]>";
    echo "<br>";
    echo "Situs : <input type=text name=situs value=$baris[3]>";
    echo "<br>";
    echo "<input type=submit name=submit value=update>";
    echo "<input type=hidden name=id value=$baris[0]>";
    echo "</form>";
}
?>

更新.php

<?php
include("koneksi.php");

$id=$_POST['id'];
$nama=$_POST['nama'];
$email=$_POST['email'];
$situs=$_POST['situs'];

$query = "update pengunjung set id='$id', nama='$nama', email='$email', 
situs='$situs' where id='$id'";
$result = mysqli_query($koneksi,$query);

echo '<script language="JavaScript">alert("Data telah di update");
    document.location="edit.php"</script>';
?>

我使用了登录表单，并以具有特定 ID 的用户身份登录。我尝试编辑登录用户的数据(nama、email、situs)。问题是为什么它没有选择登录用户的正确数据(姓名、电子邮件、地点)？。每当我以不同的用户身份登录并单击“编辑”时，它总是显示数据库中第一个 ID/用户的数据(名字、电子邮件、位置)。救命!!

Answer 1

使用id变量

<?php
include("koneksi.php");
include("cek.php");

$id=$_GET['userid'];

$query = "select * from pengunjung where id=$id";
$result = mysqli_query($koneksi,$query);

while ($baris = mysqli_fetch_assoc($result))
{
   ?>
    <form method=post action=update.php>
   Nama : <input type=text name="nama" value="<?php echo $baris['column1']?>">

    Email : <input type=text name="email" value="<?php echo $baris['column2']?>">

    Situs : <input type=text name=situs value="<?php echo $baris['column3']?>">
    <input type=hidden name=id value="<?php echo $id?>"d>
    <input type=submit name=submit value=update>


    </form>
 <?php
}
?>