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
|
<?php
mysql_connect('mysql10.000webhost.com', '*******', '******';
mysql_select_db('*****');
if(isset($_POST['civile']) AND isset($_POST['prenom']) AND isset($_POST['nom']) AND isset($_POST['age']) AND isset($_POST['ville']) AND isset($_POST['pays']) AND isset($_POST['adresse']) AND isset($_POST['mail']) AND isset($_POST['motif']) AND isset($_POST['message']))
{
if ($_POST['civile']!='' && $_POST['prenom']!='' && $_POST['nom']!='' && $_POST['age']!='' && $_POST['ville']!='' && $_POST['pays']!='' && $_POST['adresse']!='' && $_POST['mail']!='' && $_POST['motif']!='' && $_POST['message']!='')
{
$civile = mysql_real_escape_string(htmlspecialchars($_POST['civile']));
$prenom = mysql_real_escape_string(htmlspecialchars($_POST['prenom']));
$nom = mysql_real_escape_string(htmlspecialchars($_POST['nom']));
$age = mysql_real_escape_string(htmlspecialchars($_POST['age']));
$ville = mysql_real_escape_string(htmlspecialchars($_POST['ville']));
$pays = mysql_real_escape_string(htmlspecialchars($_POST['pays']));
$adresse = mysql_real_escape_string(htmlspecialchars($_POST['adresse']));
$mail = mysql_real_escape_string(htmlspecialchars($_POST['mail']));
$motif = mysql_real_escape_string(htmlspecialchars($_POST['motif']));
$message = mysql_real_escape_string(htmlspecialchars($_POST['message']));
$message = nl2br($message);
mysql_query('INSERT INTO formulaire (id, civile, prenom, nom, age, adresse, mail, ville, pays, motif, message) VALUES(NULL, "'.$civile.'", "'.$prenom.'", "'.$nom.'", "'.$age.'", "'.$ville.'", "'.$pays.'", "'.$adresse.'", "'.$mail.'", "'.$motif.'", "'.$message.'")') or die (mysql_error());
}
}
mysql_close();
?> |
Partager