Online-Auction/settings.php at main · NalinduMelaka/Online-Auction · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
<?php
session_start();

	include("connection.php");
	include("functions.php");
	$id = $_SESSION['user_id'];
	$user_data = check_login($con);
  $result = mysqli_query($con,"SELECT * FROM users WHERE user_id = '$id'");


?>

<!DOCTYPE html>
<html>
 <head>
   <title> Retrive data & update</title>
   <link rel="stylesheet" href="style.css">
 </head>
<body>
<?php
if (mysqli_num_rows($result) > 0) {
?>
<table>
	  <tr>
	    <td>User_No</td>
		<td>User Name</td>
		<td>Password</td>
		<td>Email</td>
		<td>Identity_card</td>
		<td>Full Name</td>
	  </tr>
			<?php
			$i=0;
			while($row = mysqli_fetch_array($result)) {
			?>
	  <tr>
	    <td><?php echo $row["id"]; ?></td>
		<td><?php echo $row["user_name"]; ?></td>
		<td><?php echo $row["password"]; ?></td>
		<td><?php echo $row["email"]; ?></td>
		<td><?php echo $row["identity_card"]; ?></td>
		<td><?php echo $row["full_name"]; ?></td>
		<td><a href="update-process.php?id=<?php echo $row["id"]; ?>">Update</a></td>
      </tr>
			<?php
			$i++;
			}
			?>
</table>
 <?php
}
else
{
    echo "No result found";
}
?>
 </body>
</html>