1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1"))
{
$insertSQL = sprintf("INSERT INTO annonceur (mailAnnonceur, nomAnnonceur, prenomAnnonceur, adresseAnnonceur, cpAnnonceur, localiteAnnonceur, paysAnnonceur, telAnnonceur, mpAnnonceur, dateinscription, IDcategorie, `check`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['mailAnnonceur'], "text"),
GetSQLValueString($_POST['nomAnnonceur'], "text"),
GetSQLValueString($_POST['prenomAnnonceur'], "text"),
GetSQLValueString($_POST['adresseAnnonceur'], "text"),
GetSQLValueString($_POST['cpAnnonceur'], "text"),
GetSQLValueString($_POST['vil_nom'],"text"),
GetSQLValueString($_POST['paysAnnonceur'], "text"),
GetSQLValueString($_POST['telAnnonceur'], "text"),
GetSQLValueString($_POST['mpAnnonceur'], "text"),
'NOW()',
GetSQLValueString($_POST['IDcategorie'], "int"),
GetSQLValueString(isset($_POST['check']) ? "true" : "", "defined","'Y'","'N'"));
mysql_select_db($database_rsimmo, $rsimmo);
$Result1 = mysql_query($insertSQL, $rsimmo) or die(mysql_error());
} |
Partager