<?php 
    $conn = @mysql_connect ("localhost", "root") or die("Mysql baglanti hatasi"); 
    $database_conn = mysql_select_db("veritabani_adi", $conn) or die("Veritabani baglanti hatasi"); 
   
    mysql_select_db($database_conn, $conn); 
    $query_Recordset1 = "SELECT * FROM tb_ogr"; 
    $Recordset1 = mysql_query($query_Recordset1, $conn) or die(mysql_error()); 
    $row_Recordset1 = mysql_fetch_assoc($Recordset1); 
    $totalRows_Recordset1 = mysql_num_rows($Recordset1); 
  ?> 
  <form name="form2" method="post" action=""> 
    <p>Ögrenci No<input name="ara_ogrno" type="text" id="ara_ogrno"> </p> 
    <p><input type="submit" name="Submit2" value="Submit"></p> 
  </form> 
   
  <?php 
  if (isset($_POST['ara_ogrno'])) { 
  	$query_Recordset1 = "SELECT * FROM tb_ogr where OGRNO='$_POST[ara_ogrno]'"; 
  	$Recordset1 = mysql_query($query_Recordset1, $conn) or die(mysql_error()); 
  	$row_Recordset1 = mysql_fetch_assoc($Recordset1); 
  	$totalRows_Recordset1 = mysql_num_rows($Recordset1); 
  	if ($totalRows_Recordset1 == 0) exit("Aradiginiz ögrenci numarasi kayitli degil."); 
  } 
  else exit("Düzeltme yapmak istediginiz ögrencinin numarasini giriniz."); 
  ?> 
   
  <form action="kayit.php" method="post" name="form1"> 
    <table width="524" border="0"> 
      <tr> 
        <td>Ögrenci Numarasi </td> 
        <td><input name="txt_ogrno" type="text" id="txt_ogrno" value="<?php if (isset($_POST['ara_ogrno'])) echo $row_Recordset1['OGRNO']; ?>"></td> 
      </tr> 
      <tr> 
        <td>Adi;</td> 
        <td><input name="txt_ad" type="text" id="txt_ad" value="<?php if (isset($_POST['ara_ogrno'])) echo $row_Recordset1['ADI']; ?>"></td> 
      </tr> 
      <tr> 
        <td>Soyadi</td> 
        <td><input name="txt_soyad" type="text" id="txt_soyad" value="<?php if (isset($_POST['ara_ogrno'])) echo $row_Recordset1['SOYADI']; ?>"></td> 
      </tr> 
      <tr> 
        <td>Cinsiyeti</td> 
        <td><select name="cinsiyet"> 
          <option value="E" <?php if (!(strcmp("E", $row_Recordset1['CINSIYET']))) {echo "SELECTED";} ?>>E</option> 
          <option value="K" <?php if (!(strcmp("K", $row_Recordset1['CINSIYET']))) {echo "SELECTED";} ?>>K</option> 
   
        </select></td> 
      </tr> 
      <tr> 
        <td>Adres</td> 
        <td><textarea name="txt_adres" cols="30" rows="3" id="txt_adres"><?php echo $row_Recordset1['ADRES']; ?></textarea></td> 
      </tr> 
    </table> 
    <input type="reset" name="Reset" value="Reset"> 
    <input type="submit" name="submit" value="Submit"> 
  </form>