1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
$nb=$_GET["nb"];
$id=$_GET["id"];
$req="UPDATE materiel SET ";
$req2="UPDATE info_ip SET ";
$i=1;
foreach($_POST as $cle => $val)
{
if($i<=$nb)
$req.=$cle.'="'.stripSlashes($val).'",';
else
$req2.=$cle.'="'.stripSlashes($val).'",';
$i++;
}
$req=substr($req,0,strlen($req)-1);
$req2=substr($req2,0,strlen($req2)-1);
$req.=" WHERE id_mat='$id'";
$req2.=" WHERE id_mat='$id'";
echo $req."<br>";
echo $req2."<br>";
mssql_query($req,$id_connexion);
mssql_query($req2,$id_connexion); |