-
Notifications
You must be signed in to change notification settings - Fork 0
/
add_class.php
123 lines (103 loc) · 2.83 KB
/
add_class.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
<?php
include"database.php";
session_start();
if(!isset($_SESSION["AID"]))
{
echo"<script>window.open('index.php?mes=Access Denied...','_self');</script>";
}
?>
<!DOCTYPE html>
<html>
<head>
<title>ASP</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<?php include"navbar.php";?><br>
<!-- <img src="img/1.jpg" style="margin-left:90px;" class="sha"> -->
<div id="section">
<?php include"sidebar.php";?><br>
<h3 class="text">Welcome <?php echo $_SESSION["ANAME"]; ?></h3><br><hr><br>
<div class="content1">
<h3 > Add Class Details</h3><br>
<?php
if(isset($_POST["submit"]))
{
$sq="insert into class(CNAME,CSEC) values('{$_POST["cname"]}','{$_POST["sec"]}')";
if($db->query($sq))
{
echo "<div class='success'>Insert Success..</div>";
}
else
{
echo "<div class='error'>Insert failed..</div>";
}
}
?>
<form method="post" action="<?php echo $_SERVER["PHP_SELF"];?>">
<label>Batch</label><br>
<select name="cname" required class="input2">
<option value="">Select</option>
<option value="17-1">17-1</option>
<option value="17-2">17-2</option>
<option value="17-3">17-3</option>
<option value="18-1">18-1</option>
<option value="18-1">18-2</option>
<option value="18-1">18-3</option>
</select><br><br>
<label>Section </label><br>
<select name="sec" required class="input2">
<option value="">Select</option>
<option value="-">-</option>
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
<option value="D">D</option>
<option value="E">E</option>
<option value="F">F</option>
</select>
<br>
<button type="submit" class="btn" name="submit">Add Class Details</button>
</form>
</div>
<div class="tbox">
<h3 style="margin-top:30px;"> Class Details</h3><br>
<?php
if(isset($_GET["mes"]))
{
echo"<div class='error'>{$_GET["mes"]}</div>";
}
?>
<table border="1px" >
<tr>
<th>S.No</th>
<th>Batch</th>
<th>Section</th>
<th>Delete</th>
</tr>
<?php
$s="select * from class";
$res=$db->query($s);
if($res->num_rows>0)
{
$i=0;
while($r=$res->fetch_assoc())
{
$i++;
echo "
<tr>
<td>{$i}</td>
<td>{$r["CNAME"]}</td>
<td>{$r["CSEC"]}</td>
<td><a href='delete.php?id={$r["CID"]}' class='btnr'>Delete</a></td>
</tr>
";
}
}
?>
</table>
</div>
</div>
<?php include"footer.php";?>
</body>
</html>