LIST PAGE
LIST.PHP
<?php
session_start();
?>
<!DOCTYPE html>
<html>
<head>
<title>Display all records from Database</title>
<meta charset="UTF-8">
<meta name="viewport">
</head>
<body>
<?php echo "<h1>Welcome " . $_SESSION['username'] . "</h1>"; ?>
<a href="logout.php">Logout</a>
<h2>List Data</h2>
<a href= register.php>Add New Record</a>
<table border="5">
<tr>
<td>Sr.No.</td>
<td>Full Name</td>
<td>Age</td>
<td>Mobile</td>
<td>Date</td>
<td>Email_id</td>
<td>Password</td>
<td>Address</td>
<td>State</td>
<td>Gender</td>
<td>Hobbies</td>
<td>Image</td>
<td>Edit</td>
<td>Delete</td>
<td>Logout</td>
</tr>
<?php
include "conn.php"; // Using database connection file here
$records = mysqli_query($db,"select * from ab ORDER BY id DESC;"); // fetch data from database
while($data = mysqli_fetch_array($records))
{
?>
<tr>
<td><?php echo $data['id']; ?></td>
<td><?php echo $data['fullname']; ?></td>
<td><?php echo $data['age']; ?></td>
<td><?php echo $data['mobile']; ?></td>
<td><?php echo $data['date']; ?></td>
<td><?php echo $data['email_id']; ?></td>
<td><?php echo $data['password']; ?></td>
<td><?php echo $data['address']; ?></td>
<td><?php echo $data['state']; ?></td>
<td><?php echo $data['gender']; ?></td>
<td><?php echo $data['hobbies']; ?></td>
<td><img height="50" width="50" src="https://localhost/atz/image/<?php echo $data['image']; ?>"></img></td>
<td><a href="edit.php?id=<?php echo $data['id']; ?>">Edit</a></td>
<td><a href="delete.php?id=<?php echo $data['id']; ?>">Delete</a></td>
<td><a href="logout.php?id=<?php echo $data['id']; ?>">Logout</a></td>
</tr>
<?php
}
?>
</table>
</body>
</html>
Comments
Post a Comment