-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.php
92 lines (69 loc) · 2.61 KB
/
index.php
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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
<?php
require_once('connection/connection.php');
session_start();
if (empty($_SESSION['username'])) {
header('location:login.php');
}
?>
<?php
if (isset($_GET['id'])) {
$id = $_GET['id'];
$res = $con->prepare("DELETE from studinfo WHERE id=$id")->execute();
if ($res) {
header('location:index.php');
}
}
?>
<!DOCTYPE html>
<html lang="en">
<?php include('includes/header.php'); ?>
<body>
<main>
<?php include('includes/navbar.php'); ?>
<div class="container">
<div class="row mb-3">
<div class="col-md-12 text-center mt-5">
<div class="form-signin">
<h1 class="h3 mb-3 fw-normal">Students List</h1>
<hr>
<table class="table">
<thead>
<tr>
<td>Number</td>
<td>FirstName</td>
<td>MiddleName</td>
<td>LastName</td>
<td>Action</td>
</tr>
</thead>
<tbody>
<?php
$data = $con->query("SELECT * from studinfo")
->fetchAll();
$counter = 1;
foreach ($data as $rows) {
?>
<tr>
<td><?php echo $counter++; ?></td>
<td><?php echo $rows['fname']; ?></td>
<td><?php echo $rows['mname']; ?></td>
<td><?php echo $rows['lname']; ?></td>
<td>
<a href="update.php?id=<?php echo $rows['id'] ?>"
class="btn btn-success btn-sm">Update </a>
<a href="index.php?id=<?php echo $rows['id'] ?>"
class="btn btn-danger btn-sm">Delete </a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</main>
</body>
</html>