<html>
<head>
<title>KAYIT LİSTELEME MENÜSÜ</title>
</head>
</body>
<?php
include("baglanti.php");
$ogr_no=$_POST["ogr_no"];
$ogr_adi=$_POST["ogr_adi"];
$ogr_soyadi=$_POST["ogr_soyadi"];
$puan=$_POST["puan"];
$sorgu=mysqli_query($baglanti,"SELECT * from ogrenci where ogr_no='$ogr_no'");
$sorgu2=mysqli_query($baglanti,"SELECT * from ogrenci where ogr_adi='$ogr_adi'");
$sorgu3=mysqli_query($baglanti,"SELECT * from ogrenci where ogr_soyadi='$ogr_soyadi'");
$sorgu4=mysqli_query($baglanti,"SELECT * from ogrenci where puan='$puan'");
$sorgu5=mysqli_query($baglanti,"SELECT * from ogrenci");
if($sorgu){
$kayit_sayisi=mysqli_num_rows($sorgu);
for ($i=1;$i<=$kayit_sayisi;$i++){
$kayit=mysqli_fetch_array($sorgu);
echo $kayit["ogr_no"],"-",$kayit["ogr_adi"]," ",$kayit["ogr_soyadi"],"-",$kayit["puan"];
echo "<br>-------------------------------<br>";
}
}
if ($sorgu2)
{
$kayit_sayisi=mysqli_num_rows($sorgu2);
for ($i=1;$i<=$kayit_sayisi;$i++){
$kayit=mysqli_fetch_array($sorgu2);
echo $kayit["ogr_no"],"-",$kayit["ogr_adi"]," ",$kayit["ogr_soyadi"],"-",$kayit["puan"];
echo "<br>-------------------------------<br>";
}
}
if($sorgu3)
{
$kayit_sayisi=mysqli_num_rows($sorgu3);
for ($i=1;$i<=$kayit_sayisi;$i++){
$kayit=mysqli_fetch_array($sorgu3);
echo $kayit["ogr_no"],"-",$kayit["ogr_adi"]," ",$kayit["ogr_soyadi"],"-",$kayit["puan"];
echo "<br>-------------------------------<br>";
}
}
if($sorgu4)
{
$kayit_sayisi=mysqli_num_rows($sorgu4);
for ($i=1;$i<=$kayit_sayisi;$i++){
$kayit=mysqli_fetch_array($sorgu4);
echo $kayit["ogr_no"],"-",$kayit["ogr_adi"]," ",$kayit["ogr_soyadi"],"-",$kayit["puan"];
echo "<br>-------------------------------<br>";
}
}
else{
$kayit_sayisi=mysqli_num_rows($sorgu5);
for ($i=1;$i<=$kayit_sayisi;$i++){
$kayit=mysqli_fetch_array($sorgu5);
echo $kayit["ogr_no"],"-",$kayit["ogr_adi"]," ",$kayit["ogr_soyadi"],"-",$kayit["puan"];
echo "<br>-------------------------------<br>";
}
}
?>
</body>
</html>