Code qui fonctionne pour ceux qui veulent :
<?php
include('a.php');
if(isset($_POST['env']))
{
foreach($_POST['inf'] as $id => $val)
{
mysql_query("UPDATE series_episodes SET
titre_episode = '".mysql_real_escape_string($val['titre_episode'])."',
dispo = ".(isset($val['dispo']) ? 1 : 0).",
vostfr = ".(isset($val['vostfr']) ? 1 : 0).",
ndl = '".mysql_real_escape_string($val['ndl'])."'
WHERE id_episode = ".intval($id));
}
if(isset($_POST['del']))
mysql_query("DELETE FROM series_episodes WHERE id_episode IN (".implode(',', array_map('intval', $_POST['del'])).")") or die (mysql_error());
}
$id_serie = intval($_GET['id_serie']);
$saison = intval($_GET['saison']);
echo '<form method="post" action="./series_episodes.php?id_serie='.$id_serie.'&saison='.$saison.'">
<table style="margin: auto; padding: auto; width: 65%;">
<tr>
<td>Titre épisode</td>
<td>Disponibilité</td>
<td>VOSTFR</td>
<td>Nom du lien</td>
<td>Supprimer</td>
</tr>';
$q = mysql_query('SELECT id_episode, id_serie, saison, num_episode, titre_episode, dispo, vostfr, ndl FROM series_episodes WHERE id_serie = '.$id_serie.' AND saison = '.$saison.' ORDER BY num_episode');
while($r = mysql_fetch_array($q))
{
echo '<tr>
<td>'.$saison.'x'.$r['num_episode'].' - <input type="text" name="inf['.$r['id_episode'].'][titre_episode]" size="40" value="'.$r['titre_episode'].'" /></td>
<td><input type="checkbox" name="inf['.$r['id_episode'].'][dispo]"'.($r['dispo'] == 1 ? ' checked="checked"' : '').' /></td>
<td><input type="checkbox" name="inf['.$r['id_episode'].'][vostfr]"'.($r['vostfr'] == 1 ? ' checked="checked"' : '').' /></td>
<td><input type="text" name="inf['.$r['id_episode'].'][ndl]" size="40" value="'.$r['ndl'].'" /></td>
<td><input type="checkbox" name="del[]" value="'.$r['id_episode'].'" /></td>
</tr>'."\n";
}
echo '<tr>
<td colspan="4"><br /><br /><input type="submit" name="env" value="Mettre à jour" /></td>
</tr>
</table>
</form>';
include('b.php');
?>
