<?php
include("sol.php");



?>

<?php
$kategoriler_sorgu = mysql_query("SELECT * FROM kategoriler ORDER BY kat_baslik");
$kategoriler = "";
while ($yaz = mysql_fetch_array($kategoriler_sorgu)) {

$kategoriler .= "<option value=". $yaz['kat_id'] .">". $yaz['kat_baslik'] ."</option>";

}
?>

<TD align=middle width=590>

<?
$ix = $_POST['ix'];
if($ix == "1"){
$adi = ($_POST['adi']);
$tur = ($_POST['tur']);
$kat_id = $_POST['kategori'];
$yonetmen = ($_POST['yonetmen']);
$oyuncular = ($_POST['oyuncular']);
$aciklama = ($_POST['aciklama']);
$kat_id = $_POST['kategori'];


mysql_query("Insert Into film (adi,kat_id,tur,yonetmen,oyuncular,aciklama) values ('$adi','$kat_id','$tur','$yonetmen','$oyuncular', '$aciklama'");

echo "Fikra eklendi";
echo mysql_error();
}else{

?>

<BR>
<TABLE class="title-header capitalize" cellSpacing=0 cellPadding=0
width=550 align=center border=0>
<TBODY>
<TR>
<TD width="100%">Fýkra Ekle</TD></TR></TBODY></TABLE><BR>
<TABLE cellSpacing=0 cellPadding=0 width=546 align=center
border=0><TBODY> <FORM action=fikraekle.php method=post ><INPUT type=hidden
value=1 name=ix>
<TR height=25>
<TD align=left><B>Adi :</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 Türü :</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 Yönetmeni :</B></TD>
<TD><INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=yonetmen ></TD></TR>
<tr>
<td>Kategoriler :</td>
<td>

<select name="kategori">
<?php
echo $kategoriler;
?>
</select>
</td></tr>
<TR height=25>
<TD align=left><B>Film Oyunculari :</B></TD>
<TD><INPUT class=field style="WIDTH: 200px; HEIGHT: 20px"
size=10 name=oyuncular ></TD></TR>

<TR height=120>
<TD align=left><b>Film Konusu :</b></TD>
<TD><TEXTAREA class=field style="WIDTH: 416px; HEIGHT: 259px" name=aciklama rows=6 cols=10></TEXTAREA></TD></TR>


</select></TD></TR>

<TR height=35>
<TD align=left></TD>
<TD><INPUT class=button type=submit value=Düzenle name=send_button></TD></TR></TBODY></TABLE>
<?}?></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></FORM></BODY></HTML>