-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathadmin_sinav_ekle.php
102 lines (81 loc) · 2.17 KB
/
admin_sinav_ekle.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
<?php
include"database.php";
session_start();
if(!isset($_SESSION["AID"]))
{
echo"<script>window.open('admin_giris.php?mes=Hata...','_self');</script>";
}
?>
<!DOCTYPE html>
<html>
<head>
<title>E-OKUL</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<?php include"ust_kisayol.php";?>
<div id="section">
<?php include"yan_kisayol.php";?><br><br><br>
<h3 class="text">Hoşgeldiniz <?php echo $_SESSION["ANAME"]; ?></h3><br><hr><br>
<div class="content">
<h3 >Sınav Ekle</h3><br>
<?php
if(isset($_POST["submit"]))
{
$sq="insert into exam(ENAME,CLASS,SUB) values ('{$_POST["ename"]}','{$_POST["cla"]}','{$_POST["sub"]}')";
if($db->query($sq))
{
echo "<div class='success'>Başarılı</div>";
}
else
{
echo "<div class='error'>Hata</div>";
}
}
?>
<form method="post" action="<?php echo $_SERVER["PHP_SELF"];?>">
<div class="lbox">
<label> Sınav Adı</label><br>
<input type="text" class="input2" name="ename"><br><br>
</div>
<div class="lbox">
<label>Sınıf</label><br>
<select name="cla" required class="input2">
</div>
<?php
$sl="select DISTINCT(CNAME) from class";
$r=$db->query($sl);
if($r->num_rows>0)
{
echo "<option value=''>Seç</option>";
while($ro=$r->fetch_assoc())
{
echo "<option value='{$ro["CNAME"]}'>{$ro["CNAME"]}</option>";
}
}
?>
</select>
<br><br>
<label>Ders</label><br>
<select name="sub" required class="input3">
<?php
$s="select * from sub";
$re=$db->query($s);
if($re->num_rows>0)
{
echo "<option value=''>Seç</option>";
while($r=$re->fetch_assoc())
{
echo "<option value='{$r["SNAME"]}'>{$r["SNAME"]}</option>";
}
}
?>
</select>
<br><br>
</div>
<button type="submit" class="btn" name="submit">Onayla</button>
</form>
</div>
</div>
</body>
</html>