Discussion :

[hela.sfar]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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());
   }

?>
svp je troube un probleme de résoudre ces erreurs:

Notice: Undefined index: date_f_location in C:\wamp\www\tests\verification.php on line 18
Notice: Undefined variable: _POST_ in C:\wamp\www\tests\verification.php on line 20

( ! ) Notice: Undefined variable: dfinab1 in C:\wamp\www\tests\verification.php on line 22

( ! ) Notice: Undefined variable: dfinab1 in C:\wamp\www\tests\verification.php on line 22
Call Stack
# Time Memory Function Location
1 0.0028 393192 {main}( ) ..\verification.php:0

( ! ) Notice: Undefined variable: dfinab1 in C:\wamp\www\tests\verification.php on line 22
Call Stack
# Time Memory Function Location
1 0.0028 393192 {main}( ) ..\verification.php:0

( ! ) Notice: Undefined offset: 2 in C:\wamp\www\tests\verification.php on line 27

( ! ) Notice: Undefined offset: 2 in C:\wamp\www\tests\verification.php on line 27
Call Stack
# Time Memory Function Location
1 0.0028 393192 {main}( ) ..\verification.php:0

( ! ) Notice: Undefined offset: 1 in C:\wamp\www\tests\verification.php on line 27
Call Stack
# Time Memory Function Location
1 0.0028 393192 {main}( ) ..\verification.php:0

( ! ) Notice: Undefined variable: ddbutbd in C:\wamp\www\tests\verification.php on line 28

[amoiraud]

Bah suffit de lire les erreurs, tu tente de récupérer un date_f_location alors que dans ta requete tu selectionne date_d_location, ensuite tu à un "_" en trop dans ton

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
$_POST_['datef'];

et de la découlent toutes les autres erreurs