1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| $sql="INSERT INTO `hebergement` (`NUM_HEBERGEMENT`, `NUM_CONTACT`, `INTITULE`, `ADRESSE_H`, `CP_H`, `VILLE_H`, `TEL_H`, `FAX_H`, "
."`WEB`, `CLASSEMENT`,`GPS_X`, `GPS_Y`, `FERMETURE`, `CHAMBRE`, `CAPACITE`, `LIEN_PHOTO`, `NUM_LABEL`, `NUM_CATEGORIE` ) VALUES " ."('$num', '$contact', '$nom', '$adresse', '$cp', '$ville', '$tel', '$fax', '$web', '$classement', '$gpsx', '$gpsy', "
."'$fermeture', '$chambre', '$capacite', '$photo', '$label', '$categorie');";
$exec=mysql_query($sql,$connec) or die("erreur insert contact -> ".mysql_error());
foreach ($_POST as $cle => $valeur)
{
$sql1="INSERT INTO `caracheber` (`NUM_HEBERGEMENT`, `NUM_CARACTERISTIQUE`) VALUES ('$num', '".$cle."');";
$exec1=mysql_query($sql1,$connec) or die("erreur insert caracheber -> ".mysql_error());
}
echo "<SCRIPT LANGUAGE='JavaScript'>";
echo "alert('L'hebergement -$nom- a bien été ajouté.')";
echo "</SCRIPT LANGUAGUE>"; |
Partager