-
Notifications
You must be signed in to change notification settings - Fork 1
/
load_course_profile_progress.php
executable file
·108 lines (93 loc) · 3.24 KB
/
load_course_profile_progress.php
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
<?php
@session_start();
if (isset($_SESSION['u_id'])) {
$user_id = $_SESSION['u_id'];
} else {
die;
}
require("db.php");
$link = mysqli_connect($_srvr, $_user, $_pass, $_db);
$course_id = $_POST['course_id'];
$query = "SELECT count(`id`) FROM `assignment_question` WHERE `course_id`=?";
$statement = mysqli_prepare($link, $query);
mysqli_stmt_bind_param($statement, 'i', $course_id);
mysqli_stmt_execute($statement);
mysqli_stmt_bind_result($statement, $total_assignment_question);
mysqli_stmt_fetch($statement);
mysqli_stmt_close($statement);
$query = "SELECT count(`id`) FROM `video_question` WHERE `course_id`=?";
$statement = mysqli_prepare($link, $query);
mysqli_stmt_bind_param($statement, 'i', $course_id);
mysqli_stmt_execute($statement);
mysqli_stmt_bind_result($statement, $total_video_question);
mysqli_stmt_fetch($statement);
mysqli_stmt_close($statement);
$total_course_question = $total_assignment_question + $total_video_question;
if($total_course_question == 0){
mysqli_close($link);
die;
}
$query = "SELECT count(`id`) FROM `assignment_answer` WHERE `course_id`=? AND `user_id`=?";
$statement = mysqli_prepare($link, $query);
mysqli_stmt_bind_param($statement, 'ii', $course_id, $user_id);
mysqli_stmt_execute($statement);
mysqli_stmt_bind_result($statement, $total_user_assignment_answer);
mysqli_stmt_fetch($statement);
mysqli_stmt_close($statement);
$query = "SELECT count(`id`) FROM `video_answer` WHERE `course_id`=? AND `user_id`=?";
$statement = mysqli_prepare($link, $query);
mysqli_stmt_bind_param($statement, 'ii', $course_id, $user_id);
mysqli_stmt_execute($statement);
mysqli_stmt_bind_result($statement, $total_user_video_answer);
mysqli_stmt_fetch($statement);
mysqli_stmt_close($statement);
$query = "SELECT `title` FROM `courses` WHERE `id`=?";
$statement = mysqli_prepare($link, $query);
mysqli_stmt_bind_param($statement, 'i', $course_id);
mysqli_stmt_execute($statement);
mysqli_stmt_bind_result($statement, $course_title);
mysqli_stmt_fetch($statement);
mysqli_stmt_close($statement);
$course_link = "course.php?name=".str_replace('==', '', base64_encode($course_id.'virtut'));
$total_user_course_answer = $total_user_assignment_answer + $total_user_video_answer;
$perc_prog = floor(100*$total_user_course_answer/$total_course_question);
if($perc_prog == 0) {
mysqli_close($link);
die;
} else if($perc_prog == 100){
echo "
<div class='row'>
<div class='col-sm-4 c-title'><p>$course_title</p></div>
<div class='col-sm-5 status'><p>Completed</p></div>
<div class='fa fa-angle-right arrow'></div>
<a href='$course_link'></a>
</div>
";
mysqli_close($link);
die;
} else {
echo "
<div class='row'>
<div class='col-sm-4 c-title col-xs-11'><p>$course_title</p></div>
<div class='col-sm-5 col-xs-11'>
<div class='progress-info'>
<div class='progress'>
<div
class='progress-bar'
role='progressbar'
aria-valuenow='$perc_prog'
aria-valuemin='0'
aria-valuemax='100'
style='width:$perc_prog%;'>
</div>
</div>
<p>$perc_prog%</p>
</div>
</div>
<div class='fa fa-angle-right arrow'></div>
<a href='$course_link'></a>
</div>
";
}
mysqli_close($link);
?>