php - 在 PHP 中仅显示用户自己的数据

Question

我目前已经制作了一个显示所有用户的页面，但我只想只显示当前登录的用户，请帮帮我，我求你了，我花了 4 个小时什么都没有 T_T 我是 php 新手，我非常迷失，我现在很绝望

<?PHP
$customerquery=mysql_query("select * from customerinfo");
while($customerrows=mysql_fetch_array($customerquery)){
?>
<tr>
<td>Id</td><td>First Name</td><td>Last Name</td><td>Address</td><td>Contact No</td>   <td>Username</td><td>Password</td><td>Edit</td>
</tr>
<tr>
<td><?PHP echo $customerrows['id'];?></td>
<td><?PHP echo $customerrows['fname'];?></td>
<td><?PHP echo $customerrows['lname'];?></td>
<td><?PHP echo $customerrows['address'];?></td>
<td><?PHP echo $customerrows['contactno'];?></td>
<td><?PHP echo $customerrows['username'];?></td>
<td><?PHP echo $customerrows['password'];?></td>
<td><a href="edit2.php<?PHP echo '?id='.$customerrows['id']; ?>">edit</a></td>
</tr>
<?PHP } ?>

Answer 1

您需要在查询中指定 WHERE 条件。这只会获取一行，因此您不需要 while 循环:

$id = (int) $_GET['id']; // assuming you pass user id in URL
$customerquery = mysql_query("select * from customerinfo WHERE id = $id");
$customerrows = mysql_fetch_array($customerquery);
// rest of your html