<?php

$host="localhost"; $vt_adi="kitap"; $kullanici="root"; $sifre="";

$hareket=$_GET['hareket'];
$hareket2=$_POST['hareket'];
$sira=$_GET['sira'];
$db = mysql_select($server, $kullaniciadi, $sifre)or die("sunucu kapalı veya hesap bilgileri yanlış");
$test=@mysql_select_db($vt_adi, $db)or die("veritabnı adı yanlış");
if ($hareket=='guncelle' or $hareket2=='ekle'){
	if ($hareket == 'ekle'){ 
	include("./form3.php"); 
	print "<input type = hidden name=ekle1 value=1>\n";
	}else{
		$sorgu= mysql_query("SELECT * FROM ilktablo WHERE (sira=$sira)",$db);
		$sonuc=mysql_fetch_array($sorgu);
		include("./form3.php");
		print "<input type = hidden name=guncelle1 value=1>\n"; 
		}
	print "</table><input type=submit value=KAYDET></form>\n";
	exit;
	}
	
if ($hareket==sil){
		$q="DELETE FROM ilktablo WHERE (sira=$sira)";
		$sorgu=mysql_query($q);
		print"<meta http-equiv='refresh' content=\"0; URL=$PHP_SELF\">";
		}elseif($guncelle1){
		$q="UPDATE  ilktablo SET sira='$sira' no='$no' adsoyad='$adsoyad' yazili1='$yazili1' yazili2='$yazili2' WHERE (sira=$sira)";
		$sorgu=mysql_query($q);
		print"<meta http-equiv='refresh' content=\"0; URL=$PHP_SELF\">";	
		}
print "<TABLE border=1><tr><td>sıra</td> <td>no</td> <td>adsoyad</td><td>yazılı1</td><td>yazılı2</td> <td></td>  <td></td> <tr>\n";
$sorgu=mysql_query("SELECT*FROM ilktablo",$db);
while ($s=mysql_fetch_row($sorgu)){
echo"<TR><td>".$s[0]."</td> <td>.$s[1].</td> <td>.$s[2].</td> <td>.$s[3].</td> <td>.$s[4].</td><td>\n";
echo "<a href=\"$PHP_SELF?hareket=guncelle&sira=".$s[0]."\">Guncelle</a></td></td>";
echo "<a href=\"$PHP_SELF?hareket=sil&sira=".$s[0]."\">sil</a></td></tr>\n";
}		
print "</table><form action=\"\" method=POST">\n";
print "<input type=\"hidden"\ name=\"hareket"\ value=\"ekle\">\n";

print "<INPUT type=submit value=\"EKLE\"></form>";
mysql_close($db);


?>

<?php

$host="localhost"; $vt_adi="kitap"; $kullanici="root"; $sifre="";

$hareket=$_GET['hareket'];
$hareket2=$_POST['hareket'];
$sira=$_GET['sira'];
$db = mysql_select($server, $kullaniciadi, $sifre)or die("sunucu kapalı veya hesap bilgileri yanlış");
$test=@mysql_select_db($vt_adi, $db)or die("veritabnı adı yanlış");
if ($hareket=='guncelle' or $hareket2=='ekle'){
	if ($hareket == 'ekle'){ 
	include("./form3.php"); 
	print "<input type = hidden name=ekle1 value=1>\n";
	}else{
		$sorgu= mysql_query("SELECT * FROM ilktablo WHERE (sira=$sira)",$db);
		$sonuc=mysql_fetch_array($sorgu);
		include("./form3.php");
		print "<input type = hidden name=guncelle1 value=1>\n"; 
		}
	print "</table><input type=submit value=KAYDET></form>\n";
	exit;
	}
	
if ($hareket==sil){
		$q="DELETE FROM ilktablo WHERE (sira=$sira)";
		$sorgu=mysql_query($q);
		print"<meta http-equiv='refresh' content=\"0; URL=$PHP_SELF\">";
		}elseif($guncelle1){
		$q="UPDATE  ilktablo SET sira='$sira' no='$no' adsoyad='$adsoyad' yazili1='$yazili1' yazili2='$yazili2' WHERE (sira=$sira)";
		$sorgu=mysql_query($q);
		print"<meta http-equiv='refresh' content=\"0; URL=$PHP_SELF\">";	
		}
print "<TABLE border=1><tr><td>sıra</td> <td>no</td> <td>adsoyad</td><td>yazılı1</td><td>yazılı2</td> <td></td>  <td></td> <tr>\n";
$sorgu=mysql_query("SELECT*FROM ilktablo",$db);
while ($s=mysql_fetch_row($sorgu)){
echo"<TR><td>".$s[0]."</td> <td>.$s[1].</td> <td>.$s[2].</td> <td>.$s[3].</td> <td>.$s[4].</td><td>\n";
echo "<a href=\"$PHP_SELF?hareket=guncelle&sira=".$s[0]."\">Guncelle</a></td></td>";
echo "<a href=\"$PHP_SELF?hareket=sil&sira=".$s[0]."\">sil</a></td></tr>\n";
}		
echo '</table><form action=.'$PHP_SELF'. method=POST"><br>';
echo '<input type="hidden" name="hareket" value="ekle"><br>';

print "<INPUT type=submit value=\"EKLE\"></form>";
mysql_close($db);


?>