forked from lalin/training_project
-
Notifications
You must be signed in to change notification settings - Fork 1
/
delete_subject.php
52 lines (39 loc) · 1.31 KB
/
delete_subject.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
<?php require_once("includes/session.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php confirm_logged_in(); ?>
<?php require_once("includes/connection.php"); ?>
<?php
if (intval($_GET["subj"]) == 0) {
redirect_to("content.php");
}
$id = mysql_prep($_GET["subj"]);
if ($subject = get_subject_by_id($id)) {
//TODO: DELETE ALL CHILDREN FIRST!
$child_query = "DELETE FROM pages WHERE subject_id={$id}";
//$result = mysql_query($child_query, $connection);
//if (mysql_affected_rows() >= 1) {
if (mysql_query($child_query, $connection)) {
$query = "DELETE FROM subjects WHERE id={$id}";//FAILING???
$result = mysql_query($query, $connection);
if (mysql_affected_rows() == 1) {
redirect_to("content.php");
} else {
//Deletion failed
echo "<p>Subject deletion failed.</p>";
echo "<p>" . mysql_error() . "</p>";
echo "<a href=\"content.php\">Return to Main Page</a>";
}
} else {
//Deletion failed
echo "<p>Subject's pages deletion failed.</p>";
echo "<p>" . mysql_error() . "</p>";
echo "<a href=\"content.php\">Return to Main Page</a>";
}
} else {
//subject didn't exist in database
redirect_to("content.php");
}
?>
<?php
mysql_close($connection);
?>