<?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>