<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Kayıt Formu</title>

</head>

<body>

<?php
/*error_reporting(0);
$baglan=@mysql_connect("localhost","root","");
if(!$baglan) die("mySQL bağlantı Hatası");
mysql_select_db("panel",$baglan) or die("Veritabanı bağlantı hatası");
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8_general_ci");
*/
include("baglan.php");
$okulturu=$_GET["okulturu"];
$id=$_GET["id"];
$sorgu="select * from $okulturu where id=$id";
$veri=mysqli_query($baglan,$sorgu);
while($oku = mysqli_fetch_assoc($veri))
{
?>
<form action="" method="post" enctype="multipart/form-data">
<table width="1000" border="1" cellpadding="0" cellspacing="0" >
   <tr>
     <td width="307" height="71"><img src="indir.png" width="307" height="76" /></td>
    <td colspan="2" id="form1" align="center">ÖN KAYIT BAŞARI FORMU </td>
    <td width="241">&nbsp;&nbsp;Başvuru No: <?php echo $oku["osekil"].$oku["id"];?></div></td>
   
    </tr>
  <tr>
    <td colspan="4" align="center" id="form1"> I.BÖLÜM - ÖĞRENCİ ÖN BİLGİ FORMU (KAYIT DANIŞMANI)</td>
    </tr>
  <tr>
    <td colspan="4" align="center" id="form1">Öğrenci Bilgileri</td>
    </tr>
  <tr>
    <td width="307" height="35">&nbsp;&nbsp;Öğrenci Adı Soyadı</td>
    <td width="271">&nbsp;&nbsp;&nbsp;<input name="ad" type="text" id="ad" value="<?php echo $oku["ad"];?>" /></td>
    <td width="171">&nbsp;&nbsp;Doğum Tarihi</td>
    <td width="241">&nbsp;&nbsp;&nbsp;<input name="dtarih" type="text" id="dtarih" value="<?php echo $oku["dtarih"];?>" /></td>
  </tr>
  <tr>
    <td width="307" height="35">&nbsp;&nbsp;Geldiği Okul</td>
    <td width="271">&nbsp;&nbsp;&nbsp;<input name="okul" type="text" id="okul" value="<?php echo $oku["okul"];?>" /></td>
    <td width="171">&nbsp;&nbsp;TC Kimlik No</td>
    <td width="241">&nbsp;&nbsp;&nbsp;<input name="no" type="text" id="no" value="<?php echo $oku["no"];?>" /></td>
  </tr>
  <tr>
    <td width="307" height="35">&nbsp;&nbsp;Okuyacağı Sınıf</td>
    <td width="271">&nbsp;&nbsp;&nbsp;<input name="sinif" type="text" id="sinif" value="<?php echo $oku["sinif"];?>" /></td>
    <td width="171">&nbsp;&nbsp;Başvuru Tarihi</td>
    <td width="241">&nbsp;&nbsp;&nbsp;<input name="btarih" type="text" id="btarih" value="<?php echo $oku["btarih"];?>" /></td>
  </tr>
  <tr>
    <td width="307" height="35">&nbsp;&nbsp;LGS Puanı</td>
    <td width="271">&nbsp;&nbsp;&nbsp;<input name="puan" type="text" id="puan" value="<?php echo $oku["puan"];?>" /></td>
    <td width="307">&nbsp;&nbsp;Okul Türü</td>
     <td width="271">&nbsp;&nbsp;
     <input name="osekil" type="text" id="osekil" value="<?php echo $oku["osekil"];?>" />
      </td>
    </tr>
  <tr>
   <td colspan="4" align="center" id="form1">Aile Bilgileri</td>
    </tr>
  <tr>
    <td width="307" height="35">&nbsp;&nbsp;Anne Adı</td>
    <td width="271" height="35">&nbsp;&nbsp;&nbsp;<input name="anne" type="text" id="anne" value="<?php echo $oku["anne"];?>" /></td>
    <td width="171" height="35">&nbsp;&nbsp;Baba Adı</td>
    <td width="241" height="35">&nbsp;&nbsp;&nbsp;<input name="baba" type="text" id="baba" value="<?php echo $oku["baba"];?>" /></td>
  </tr>
  <tr>
   <td width="307" height="35">&nbsp;&nbsp;Telefon</td>
    <td width="271">&nbsp;&nbsp;&nbsp;<input name="tel1" type="text" id="tel1"  value="<?php echo $oku["tel1"];?>" /></td>
    <td width="171" height="35">&nbsp;&nbsp;Telefon</td>
    <td width="241">&nbsp;&nbsp;&nbsp;<input name="tel2" type="text" id="tel2" value="<?php echo $oku["tel2"];?>" /></td>
  </tr>
  <tr>
    <td width="307" height="35">&nbsp;&nbsp;Mesleği</td>
    <td width="271">&nbsp;&nbsp;&nbsp;<input name="mes1" type="text" id="mesl" value="<?php echo $oku["mes1"];?>" /></td>
    <td width="171" height="35">&nbsp;&nbsp;Mesleği</td>
    <td width="241">&nbsp;&nbsp;&nbsp;<input name="mes2" type="text" id="mes2" value=" <?php echo $oku["mes2"];?>" /></td>
  </tr>
  <tr>
   <td colspan="4" height="81">&nbsp;&nbsp;Adres Bilgisi:&nbsp;&nbsp;&nbsp;
     <input name="adres" type="text"  size="100" id="adres" value=" <?php echo $oku["adres"];?>"  /></td>
    </tr>
  <tr>
    <td colspan="4" height="80" align="center" id="form1">OKULUMUZDAN HABERDAR OLMA ŞEKLİNİZ<p><?php echo $oku["16"];?></p></td>
    </tr>
  <tr>
    <td height="78" colspan="2" id="form1">&nbsp;&nbsp;Ön Görüşmeyi Yapan (Formu Dolduran) Danışman:&nbsp;&nbsp;&nbsp;<input name="dnsmn" type="text" id="dsmn" value="<?php echo $oku["dnsmn"];?>" /></td>
    <td colspan="2" rowspan="2" id="form1">&nbsp;&nbsp;Görüşme Notları:&nbsp;&nbsp;&nbsp;
      &nbsp;&nbsp;&nbsp;
      <textarea name="not" id="not"><?php echo $oku["nott"]?></textarea></td>
    </tr>
  <tr>
    <td height="75" colspan="2" id="form1">&nbsp;&nbsp;Yönlendirilen İdareci:&nbsp;&nbsp;&nbsp;<input name="idare" type="text" id="idare" value="<?php echo $oku["idare"];?>" /></td>
    </tr>
     <tr>
    <td colspan="4" align="center" id="baslik"> II.BÖLÜM - OKUL İDARESİ GÖRÜŞMESİ </td>
    </tr>
    <tr>
   <td height="35" colspan="4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Açıklama:&nbsp;&nbsp;<input name="aciklama" type="text" value="<?php echo $oku["aciklama"];?>" size="100" /></td>
    </tr>
  <tr>
    <td height="65" colspan="2"><input name="ob" type="checkbox" <?php if($oku["ob"]=='Okul bilgilendirmesi yapıldı.'){ echo "checked='checked'";};?> value="Okul bilgilendirmesi yapıldı."/>Okul bilgilendirmesi yapıldı.</td>
    <td height="65" colspan="2"><input name="veli" type="radio"  value="Anne" <?php if($oku["veli"]=='Anne'){ echo "checked='checked'";};?>/>Anne
     <input name="veli" type="radio" value="Baba" <?php if($oku["veli"]=='Baba'){ echo "checked='checked'";};?>/>Baba
     <input name="veli" type="radio" value="bos" <?php if($oku["veli"]=='bos'){ echo "checked='checked'";};?>/>...</td>
    </tr>
    <tr>
    <td height="74" colspan="2"><input name="om" type="checkbox"<?php if($oku["om"]=='Öğrenci ile mülakat yapıldı.'){ echo "checked='checked'";};?> value="Öğrenci ile mülakat yapıldı." />Öğrenci ile mülakat yapıldı.</td>
    <td height="74" colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
    </tr>
    <tr>
    <td height="68" colspan="2"><input name="ss" type="checkbox" <?php if($oku["ss"]=='Seviye sınıfı belirlendi'){ echo "checked='checked'";};?>  value="Seviye sınıfı belirlendi" />Seviye sınıfı belirlendi.</td>
    <td height="68" colspan="2">Sınav Tarihi :<input name="starih" type="text"  value="<?php echo $oku["starih"];?>"  />
      <p>Sınav Yeri :<input name="syeri" type="text" value="<?php echo $oku["syeri"];?>" /></p></td>
    </tr>
    <tr>
    <td height="65" colspan="2"><input name="sg" type="checkbox" <?php if($oku["sg"]=='Sonuç görüşmesi yapıldı'){ echo "checked='checked'";};?> value="Sonuç görüşmesi yapıldı" />Sonuç görüşmesi yapıldı.</td>
    <td height="65" colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
    </tr>
    <tr>
    <td height="62" colspan="2"><input name="sn" type="checkbox" <?php if($oku["sn"]=='Sınav sonucu ve sözleşme verildi.'){ echo "checked='checked'";};?> value="Sınav sonucu ve sözleşme verildi." />Sınav sonucu ve sözleşme verildi.</td>
    <td height="62" colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
    </tr>
    <tr>
    <td height="35" colspan="4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ad Soyad <input name="adsoyad1" type="text"  value="<?php echo $oku["adsoyad1"];?>"/></td>
    </tr>
<tr>
    <td height="75" colspan="4" id="form1" class="text-center">&nbsp;&nbsp;<input type="submit" class="btn btn-danger" value="Güncelle" name="guncelle"  />&nbsp;&nbsp;<input type="button" class="btn btn-success" onclick="window.print();" value="Yazdır" /></td>
    </tr>
   
</table>
</form>
<?php
if($_POST['guncelle']) {

	

		$guncelle=mysqli_query($baglan,"update $okulturu set aciklama='".$_POST['aciklama']."' , adsoyad1='".$_POST['adsoyad1']."' , starih='".$_POST['starih']."', syeri='".$_POST['syeri']."', veli='".$_POST['veli']."', ob='".$_POST['ob']."', om='".$_POST['om']."', ss='".$_POST['ss']."', sg='".$_POST['sg']."', sn='".$_POST['sn']."' where id='$id'");

	}
	
}
?>
</body>
</html>