forked from nisiya/MaristIDCP
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdelete_helpers.php
146 lines (114 loc) · 4.68 KB
/
delete_helpers.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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
<?php
require( 'includes/connect_db_c9.php' ) ;
$debug = true;
function delete_student($dbc, $stu_id){
require( 'includes/connect_db_c9.php' ) ;
$query = "DELETE FROM PRG_ENROLLED WHERE STU_ID = '$stu_id'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
$query = "DELETE FROM CERT_EARNED WHERE STU_ID = '$stu_id'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
$query = "DELETE FROM CRS_ENROLLED WHERE STU_ID = '$stu_id'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
$query = "DELETE FROM STUDENT WHERE STU_ID = '$stu_id'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
}
function delete_employer($dbc, $emp_name){
require( 'includes/connect_db_c9.php' ) ;
$query = "DELETE FROM EMPLOYER WHERE EMP_NAME = '$emp_name'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
}
function delete_instructor($dbc, $ins_id){
require( 'includes/connect_db_c9.php' ) ;
$query = "DELETE FROM TEACHES WHERE INS_ID = $ins_id";
$results = mysqli_query($dbc,$query) ;
$query = "DELETE FROM INSTRUCTOR WHERE INS_ID = $ins_id";
$results = mysqli_query($dbc,$query) ;
}
function delete_other_user($dbc, $other_user_id){
require( 'includes/connect_db_c9.php' ) ;
$query = "DELETE FROM IDCP_USER WHERE USER_ID = '$other_user_id'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
}
function delete_student_program($dbc, $prg_id, $stu_id, $prg_enroll_start){
require( 'includes/connect_db_c9.php' ) ;
$query = "DELETE FROM PRG_ENROLLED WHERE PRG_ID = $prg_id AND STU_ID = $stu_id AND PRG_ENROLL_START = '$prg_enroll_start'";
// echo $query;
$results = mysqli_query($dbc,$query) ;
// check_delete_results($results) ;
mysqli_close( $dbc ) ;
}
function delete_student_course($dbc, $crs_id, $stu_id, $crs_enroll_start){
require( 'includes/connect_db_c9.php' ) ;
$query = "DELETE FROM CRS_ENROLLED WHERE CRS_ID = '$crs_id' AND STU_ID = $stu_id AND CRS_ENROLL_START = '$crs_enroll_start'";
// echo $query;
$results = mysqli_query($dbc,$query) ;
// check_delete_results($results) ;
mysqli_close( $dbc ) ;
}
function delete_student_certificate($dbc, $stu_id, $cert_id){
require( 'includes/connect_db_c9.php' ) ;
$query = "DELETE FROM CERT_EARNED WHERE CERT_ID = '$cert_id' AND STU_ID = $stu_id";
// echo $query;
$results = mysqli_query($dbc,$query) ;
// check_delete_results($results) ;
mysqli_close( $dbc ) ;
}
function delete_program($dbc, $prg_id){
require( 'includes/connect_db_c9.php' ) ;
$query = "DELETE FROM PRG_ENROLLED WHERE PRG_ID = $prg_id";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
$query = "DELETE ce FROM CERT_EARNED ce, CERTIFICATE c WHERE c.PRG_ID = $prg_id AND c.CERT_ID = ce.CERT_ID";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
$query = "DELETE FROM CERTIFICATE WHERE PRG_ID = $prg_id";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
$query = "DELETE FROM CRS_MADE_OF WHERE PRG_ID = $prg_id";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
$query = "DELETE FROM PROGRAM WHERE PRG_ID = $prg_id";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
}
function delete_certificate($dbc, $cert_id){
require( 'includes/connect_db_c9.php' ) ;
$query = "DELETE FROM CERT_EARNED WHERE CERT_ID = '$cert_id'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
$query = "DELETE FROM CERTIFICATE WHERE CERT_ID = '$cert_id'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
}
function delete_course($dbc, $crs_id){
require( 'includes/connect_db_c9.php' ) ;
$query = "DELETE FROM CRS_ENROLLED WHERE CRS_ID = '$crs_id'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
$query = "DELETE FROM CRS_MADE_OF WHERE CRS_ID = '$crs_id'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
$query = "DELETE FROM TEACHES WHERE CRS_ID = '$crs_id'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
$query = "DELETE FROM COURSE WHERE CRS_ID = '$crs_id'";
$results = mysqli_query($dbc,$query) ;
check_delete_results($results) ;
}
function show_delete_query($query) {
global $debug;
if($debug)
echo "<p>Query = $query</p>" ;
}
function check_delete_results($results) {
global $dbc;
if($results != true)
echo '<p>SQL ERROR = ' . mysqli_error( $dbc ) . '</p>' ;
}
?>