-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathogrenci.php
121 lines (98 loc) · 2.52 KB
/
ogrenci.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
<?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">
<h3 class="text">Hoşgeldiniz <?php echo $_SESSION["ANAME"]; ?></h3><br><hr><br>
<div class="content">
<h3 >Öğrenci Görüntüle</h3><br>
<form method="post" action="<?php echo $_SERVER["PHP_SELF"];?>">
<div class="lbox1">
<label>Takım</label><br>
<select name="cla" required class="input3">
<?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>
</div>
<button type="submit" class="btn" name="view">Tıkla</button>
</form>
<br>
<div class="Output">
<?php
if(isset($_POST["view"]))
{
echo "<h3>Öğrenci Detayları</h3><br>";
$sql="select * from student where SCLASS='{$_POST["cla"]}'";
$re=$db->query($sql);
if($re->num_rows>0)
{
echo '
<table border="1px">
<tr>
<th>No</th>
<th>ID</th>
<th>Ad</th>
<th>Doğum Tarihi</th>
<th>Cinsiyet</th>
<th>Telefon</th>
<th>Mail</th>
<th>Adres</th>
<th>Takım</th>
<th>Fotoğraf</th>
</tr>
';
$i=0;
while($r=$re->fetch_assoc())
{
$i++;
echo "
<tr>
<td>{$i}</td>
<td>{$r["ID"]}</td>
<td>{$r["NAME"]}</td>
<td>{$r["DOB"]}</td>
<td>{$r["GEN"]}</td>
<td>{$r["PHO"]}</td>
<td>{$r["MAIL"]}</td>
<td>{$r["ADDR"]}</td>
<td>{$r["SCLASS"]}</td>
<td><img src='{$r["SIMG"]}' height='70' width='70'></td>
</tr>
";
}
}
else
{
echo "Kayıt Bulunamadı";
}
echo "</table>";
}
?>
</div>
</div>
</div>
</body>
</html>