-
Notifications
You must be signed in to change notification settings - Fork 0
/
deletedata.php
69 lines (52 loc) · 1.51 KB
/
deletedata.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
<!DOCTYPE html>
<html>
<head>
<title>Barbados Community College - Web Portal</title>
<link rel="shortcut icon" href="imgs/titleimg.gif" />
<link rel="stylesheet" type="text/css" href="style.css" media="screen" />
<link href = 'http://fonts.googleapis.com/css?family=Open+Sans' rel = 'stylesheet' = type = 'text/css'>
</head>
<body>
<div id = "wrap">
<div id = "header">
<img src="imgs/bcclogo.gif" alt="log" />
<span style="float: right; padding-top: 10px;"><img src="imgs/portal.png" alt="portal photo" width="" height="150px"/></span>
</div>
<div id = "menu">
<?php include("menu.php") ?>
</div>
<div id = "content">
<h1>Barbados Community College - Web Portal</h1>
<?php
//GET FORM DATA
$id = $_POST["ID"];
//ESTABLISH CONNECTION
$con = mysql_connect("localhost", "root", "");
//CONNECT TO DB
$db = mysql_select_db("my course");
//EXTRACT RESULTSET
$rs1 = mysql_query("DELETE FROM students WHERE student_id=$id");
if(!$con || !$db || !$rs1){
$error = "Error: ".mysql_error();
}
else{
header("Location: Success.php");
}
?>
<br/>
<br/>
<script>
function redirect() {
window.location.href= 'deletestudent.php'; // the redirect goes here
);
</script>
Success!
</div>
<div id = "footer">
<h3>Barbados Community College - Web Portal</h3>
<p>© 2000 - <?php echo date("Y"); ?>, The Barbados Community College<br/>
developed by: Khalil Greenidge & Romario Bates</p>
</p>
</div>
</body>
</html>