forked from victormwenda/MMUST_TT_WEB
-
Notifications
You must be signed in to change notification settings - Fork 0
/
save_downloads.php
82 lines (64 loc) · 3.28 KB
/
save_downloads.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
<?php
if(isset($_POST['add_download'])){
$course_code=$_POST['selected_course'];
$fileid =$_POST['selected_file'];
$cb_campuses="0";
$cb_faculties="0";
$cb_departments="0";
$cb_courses="0";
if(isset($_POST['cb_campuses'])){$cb_campuses=$_POST['cb_campuses'];}
if(isset($_POST['cb_faculties'])){$cb_faculties=$_POST['cb_faculties'];}
if(isset($_POST['cb_departments'])){$cb_departments=$_POST['cb_departments'];}
if(isset($_POST['cb_courses'])){$cb_courses=$_POST['cb_courses'];}
$campus_id = $_POST['campus'];
$faculty_id = $_POST['faculty'];
$department_id = $_POST['department'];
$course_id = $_POST['course'];
$student_adm_yr = $_POST['student_adm_yr'];
if(validate_form($campus_id,$faculty_id,$department_id,$course_id,$student_adm_yr,$course_code,$fileid)){
include 'db_auth.php';
$link = $conn;
if($cb_campuses=="1"){$campus_id="ALL";}
if($cb_faculties=="1"){$faculty_id="ALL";}
if($cb_departments=="1"){$department_id="ALL";}
if($cb_courses=="1"){$course_id="ALL";}
$query = "INSERT INTO downloads values ('$course_code','$fileid','$department_id','$faculty_id','$campus_id','$student_adm_yr','$course_id')";
if(mysqli_query($link, $query)){
increaseCommits("commits","downloads");
echo "Download saved successfully<br />";
}else{ /*Delete file from server*/
echo "Error saving download br />";
}
}
}
function validate_form($campus_id,$faculty_id,$department_id,$course_id,$student_adm_yr,$course_code,$fileid){
$form_filled = true;
if(empty($campus_id)||$campus_id=="select_campus"){$form_filled = false;echo '<span style="color:#FF0000;font-family:monospace;" >Missing Campus name.</span><br />';}
if(empty($faculty_id)||$faculty_id==="select_faculty"){$form_filled = false;echo '<span style="color:#FF0000;font-family:monospace;" >Missing Faculty name.</span><br />';}
if(empty($department_id)||$department_id=="select_department"){$form_filled = false;echo '<span style="color:#FF0000;font-family:monospace;" >Missing Department name.</span><br />';}
if(empty($course_id)||$course_id=="select_course"){$form_filled = false;echo '<span style="color:#FF0000;font-family:monospace;" >Missing pursuing course.</span><br />';}
if(empty($student_adm_yr)||$student_adm_yr=="student_adm_yr"){$form_filled = false;echo '<span style="color:#FF0000;font-family:monospace;" >Missing Student adm yr.</span><br />';}
if(empty($course_code)||$course_code==='select_course'){$form_filled = false; echo '<span style="color:#FF0000;font-family:monospace;" >Select course</span><br />';}
if(empty($fileid)||$fileid==='select_file'){$form_filled = false; echo '<span style="color:#FF0000;font-family:monospace;" >Select file</span><br />';}
return $form_filled;
}
function increaseCommits($counter, $tablename){
include 'db_auth.php';
$table_commits = getCurrentCommits($tablename) + 1;
$total_commits = getCurrentCommits($counter) +1;
$query = "update commits_info set $tablename=".$table_commits.",commits= ".$total_commits;
if($result = mysqli_query($conn, $query)){
}
}
function getCurrentCommits($tablename){
$commits_counter=0;
include 'db_auth.php';
$query = "select $tablename from commits_info";
if($result = mysqli_query($conn,$query)){
while($commits = mysqli_fetch_assoc($result)){
$commits_counter = $commits[$tablename];
}
}
return $commits_counter;
}
?>