Skip to content

Student Listing of Main Page (with File Upload)

index.php - Student Listing: 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
<html>
  <head>
    <link rel="stylesheet"
          href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css"
          integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS"
          crossorigin="anonymous">
    <link rel="stylesheet"
          href="https://use.fontawesome.com/releases/v5.8.1/css/all.css"
          integrity="sha384-50oBUHEmvpQ+1lW4y57PTFmhCaXp0ML5d60M1M7uH2+nqUivzIebhndOJK28anvf"
          crossorigin="anonymous">
    <title>Student Listing</title>
  </head>
  <body>
    <div class="card">
      <div class="card-body">
        <h1>Students</h1>
        <p class='nav-link'>If you have a student you would like to include, 
          feel free to <a href='addstudent.php'> add one</a></p>
        <?php
            require_once('dbconnection.php');
            require_once('studentlistingfileconstants.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);

            $query = "SELECT id, first_name, last_name, image_file FROM studentListing ORDER BY last_name, first_name";

            $result = mysqli_query($dbc, $query)
                    or trigger_error('Error querying database studentListing', E_USER_ERROR);

            if (mysqli_num_rows($result) > 0):
        ?>
                <table class="table table-striped">
                    <thead>
                    <tr>
                        <th scope="col">Student Name</th>
                        <th scope="col"></th>
                        <th scope="col"></th>
                    </tr>
                    </thead>
                    <tbody>
            <?php
                while($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;
                    }

                    echo "<tr><td>"
                        . "<img src=" . $student_image_file . " class='img-thumbnail'"
                        . " style='max-height: 75px;' alt='Student image'></td>"
                        . "<td><a class='nav-link' href='studentdetails.php?id=" . $row['id'] . "'>"
                        . $row['first_name'] . ' ' . $row['last_name'] . "</a></td>"
                        . "<td><a class='nav-link' href='removestudent.php?id_to_delete="
                        . $row['id'] ."'><i class='fas fa-trash-alt'></i></a></td></tr>";
                }
            ?>
                    </tbody>
                </table>        
        <?php
            else:
        ?>
                <h3>No Students Found :-(</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>