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
|
<?php
/*
* Template Name: enregistreritineraire
* */
function enregistreritineraire() {
if(isset($_POST["depart"], $_POST["arrive"],$_POST["participation"],$_POST["datedepart"], $_POST["datearrive"], $_POST["latDepart"], $_POST["longDepart"] , $_POST["latDepart"], $_POST["longArrive"]))
{
$lieuDepart = $_POST["depart"];
$lieuArrive = $_POST['arrive'];
$participation = $_POST['participation'];
// $lieuDepart = "Paris";
// $lieuArrive = "Bordeaux";
// $participation = "50.0";
$datedepart = $_POST['datedepart'];
$datearrive = $_POST['datearrive'];
$latDepart = $_POST["latDepart"];
$longDepart = $_POST["longDepart"];
$latArrive = $_POST["latArrive"];
$longArrive = $_POST["longArrive"];
try {
$PDO = new PDO() ==> ect;
$PDO->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_WARNING);
$PDO->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_OBJ);
$sql = "INSERT INTO trajet (depart, arrive, latDepart, longDepart, latArrive, longArrive) VALUES (:depart,:arrive,:latDepart, :longDepart, :latArrive, :longArrive)";
// $sql = "INSERT INTO trajet (depart, arrive) VALUES (:depart,:arrive)";
$req = $PDO->prepare($sql);
$req->execute(array(
"depart" => $lieuDepart,
"arrive" => $lieuArrive,
"latDepart" => $latDepart,
"longDepart" => $longDepart,
"latArrive" => $latArrive,
"longArrive" => $longArrive
));
$PDO = new PDO('mysql:host=localhost;dbname=philippe','root','');
$PDO->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_WARNING);
$PDO->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_OBJ);
$sql = "INSERT INTO orders (conducteur, lieudepart, lieuarrive, participation, datedepart, datearrive) VALUES (:conducteur,:lieudepart,:lieuarrive,:participation,:datedepart,:datearrive)";
// $sql = "INSERT INTO orders (conducteur, lieudepart, lieuarrive, participation) VALUES (:conducteur,:lieudepart,:lieuarrive,:participation)";
$req = $PDO->prepare($sql);
$req->execute(array(
"conducteur" => "anatta",
"lieudepart" => $lieuDepart,
"lieuarrive" => $lieuArrive,
"participation" => $participation,
"datedepart" => $datedepart,
"datearrive" => $datearrive
));
}
catch(PDOException $e){
die("Erreur d'insertion :".$e->getMessage());
}
}
}
// else {throw new Exception('Erreur ');
// echo "ERREUR";} |
Répondre avec citation
Partager