-
Notifications
You must be signed in to change notification settings - Fork 0
/
deletedept.php
71 lines (65 loc) · 1.9 KB
/
deletedept.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
<?php
session_start();
require 'connvars.php';
?>
<?php
//Check for admin here.
//If not take to login page
if (!(isset($_SESSION['aid']) && $_SESSION['aid'] != '')) {
header ("Location: adminlogin.php");
}
?>
<?php
date_default_timezone_set("Asia/Kolkata");
if (!isset($_GET['deptid'])) {
?>
<script language="javascript">window.location = "allusers.php"</script>
<?php
exit();
}
$deptid= $_GET['deptid'];
$db = mysqli_connect($dburl, $dbuser, $dbpassword, $dbdatabase) or die("Can't connect to database!");
$flag = 0;
$querytocheck = "Select uid from users where deptid = '" . $deptid . "' ";
$stmttocheck = mysqli_prepare ( $db, $querytocheck );
if (! $stmttocheck) {
die ( 'mysqli error: ' . mysqli_error ( $db ) );
}
mysqli_stmt_execute ( $stmttocheck );
mysqli_stmt_store_result ( $stmttocheck );
mysqli_stmt_bind_result ( $stmttocheck, $uid);
while ( mysqli_stmt_fetch ( $stmttocheck ) ) {
$flag = 1;
?>
<script language="javascript">
alert("This Department cannot be deleted. System contains users belonging to the department !");
window.location = "allusers.php"
</script>
<?php
}
$qu = "Select cid from courserpost where deptid = '" . $deptid . "' ";
$stm = mysqli_prepare ( $db, $qu );
if (! $stm) {
die ( 'mysqli error: ' . mysqli_error ( $db ) );
}
mysqli_stmt_execute ( $stm );
mysqli_stmt_store_result ( $stm );
mysqli_stmt_bind_result ( $stm, $cid);
while ( mysqli_stmt_fetch ( $stm ) ) {
$flag = 1;
?>
<script language="javascript">
alert("This Department cannot be deleted. System contains course assigned to the department !");
window.location = "allusers.php"
</script>
<?php
}
if($flag == 0)
{
$query = "delete from departments where deptid='$deptid'";
$stmt = mysqli_prepare($db, $query);
mysqli_stmt_execute($stmt);
}
//Add stuff to delete user table entries
?>
<script language="javascript">window.location = "allusers.php"</script>