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 87 88 89 90 91 92 93 94 95 96 97
| <?php /* Date de création: 04/10/2007 */ ?>
<html>
<body>
<?php
//require("cnx/login_sql.php");
//Connexion à la base
$db=mysql_connect("localhost","root","");
//Selection de la base
mysql_select_db("alliance",$db);
//Recupération de la variable id
$id=$_POST['id_sw'];
$type_sw=$_POST['type_sw'];
$ip_sw=$_POST['ip_sw'];
$sw="SELECT * FROM etablissement WHERE IdEtb='$id'";
$sql_sw=mysql_query($sw) or die ('Erreur SQL !<br>'.$sw.'<br>'.mysql_error());
$tab_sw=mysql_fetch_assoc($sql_sw);
//Boucle If testant si le champ TypSwitch & IPSwitch sont remplis
if(($tab_sw['TypSwitch1']!="") AND ($tab_sw['IPSwitch1']!=""))
{
?>
<script type="text/javascript">
alert("Limité à 10 enregistrements");
</script>
<?php
header("Location: index.php?numlien=Det_Etablissement&id=$id");
}
Elseif(($tab_sw['TypSwitch1']=="") AND ($tab_sw['IPSwitch1'] ==""))
{
$upd_sw1="UPDATE etablissement SET TypSwitch1='$type_sw', IPSwitch1='$ip_sw' WHERE IdEtb='$id'";
$sql_updsw1=mysql_query($upd_sw) or die ('Erreur SQL !<br>'.$upd_sw1.'<br>'.mysql_error());
header("Location: index.php?numlien=Det_Etablissement&id=$id");
}
elseif(($tab_sw['TypSwitch2'] AND $tab_sw['IPSwitch2'])=="")
{
$upd_sw2="UPDATE etablissement SET TypSwitch2='$type_sw', IPSwitch2='$ip_sw' WHERE IdEtb='$id'";
$sql_updsw2=mysql_query($upd_sw2) or die ('Erreur SQL !<br>'.$upd_sw2.'<br>'.mysql_error());
header("Location: index.php?numlien=Det_Etablissement&id=$id");
}
elseif(($tab_sw['TypSwitch3']=="") AND ($tab_sw['IPSwitch3']==""))
{
$upd_sw3="UPDATE etablissement SET TypSwitch3='$type_sw', IPSwitch3='$ip_sw' WHERE IdEtb='$id'";
$sql_updsw3=mysql_query($upd_sw3) or die ('Erreur SQL !<br>'.$upd_sw3.'<br>'.mysql_error());
header("Location: index.php?numlien=Det_Etablissement&id=$id");
}
elseif(($tab_sw['TypSwitch4']=="") AND ($tab_sw['IPSwitch4']==""))
{
$upd_sw4="UPDATE etablissement SET TypSwitch4='$type_sw', IPSwitch4='$ip_sw' WHERE IdEtb='$id'";
$sql_updsw4=mysql_query($upd_sw4) or die ('Erreur SQL !<br>'.$upd_sw4.'<br>'.mysql_error());
header("Location: index.php?numlien=Det_Etablissement&id=$id");
}
elseif(($tab_sw['TypSwitch5']=="") AND ($tab_sw['IPSwitch5']==""))
{
$upd_sw5="UPDATE etablissement SET TypSwitch5='$type_sw', IPSwitch5='$ip_sw' WHERE IdEtb='$id'";
$sql_updsw5=mysql_query($upd_sw5) or die ('Erreur SQL !<br>'.$upd_sw5.'<br>'.mysql_error());
header("Location: index.php?numlien=Det_Etablissement&id=$id");
}
elseif(($tab_sw['TypSwitch6']=="") AND ($tab_sw['IPSwitch6']==""))
{
$upd_sw6="UPDATE etablissement SET TypSwitch6='$type_sw', IPSwitch6='$ip_sw' WHERE IdEtb='$id'";
$sql_updsw6=mysql_query($upd_sw6) or die ('Erreur SQL !<br>'.$upd_sw6.'<br>'.mysql_error());
header("Location: index.php?numlien=Det_Etablissement&id=$id");
}
elseif(($tab_sw['TypSwitch7']=="") AND ($tab_sw['IPSwitch7']==""))
{
$upd_sw7="UPDATE etablissement SET TypSwitch7='$type_sw', IPSwitch7='$ip_sw' WHERE IdEtb='$id'";
$sql_updsw7=mysql_query($upd_sw7) or die ('Erreur SQL !<br>'.$upd_sw6.'<br>'.mysql_error());
header("Location: index.php?numlien=Det_Etablissement&id=$id");
}
elseif(($tab_sw['TypSwitch8']=="") AND ($tab_sw['IPSwitch8']==""))
{
$upd_sw8="UPDATE etablissement SET TypSwitch8='$type_sw', IPSwitch8='$ip_sw' WHERE IdEtb='$id'";
$sql_updsw8=mysql_query($upd_sw8) or die ('Erreur SQL !<br>'.$upd_sw8.'<br>'.mysql_error());
header("Location: index.php?numlien=Det_Etablissement&id=$id");
}
elseif(($tab_sw['TypSwitch9']=="") AND ($tab_sw['IPSwitch9']==""))
{
$upd_sw9="UPDATE etablissement SET TypSwitch9='$type_sw', IPSwitch9='$ip_sw' WHERE IdEtb='$id'";
$sql_updsw9=mysql_query($upd_sw9) or die ('Erreur SQL !<br>'.$upd_sw9.'<br>'.mysql_error());
header("Location: index.php?numlien=Det_Etablissement&id=$id");
}
elseif(($tab_sw['TypSwitch10']=="") AND ($tab_sw['IPSwitch10']==""))
{
$upd_sw10="UPDATE etablissement SET TypSwitch10='$type_sw', IPSwitch10='$ip_sw' WHERE IdEtb='$id'";
$sql_updsw10=mysql_query($upd_sw10) or die ('Erreur SQL !<br>'.$upd_sw10.'<br>'.mysql_error());
header("Location: index.php?numlien=Det_Etablissement&id=$id");
}
//header("Location: index.php?numlien=Det_Etablissement&id=$id");
?>
</body>
</html> |
Partager