selflearn/_myCourses.php at master · the-code-teller/selflearn · GitHub

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
<?php

$sql = "SELECT * FROM `student-course-junction` WHERE `studentID`=$studentID";
$result = mysqli_query($con, $sql);

if ($result) {

    echo "<div class='container-fluid my-2'>
        <div class='d-flex justify-content-between my-3'>
            <div class='text-success'>
                <h4>My Courses</h4>
            </div>
            <div>
                <a type='button' href='myCourses.php' class='text-success text-decoration-none' role='button'>See all courses</a>
            </div>
        </div>";

        echo "<div class='row row-cols-1 row-cols-md-5 g-4'>";

        $sql = "SELECT * FROM `student-course-junction` WHERE `studentID`=$studentID";
        $result = mysqli_query($con, $sql);

        if ($result) {

            for ($i=1; $i <= 10 && $row = mysqli_fetch_assoc($result) ; $i++) {

                include "_myCoursesSQL.php";
            }
        }

        echo "</div>";

    echo "</div>";

}

?>