为每个成员插入最后3次访问

Question

i'm designing a Gym Administration System, each member has a unique number stored in a database, each member should type his number when he entered the gym to make sure if his subscription is ended or not, i already design that page, but i need that page to ( add the last 3 visits for each member ) ? how can i do it ? i need to overwrite the last 3 visits everytime . ID's 1,2 and 3 are the last visit for member

$con = mysqli_connect('localhost', 'root', '', 'test') or die('error' . mysqli_errno($con));

$query1 = mysqli_query($con, "SELECT * FROM checkin WHERE id = 1");
while ($row = mysqli_fetch_array($query1)){
?>
<div id="checkIn">
<table>
<tr>
<td>Check-In</td>
<td><?php echo $row['timeIn']; ?></td>
<td><?php echo $row['dateIn']; } ?></td>
</tr>
<?php
$query2 = mysqli_query($con, "SELECT * FROM checkin WHERE id = 2");
while ($row = mysqli_fetch_array($query2)){
?>
<tr>
<td>Check-In</td>
<td><?php echo $row['timeIn']; ?></td>
<td><?php echo $row['dateIn']; } ?></td>
</tr>
<?php 
$query3 = mysqli_query($con, "SELECT * FROM checkin WHERE id = 3");
while ($row = mysqli_fetch_array($query3)){
?>
<tr>
<td>Check-In</td>
<td><?php echo $row['timeIn']; ?></td>
<td><?php echo $row['dateIn']; } ?></td>
</tr>
</table>

Answer 1

First create a query to fetch all users than loop through them.

$userQuery = $con->prepare("SELECT user_id FROM users");
$userQuery->execute();
$users = mysqli_fetch_array(userQuery);

foreach($users as $user) {
     $visitedQuery = $con->prepare("SELECT timeIn, dateIn FROM checkin WHERE user_id = ?  ORDER BY id DESC LIMIT 3");
     $visitedQuery->execute(array($user['user_id']));

     $lastCheckIn = mysqli_fetch_array($visitedQuery);
     foreach($lastCheckIn as $lastCheck) {
         echo $lastCheckIn['timeIn']." ".$lastCheckIn['dateIn'];
     } 
}