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 98 99 100 101 102 103
| <?php
//include("admin/dbinfo.inc.php");
$hostname = "localhost";
$user= "root";
$password = "";
$database="covoiturage";
$mysql_connect = mysql_connect($hostname, $user, $password);
mysql_select_db($database, $mysql_connect);
if (isset($_POST['email'])) {
$con = mysql_connect($hostname,$user,$password);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
@mysql_select_db($database) or die( "Unable to select database");
$nom = mysql_real_escape_string(htmlspecialchars($_POST['nom']));
$prenom = mysql_real_escape_string(htmlspecialchars($_POST['prenom']));
$adresse = mysql_real_escape_string(htmlspecialchars($_POST['adresse']));
$ville = mysql_real_escape_string(htmlspecialchars($_POST['ville']));
$pays = mysql_real_escape_string(htmlspecialchars($_POST['pays']));
$province = mysql_real_escape_string(htmlspecialchars($_POST['province']));
$code_postal_1 = mysql_real_escape_string(htmlspecialchars($_POST['code_postal_1']));
$code_postal_2 = mysql_real_escape_string(htmlspecialchars($_POST['code_postal_2']));
$code_postal = $code_postal_1 . " " . $code_postal_2;
$telephone_1 = mysql_real_escape_string(htmlspecialchars($_POST['telephone_1']));
$telephone_2 = mysql_real_escape_string(htmlspecialchars($_POST['telephone_2']));
$telephone_3 = mysql_real_escape_string(htmlspecialchars($_POST['telephone_3']));
$telephone = "(" . $telephone_1 . ")" . $telephone_2 . "-" . $telephone_3;
$cellulaire_1 = mysql_real_escape_string(htmlspecialchars($_POST['cellulaire_1']));
$cellulaire_2 = mysql_real_escape_string(htmlspecialchars($_POST['cellulaire_2']));
$cellulaire_3 = mysql_real_escape_string(htmlspecialchars($_POST['cellulaire_3']));
$cellulaire = "(" . $cellulaire_1 . ")" . $cellulaire_2 . "-" . $cellulaire_3;
$region_administrative = mysql_real_escape_string(htmlspecialchars($_POST['region_administrative']));
$profession = mysql_real_escape_string(htmlspecialchars($_POST['profession']));
$sexe = mysql_real_escape_string(htmlspecialchars($_POST['sexe']));
$annee = mysql_real_escape_string(htmlspecialchars($_POST['annee']));
$mois = mysql_real_escape_string(htmlspecialchars($_POST['mois']));
$jour = mysql_real_escape_string(htmlspecialchars($_POST['jour']));
$date_naissance = $date_naissance1 . "-" . $date_naissance2 . "-" . $date_naissance3;
$email = mysql_real_escape_string(htmlspecialchars($_POST['email']));
$password = mysql_real_escape_string(htmlspecialchars($_POST['password']));
$date_inscription = date('Y-m-d');
$date_renouv = date("Y-m-d", strtotime("+1 year", strtotime(date("Y-m-d"))));
$date_avis = date("Y-m-d", strtotime("-1 month", strtotime($date_renouv)));
$montant_inscription = 0;
$montant_paye = 0;
$tps = 0;
$tvq = 0;
$permis_conduire_1 = mysql_real_escape_string(htmlspecialchars($_POST['permis_conduire_1']));
$permis_conduire_2 = mysql_real_escape_string(htmlspecialchars($_POST['permis_conduire_2']));
$permis_conduire_3 = mysql_real_escape_string(htmlspecialchars($_POST['permis_conduire_3']));
$permis_conduire = $permis_conduire_1 . " " . $permis_conduire_2 . " " . $permis_conduire_3;
$Type_auto = mysql_real_escape_string(htmlspecialchars($_POST['Type_auto']));
$modele_voiture = mysql_real_escape_string(htmlspecialchars($_POST['modele_voiture']));
$couleur = mysql_real_escape_string(htmlspecialchars($_POST['couleur']));
$annee = mysql_real_escape_string(htmlspecialchars($_POST['annee']));
$no_plaque = mysql_real_escape_string(htmlspecialchars($_POST['no_plaque']));
$gulliver = mysql_real_escape_string(htmlspecialchars($_POST['gulliver']));
$bagage = mysql_real_escape_string(htmlspecialchars($_POST['bagage']));
$fumeur = mysql_real_escape_string(htmlspecialchars($_POST['fumeur']));
$air_climatise = mysql_real_escape_string(htmlspecialchars($_POST['air_climatise']));
$animaux = mysql_real_escape_string(htmlspecialchars (print_r($_POST['animaux']));
Array
(
[0] => 'chien_guide'
[1] => 'oiseaux_en_cage'
[2] => 'aucun_animal'
)
$sql="INSERT INTO gestion_voiturier (`nom`, `prenom`, `adresse` , `ville`, `pays` ,`province`,
`code_postal`, `telephone`, `cellulaire`, `region_administrative`, `profession`, `sexe` , `date_naissance` ,
`email`, `date_inscription`, `date_renouv`, `date_avis`, `montant_inscription`, `inscription_paye`,
`tps`, `tvq`, `photo` , `permis_conduire` , `annee_experience` , `Type_auto` , `modele_voiture` , `couleur` , `annee` , `no_plaque` , `places_disponibles` ,`gulliver` , `bagage` , `fumeur` , `air_climatise`, `animaux`)
VALUES ('$nom', '$prenom', '$adresse', '$ville', '$pays' ,'$province', '$code_postal',
'$telephone', '$cellulaire', '$region_administrative', '$profession', '$sexe' , '$date_naissance' ,
'$email', '$date_inscription', '$date_renouv', '$date_avis', '$montant_inscription', '$inscription_paye', '$tps', '$tvq', '$photo' , '$permis_conduire' , '$annee_experience' , '$Type_auto' , '$modele_voiture' , '$couleur' , '$annee' , '$no_plaque' , '$places_disponibles' , '$gulliver' , '$bagage' , '$fumeur' , '$air_climatise', '$animaux')"or die(mysql_error());
if (!mysql_query($sql,$con))
{
die('Erreur - table gestion_voiturier: ' . mysql_error());
}
$sql="INSERT INTO members(username, password) VALUES('$email', MD5('$password'))";
if (!mysql_query($sql,$con))
{
die('Erreur - table members:' . mysql_error());
}
//mysql_close($con);
header( "Location: confirmation.php" );
} else {
header( "Location: echec.php");
?>
<?php
exit;
}
?> |
Partager