<? include("login.php");
include("sol.php");?>
<TD align=middle width=590>
<TABLE cellSpacing=0 cellPadding=4 width=550 align=center
border=0><TBODY>
<TR vAlign=bottom>
<TD width="17%">
<TABLE class=dvd_info_small cellSpacing=0 cellPadding=0
width="100%" align=center border=0>
<TBODY>
<TR>
<TD align=middle>
<?
$page = $_GET["page"];
if($page==""){
echo "<div align='center'>
<center>
<table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' width='100%' id='AutoNumber1' height='31'>
<tr>
<td width='33%' bgcolor='#5988C2' align='center' height='12'><b>
<font face='Trebuchet MS' size='2' color='#FFFFFF'>film ismi</font></b></td>
<td width='33%' bgcolor='#5988C2' align='center' height='12'><b>
<font face='Trebuchet MS' size='2' color='#FFFFFF'>Degistir</font></b></td>
<td width='34%' bgcolor='#5988C2' align='center' height='12'><b>
<font face='Trebuchet MS' size='2' color='#FFFFFF'>Sil";
$a = mysql_query("SELECT * FROM film ORDER BY id DESC");
$q = mysql_query($a);
while($y=mysql_fetch_array($a)){
echo "</font></b></td>
</tr>
<tr>
<td width='33%' height='19' align='center'><a href='../k-film-".$y['isims']."-".$y['id'].".html'>".$y['adi']."</a></td>
<td width='33%' height='19' align='center'><a href='?page=edit&id=".$y['id']."'><img border='0' src='images/edit.gif'></a></td>
<td width='34%' height='19' align='center'><a onclick=\"return confirm('Emin misiniz?')\") href='?page=del&id=".$y['id']."'><img border='0' src='images/del.gif'></a>";
}
echo "</td>
</tr>
</table>
</center>
</div>";
}
?>
<?
$page = $_GET["page"];
if($page=="ekle"){
?>
<BR>
<TABLE class="title-header capitalize" cellSpacing=0 cellPadding=0
width=550 align=center border=0>
<TBODY>
<TR>
<TD width="100%">Film Ekle</TD></TR></TBODY></TABLE><BR>
<TABLE cellSpacing=0 cellPadding=0 width=546 align=center
border=0><TBODY> <FORM action=?page=eklendi method=post ><INPUT type=hidden
value=1 name=ix>
<TR height=25>
<TD align=left><b>Film</b><B> Adý :</B></TD>
<TD><INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=adi></TD></TR>
<TR height=25>
<TD align=left><b>Film</b><B> turu :</B></TD>
<TD><INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=tur></TD></TR>
<TR height=25>
<TD align=left><b>Film</b><B> Yönetmeni :</B></TD>
<TD><INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=yonetmen></TD></TR>
<TR height=25>
<TD align=left><b>Film</b><B> Oyuncuları :</B></TD>
<TD><INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=oyuncular></TD></TR>
<TD align=left><b>Film Linki</b><B>:</B></TD>
<TD><INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=link ></TD></TR>
<TR height=120>
<TD align=left><B>Açýklama :</B></TD>
<TD><TEXTAREA class=field style="WIDTH: 416px; HEIGHT: 259px" name=aciklama rows=6 cols=10></TEXTAREA></TD></TR>
<TD align=left></TD>
<TD><INPUT class=button type=submit value=Ekle></form></TD></TR></TBODY></TABLE>
<?}?>
<?
$page = $_GET["page"];
if($page=="eklendi"){
$adi = $_POST["adi"];
$isims = trsil($adi);
$tur = $_POST["tur"];
$yonetmen = $_POST["yonetmen"];
$oyuncular = $_POST["oyuncular"];
$link = $_POST["link"];
$aciklama = $_POST["aciklama"];
$q = "INSERT INTO film (adi,isims,tur,yonetmen,oyuncular,aciklama) VALUES ('$adi','$isims','$tur','£yonetmen','$oyuncular',' $aciklama')";
$a = mysql_query($q);
if($a){
echo "Basariyla eklendi!";
}else{
echo "HATA: film eklenemedi!";
}
}
?>
<?
$page = $_GET["page"];
if($page=="edit"){
$id = $_GET["id"];
$SQL = mysql_query("SELECT * FROM film WHERE id='$id'");
$KarAl = mysql_fetch_array($SQL);
$adi = $KarAl["adi"];
$link = $KarAl["link"];
$aciklama = $KarAl["aciklama"];
$tur = $KarAl["tur"];
$yonetmen = $KarAl["yonetmen"];
$oyuncular = $KarAl["oyuncular"];
$aciklama = str_replace("<br>", "\n", $aciklama);
$aciklama = str_replace("<br />", "\n", $aciklama);
echo '<BR>
<TABLE class="title-header capitalize" cellSpacing=0 cellPadding=0
width=550 align=center border=0>
<TBODY>
<TR>
<TD width="100%">film Düzenle</TD></TR></TBODY></TABLE><BR>
<TABLE cellSpacing=0 cellPadding=0 width=546 align=center
border=0><TBODY> <FORM action=?page=edit2&id='.$id.' method=post ><INPUT type=hidden
value=1 name=ix>
<TR height=25>
<TD align=left><b>film Adý :</b></TD>
<TD>
<INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=adi value="'.$adi.'"></TD></TR>
<TR height=25>
<TD align=left><b>film Resmi :</b></TD>
<TD>
<INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=link value="'.$link.'"></TD></TR>
<TR height=25>
<TD align=left><b>film Türü :</b></TD>
<TD>
<INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=link value="'.$tur.'"></TD></TR>
<TR height=25>
<TD align=left><b>film Yönetmeni :</b></TD>
<TD>
<INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=link value="'.$yonetmen.'"></TD></TR>
<TR height=25>
<TD align=left><b>film Oyuncuları :</b></TD>
<TD>
<INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=link value="'.$oyuncular.'"></TD></TR>
<TR height=120>
<TD align=left><b>Aciklama :</b></TD>
<TD>
<TEXTAREA class=field style="WIDTH: 416px; HEIGHT: 259px" name=aciklama rows=4 cols=7>'.$aciklama.'</TEXTAREA></TD></TR>
<TD align=left></TD>
<TD><INPUT class=button type=submit value=Kaydet></form>';
}
if($page=="edit2"){
$id = $_GET["id"];
$adi = $_POST["adi"];
$link = $_POST["link"];
$tur = $_POST["tur"];
$yonetmen = $_POST["yonetmen"];
$oyuncular = $_POST["oyuncular"];
$aciklama = $_POST["aciklama"];
$isims = trsil($adi);
$karEdit = mysql_query("UPDATE film SET adi='$adi', isims='$isims', link='$link',tur='$tur',yonetmen='$yonetmen' , oyuncular='$oyuncular' ,aciklama='$aciklama' WHERE id='$id'");
if($karEdit){
echo "Basariyla degistirildi!";
}else{
echo "Hata olustu.!";
}
}
if($page=="del"){
$id = $_GET["id"];
$karSil = mysql_query("DELETE FROM film WHERE id='$id'");
if($karSil){
echo "Basariyla silindi";
}else{
echo "Hata olustu!";
}
}
?>
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><BR><BR></TD></TR></TBODY></TABLE> </BODY></HTML>