selflearn/_myCoursesSQL.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
<?php

// $junctionID = $row['junctionID'];
$courseID = $row['courseID'];

$sql = "SELECT * FROM `courses` WHERE `courseID`=$courseID";
$res = mysqli_query($con, $sql);

if ($res) {

    $roC = mysqli_fetch_assoc($res);

    $courseTitle = $roC['courseTitle'];
    // $courseDescription = $roC['courseDescription'];
    // $coursePrice = $roC['coursePrice'];
    $courseDP = $roC['courseDP'];
    // $courseTableName = $roC['courseTableName'];
    $teacherID = $roC['teacherID'];

    $sql = "SELECT * FROM `teachers` WHERE `teacherID`='$teacherID'";
    $reT = mysqli_query($con, $sql);

    if ($reT) {

        $roT = mysqli_fetch_assoc($reT);
        // $teacherID = $roT['teacherID'];
        $teacherName = $roT['teacherName'];
        $teacherDesignation = $roT['teacherDesignation'];

        include "_myCourseCard.php";

    }

}

?>