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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130 | <html>
<head>
<title>Remove Student</title>
<link rel="stylesheet"
href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css"
integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS"
crossorigin="anonymous">
</head>
<body>
<div class="card">
<div class="card-body">
<h1>Remove a Student</h1>
<?php
require_once('dbconnection.php');
require_once('studentimagefileutil.php');
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
or trigger_error('Error connecting to MySQL server for DB_NAME.',
E_USER_ERROR);
if (isset($_POST['delete_student_submission'], $_POST['id'])):
$id = $_POST['id'];
// Query image file from DB
$query = "SELECT image_file FROM studentListing WHERE id = $id";
$result = mysqli_query($dbc, $query)
or trigger_error('Error querying database studentListing', E_USER_ERROR);
if (mysqli_num_rows($result) == 1)
{
$row = mysqli_fetch_assoc($result);
$student_image_file = $row['image_file'];
if (!empty($student_image_file))
{
removeStudentImageFile($student_image_file);
}
}
$query = "DELETE FROM studentListing WHERE id = $id";
$result = mysqli_query($dbc, $query)
or trigger_error('Error querying database studentListing', E_USER_ERROR);
header("Location: index.php");
elseif (isset($_POST['do_not_delete_student_submission'])):
header("Location: index.php");
elseif (isset($_GET['id_to_delete'])):
?>
<h3 class="text-danger">Confirm Deletion of the Following Student Details:</h3><br/>
<?php
$id = $_GET['id_to_delete'];
$query = "SELECT * FROM studentListing WHERE id = $id";
$result = mysqli_query($dbc, $query)
or trigger_error('Error querying database studentListing', E_USER_ERROR);
if (mysqli_num_rows($result) == 1):
$row = mysqli_fetch_assoc($result);
$student_image_file = $row['image_file'];
if (empty($student_image_file))
{
$student = SL_UPLOAD_PATH . SL_DEFAULT_STUDENT_FILE_NAME;
}
?>
<h1><?=$row['first_name'] . ' ' . $row['last_name']?></h1>
<div class="row">
<div class="col-3">
<img src="<?=$student_image_file?>" class="img-thumbnail" style="max-height: 200px;" alt="Student image">
</div>
<div class="col">
<table class="table table-striped">
<tbody>
<tr>
<th scope="row">First Name</th>
<td><?=$row['first_name']?></td>
</tr>
<tr>
<th scope="row">Last Name</th>
<td><?=$row['last_name']?></td>
</tr>
<tr>
<th scope="row">Email</th>
<td><?=$row['email']?></td>
</tr>
</tbody>
</table>
<form method="POST" action="<?=$_SERVER['PHP_SELF'];?>">
<div class="form-group row">
<div class="col-sm-4">
<button class="btn btn-danger" type="submit" name="delete_student_submission">Delete Student</button>
</div>
<div class="col-sm-4">
<button class="btn btn-success" type="submit" name="do_not_delete_student_submission">Don't Delete</button>
</div>
<input type="hidden" name="id" value="<?= $id ?>;">
</div>
</form>
</div>
</div>
<?php
else:
?>
<h3>No Student Details :-(</h3>
<?php
endif;
else: // Unintended page link - No Student to remove, link back to index
header("Location: index.php");
endif;
?>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.6/umd/popper.min.js" integrity="sha384-wHAiFfRlMFy6i5SRaxvfOCifBUQy1xHdJ/yoi7FRNXMRBu5WHdZYu1hA6ZOblgut" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/js/bootstrap.min.js" integrity="sha384-B0UglyR+jN6CkvvICOB2joaf5I4l3gm9GU6Hc1og6Ls7i6U/mkkaduKaBhlAXv9k" crossorigin="anonymous"></script>
</body>
</html>
|