-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsaveAnnonce.php
73 lines (43 loc) · 1.51 KB
/
saveAnnonce.php
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
<?php
$garage_id = null;
$name = null;
$price = null;
if(!empty($_POST['garageId']) && ctype_digit($_POST['garageId']) ){
$garage_id = $_POST['garageId'];
}
if(!empty($_POST['name']) ){
$name = htmlspecialchars($_POST['name']);
}
if(!empty($_POST['price']) ){
$price = htmlspecialchars($_POST['price']);
}
if( !$garage_id || !$name || !$price ){
die("formulaire mal rempli");
}
$pdo = new PDO('mysql:host=localhost;dbname=garages','garage' ,'garage', [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
]);
$maRequete = $pdo->prepare("SELECT * FROM garages WHERE id =:garage_id");
$maRequete->execute(['garage_id' => $garage_id]);
$garage = $maRequete->fetch();
if(!$garage){
die("garage inexistant");
}
$maRequeteSaveAnnonce = $pdo->prepare("INSERT INTO annonces (name, price, garage_id)
VALUES (:name, :price, :garage_id)");
$maRequeteSaveAnnonce->execute([
'name' => $name,
'price' => $price,
'garage_id' => $garage_id
]);
header("Location: garage.php?id=$garage_id");
/// Surveiller POST
// Verifier les trois données transmises par POST
/// faire une requete pour verifier
//l'existance du garage
//si le garage est inexistant,
//die("garage inexistant")
//autrement
//insérer la nouvelle annonce
//redirection vers la page du garage