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
| <?php
try
{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$bdd = new PDO('mysql:host=localhost;dbname=location', 'root', '', $pdo_options);
$req = $bdd->prepare('SELECT date_d_location FROM voiture WHERE id = ? ');
$req->execute(array($_POST['identifiant'])); //connexion à la table voiture
while ($donnees = $req->fetch())
{
if($donnees['date_d_location']==NULL)
{
echo "voiture disponible !";
}
else
{
$date_d=$_POST['dated'];
$date_fb=$donnees['date_f_location'];
$date_db=$donnees['date_d_location'];
$date_f=$_POST_['datef'];
$dfinad1 = explode("/", $date_f);
$dfinab = $dfinab1[2].$dfinab1[1].$dfinab1[0];
$ddebut = explode("/", $date_d);
$dfinbd = explode("-", $date_fb);
$ddebutbd = explode("-", $date_db);
$debutab = $ddebut[2].$ddebut[1].$ddebut[0];
$finab = $dfinbd[2].$dfinbd[1].$dfinbd[0];
$ddebutab1 = $ddebutbd[2].$ddebutbd[1].$ddbutbd[0];
if (($debutab >= $finab) || ( $dfinabab < $ddebutab1))
{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$bdd = new PDO('mysql:host=localhost;dbname=location', 'root', '', $pdo_options);
$req = $bdd->prepare('SELECT datedebut,datefin FROM individu WHERE id = ? ');
$req->execute(array($_POST['identifiant']));
$test=true;
while (($donnees = $req->fetch()) && ($test==true))
{
$ddatedbut=explode("-",$datedebut);
$dddatedebut=$ddatedebut[2].$ddatedebut[1].$ddatedebut[0];
$ddatefin=explode("-",$datefin);
$dddatefin=$ddatefin[2].$ddatefin[1].$ddatefin[0];
if((($dddatedebut <= $ddebutab1) && ( $ddebutab1 <= $finab)))
{
$test=false;
}
}
if($test==true)
{
echo "la voiture sera à vous";
$nom=$_POST['nom'];
$prenom=$_POST['prenom'];
$numtelph=$_POST['tel'];
$email=$_POST['email'];
$idv=$_POST['identifiant'];
$requete=$bdd->exec('INSERT INTO individu(nom, prenom, num_telph, email, id_voiture,datedebut,datefin) VALUES ($nom, $prenom,$numtlph, $email, $idv, $date_d, $date_f)');
}
else
{
echo "la voiture est reservée pour cette date !";
}
}
}
}
$req->closeCursor();
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
} |
