PHP/index.php at main · CodeofAditya/PHP · 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
<?php include 'DB.PHP'; ?>
<html>
<body>

<h1>Student List</h1>
<a href="INSERT.PHP">Add New Student</a>

<table border="1">
<tr>
    <th>ID</th>
    <th>First Name</th>
    <th>Last Name</th>
    <th>Divison</th>
    <th>Email</th>
    <th>Age</th>
</tr>

<?php
$result = mysqli_query($conn, "SELECT * from classinfo");

while ($row = mysqli_fetch_assoc($result)) {
?>
<tr>
    <th><?php echo $row['id']; ?></th>
    <th><?php echo $row['FRISTNAME']; ?></th>
    <th><?php echo $row['LASTNAME']; ?></th>
    <th><?php echo $row['DIVISON']; ?></th>
    <th><?php echo $row['EMAILID']; ?></th>
    <th><?php echo $row['AGE']; ?></th>
</tr>
<?php
}
?>

</table>

</body>
</html>