<?php
require 'connect.php';
if ( isset($_POST['id2'])&& isset($_POST['cat2']) && ($_POST['id2']!="") && ($_POST['cat2']!="") ){
$id_update=$_POST['id2'];
$cat_update=$_POST['cat2'];
$ricevuta_update = mysql_query("SELECT ID , Titolo, Categoria, Datains, Anno, Locandina, Cast, Trama FROM $cat_update WHERE ID='$id_update'");
while ($row = mysql_fetch_array($ricevuta_update, MYSQL_BOTH)) {
$titolo2 = $row[1];
$_POST['anno2']= $row[4];
$cast2=$row[6];
$trama2=$row[7];
$titolo2=stripslashes($titolo2);
$cast2=stripslashes($cast2);
$trama2=stripslashes($trama2);
if ($row[3] < "2013-02-10 00:00:01") {
$titolo2 = HtmlEntities($titolo2);
$cast2 = HtmlEntities($cast2);
$trama2 = HtmlEntities($trama2);
}
$_POST['tit2']=$titolo2;
$_POST['cast2']=$cast2;
$_POST['trama2']=$trama2;
}
}
?>
<table border="1" width="800" id="admin_update" align="left">
<tr align="left">
<td colspan="6" width="700" align="left">
<span style='color:#900;font-size:20px'>Aggiornamento Film</span>
</td>
</tr>
<tr align="left">
<td width="50" align="left">
<span >ID</span>
</td>
<td width="300" align="left">
<span >Titolo</span>
</td>
<td width="110" align="left">
<span >Categoria</span>
</td>
<td width="50" align="left">
<span >Anno</span>
</td>
<td align="left">
</td>
<td align="right">
</td>
</tr>
<form action="admin/update_film.php" enctype="multipart/form-data" name="update_film" method="post" id="update_film" target="popup"
>
<tr align="left">
<td width="50" align="left">
<input size="4" type="text" maxlength="4" id="id2" name="id2" value="<?php echo $_POST['id2']; ?>" />
</td>
<td width="300" align="left">
<input size="45" type="text" maxlength="45" id="tit2" name="tit2" value="<?php echo $_POST['tit2']; ?>" />
</td>
<td width="110" align="left">
<select name="cat2" id="cat2" <?php echo $_POST['cat2']; ?>>
<option selected></option>
<option <?php if (($_POST['cat2'])=="Animazione") {?> selected <?php }?> >Animazione</option>
<option <?php if (($_POST['cat2'])=="Avventura") {?> selected <?php }?> >Avventura</option>
<option <?php if (($_POST['cat2'])=="Azione") {?> selected <?php }?> >Azione</option>
<option <?php if (($_POST['cat2'])=="Commedia") {?> selected <?php }?> >Commedia</option>
<option <?php if (($_POST['cat2'])=="Drammatico") {?> selected <?php }?> >Drammatico</option>
<option <?php if (($_POST['cat2'])=="Fantascienza") {?> selected <?php }?> >Fantascienza</option>
<option <?php if (($_POST['cat2'])=="Fantasy") {?> selected <?php }?> >Fantasy</option>
<option <?php if (($_POST['cat2'])=="Guerra") {?> selected <?php }?> >Guerra</option>
<option <?php if (($_POST['cat2'])=="Horror") {?> selected <?php }?> >Horror</option>
<option <?php if (($_POST['cat2'])=="Musical") {?> selected <?php }?> >Musical</option>
<option <?php if (($_POST['cat2'])=="Poliziesco") {?> selected <?php }?> >Poliziesco</option>
<option <?php if (($_POST['cat2'])=="SerieTv") {?> selected <?php }?> >SerieTv</option>
<option <?php if (($_POST['cat2'])=="Storico") {?> selected <?php }?> >Storico</option>
<option <?php if (($_POST['cat2'])=="Thriller") {?> selected <?php }?> >Thriller</option>
<option <?php if (($_POST['cat2'])=="Western") {?> selected <?php }?> >Western</option>
<option <?php if (($_POST['cat2'])=="Prova") {?> selected <?php }?> >Prova</option>
</select>
</td>
<td width="50" align="left">
<input size="4" type="text" maxlength="4" id="anno2" name="anno2" value="<?php echo $_POST['anno2']; ?>" />
</td>
<td width="50" align="left">
<input type="file" name="uploadfile2" id="uploadfile2" size="6" />
</td>
<td align="right">
<input type="submit" onclick="window.open('','popup','width=480,height=250,resizable=no,scrollbars=yes, location=no');" value="Aggiorna" />
</td>
</tr>
<tr align="left">
<td colspan="2" width="350" align="left">
<textarea cols="30" rows="3" title="Cast2" id="cast2" name="cast2" value="<?php echo $_POST['cast2']; ?>" ><?php if (isset($_POST['cast2']))
{echo $_POST['cast2'];}else { echo "Inserisci il Cast";} ?></textarea>
</td>
<td colspan="3" width="350" align="left">
<textarea cols="30" rows="3" title="Trama2" id="trama2" name="trama2" value="<?php echo $_POST['trama2']; ?>" ><?php if (isset($_POST['trama2']))
{echo $_POST['trama2'];}else { echo "Inserisci la Trama";} ?></textarea>
</td>
<td width="50" align="left">
<input type="button" onclick="document.update_film.cast2.value='Inserisci il Cast';document.update_film.trama2.value='Inserisci la Trama';
document.update_film.anno2.value='';document.update_film.cat2.value='';document.update_film.tit2.value='';document.update_film.id2.value='';
document.update_film.uploadfile2.value='';" value="Reset" />
</td>
</tr>
<tr align="left">
<td colspan="6" align="right">
<input name="check_update" type="submit" onclick="this.form.action='amministrazione.php';this.form.target='_self'" value="Compilazione automatica" />
</td>
</tr>
</form>
<br>
<tr align='left'>
<td colspan="6" width='800' align='left'>
<span style='color:#900;font-size:20px'>--------------------------------------------------------------------------------------------------------------</span>
</td></tr>
</table>