1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
| <?
if ($btn!="")
{
$max=count($tableau);
if ($max>0)
{ for ($i=0; $i<$max; $i++)
{
foreach($_POST['option'] as $var => $var1)
{
$req="update table1 set ";
$req.="op=".$option." ";
$req.="where id=".$tableau[$i];
print $req;
if (!$res=mysql_query($req)) {print $req."<br>".mysql_error();}
}
}
}
?>
<html>
<head>
<title></title>
</head>
<body bgcolor="#FFFFFF" cellpadding="0" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<a name="PAGEhaut"></a>
<br>
<form method="post" action="candILLI.php" name="FORM" style="display:inline;margin:0">
<table width="600" border="0" cellspacing="0" cellpadding="2" class="xxARIALx09">
<tr>
<td align="right" valign="top" height="30"></td>
<td valign="top" height="30"></td>
</tr>
<?
$req="select id, nom, prenom, adresse from table where id=12 ";
if ($res=mysql_query($req))
{ if (mysql_num_rows($res)>0)
{ ?>
<tr ><td colspan="2"></td></tr>
<tr>
<td></td>
<td valign="top">
<table width="530" border="0" cellspacing="0" cellpadding="2" >
<?
while ($row=mysql_fetch_array($res))
{
$id=$row['id'];
$nom=$row["nom"];
$prenom=$row["prenom"];
$adresse=$row["adresse"];
?>
<tr >
<td>
<input type="checkbox" name="tableau[]" value="<? print $id; ?>" <? print $coche; ?>><? print $nom; ?><? print $prenom; ?><? print $adresse; ?></td>
<td valign="top">
ok
<select name="option[]" style="width:50">
<? for ($x=0;$x<2;$x++) { if ($x==$option) {$coche="selected";} else {$coche="";} ?>
<option value="<? print $x; ?>" <? print $coche; ?>>oui/non</option>
<? } ?>
</select>
</td>
</tr>
<? } ?>
<tr>
</td>
</tr>
</table>
</td>
</tr>
<? }
?>
<tr><td align="right" valign="top" colspan="2">
<input type="submit" name="btn" class="<? print $fltPAYS; ?>BOUTON" value="Valider"></td></tr>
<tr><td align="right" valign="top" colspan="2" height="20"></td></tr>
</table>
</form>
<br>
</body>
</html> |
Partager