Skip to content

Student Details Page (with Displayed Image)

studentdetails.php - Student Details: Complete Code Listing

 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
<html>
<head>
    <link rel="stylesheet"
          href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css"
          integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS"
          crossorigin="anonymous">
    <title>Student Details</title>
</head>
<body>
  <div class="card">
    <div class="card-body">
      <nav class="nav">
        <a class="nav-link" href="index.php">Students</a>
      </nav>
      <?php
          if (isset($_GET['id'])):

              require_once('dbconnection.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 = $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_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>
      <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
              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>