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 | <?php
require_once('pagetitles.php');
$page_title = SL_DETAILS_PAGE;
?>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet"
href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css"
integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS"
crossorigin="anonymous">
<title><?= $page_title ?></title>
</head>
<body>
<?php
require_once('navmenu.php');
?>
<div class="card">
<div class="card-body">
<h1><?= $page_title ?></h1>
<hr/>
<?php
if (isset($_GET['id'])):
require_once('dbconnection.php');
require_once('queryutils.php');
require_once('studentlistingfileconstants.php');
$id = $_GET['id'];
$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);
$query = "SELECT * FROM studentListing WHERE id = ?";
$result = parameterizedQuery($dbc, $query, 'i', $id)
or trigger_error(mysqli_error($dbc), 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_image_file = SL_UPLOAD_PATH . SL_DEFAULT_STUDENT_FILE_NAME;
endif;
?>
<h1>ID: <?= $row['id'] ?></h1>
<div class="row">
<div class="col-4">
<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>
</div>
</div>
<?php
if (isset($_SESSION['user_access_privileges'], $_SESSION['user_student_listing_id'])
&& ($_SESSION['user_access_privileges'] == 'admin'
|| $_SESSION['user_student_listing_id'] == $row['id'])):
?>
<hr/>
<p>If you would like to change any of the details of this student, feel free to <a href='editstudent.php?id_to_edit=<?=$row['id']?>'> edit it</a></p>
<?php
endif;
else:
?>
<h3>No Student Details :-(</h3>
<?php
endif;
else:
?>
<h3>No Student Details :-(</h3>
<?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>
|