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
|
<?php
include "../db-link.php";
if(isset($_GET['id'])){
$id = $_GET['id'];
$db->exec("DELETE FROM loca_appart WHERE id=$id");
$error = "<p style='background-color:red;padding:10px;text-align:center;color:#fff'>Votre article a bien été supprimé !</p>";
}
if(isset($_POST['hide'])){
$id = $_POST['id'];
$db->exec("UPDATE loca_appart SET display = 'hide' WHERE id='$id'");
}
if(isset($_POST['show'])){
$id = $_POST['id'];
$db->exec("UPDATE loca_appart SET display = 'show' WHERE id='$id'");
}
if(isset($_POST['croatieOk'])){
$valide = TRUE;
if((empty($_POST['type'])) && ($_POST['type'] == "")){
$error = "<p style='background-color:red;padding:10px;text-align:center;color:#fff'>Veuillez entrer un <strong>type</strong></p>";
$valide = FALSE;
} elseif((empty($_POST['ville'])) && ($_POST['ville'] == "")){
$error = "<p style='background-color:red;padding:10px;text-align:center;color:#fff'>Veuillez entrer une <strong>ville</strong></p>";
$valide = FALSE;
} elseif((empty($_POST['postal'])) && ($_POST['postal'] == "")){
$error = "<p style='background-color:red;padding:10px;text-align:center;color:#fff'>Veuillez entrer un <strong>code postal</strong></p>";
$valide = FALSE;
} elseif(!preg_match("/[0-9]/", $_POST['postal'])){
$error = "<p style='background-color:red;padding:10px;text-align:center;color:#fff'>Veuillez entrer que des <strong>chiffres</strong></p>";
$valide = FALSE;
} elseif((empty($_POST['prix'])) && ($_POST['prix'] == "")){
$error = "<p style='background-color:red;padding:10px;text-align:center;color:#fff'>Veuillez entrer un <strong>prix</strong></p>";
$valide = FALSE;
} elseif(!preg_match("/[0-9]/", $_POST['prix'])){
$error = "<p style='background-color:red;padding:10px;text-align:center;color:#fff'>Veuillez entrer que des <strong>chiffres</strong></p>";
$valide = FALSE;
} elseif((empty($_POST['texte'])) && ($_POST['texte'] == "")){
$error = "<p style='background-color:red;padding:10px;text-align:center;color:#fff'>Veuillez entrer un <strong>texte</strong></p>";
$valide = FALSE;
} elseif($valide){
$error = "<p style='background-color:green;padding:10px;text-align:center;color:#fff'>Votre article a bien été ajouté.</p>";
if(empty($_FILES["nameImg1"]["name"])){$none1 = "none";}else{$none1 = "";}
if(empty($_FILES["nameImg2"]["name"])){$none2 = "none";}else{$none2 = "";}
if(empty($_FILES["nameImg3"]["name"])){$none3 = "none";}else{$none3 = "";}
if(empty($_FILES["nameImg4"]["name"])){$none4 = "none";}else{$none4 = "";}
if(empty($_FILES["nameImg5"]["name"])){$none5 = "none";}else{$none5 = "";}
if(empty($_FILES["nameImg6"]["name"])){$none6 = "none";}else{$none6 = "";}
$req = $db->prepare("INSERT INTO loca_appart(type, ville, postal, prix, investissement, texte, img1, img2, img3, img4, img5, img6)
VALUES(:typePrep, :villePrep, :postalPrep, :prixPrep, :investissementPrep, :textePrep, :img1Prep, :img2Prep, :img3Prep, :img4Prep, :img5Prep, :img6Prep)");
$req->execute(array(
'typePrep' => $_POST['type'],
'villePrep' => $_POST['ville'],
'postalPrep' => $_POST['postal'],
'prixPrep' => $_POST['prix'],
'investissementPrep' => $_POST['investissement'],
'textePrep' => $_POST['texte'],
'img1Prep' => $none1,
'img2Prep' => $none2,
'img3Prep' => $none3,
'img4Prep' => $none4,
'img5Prep' => $none5,
'img6Prep' => $none6
));
$req1 = $db->query("SELECT MAX(id) AS imgNum FROM loca_appart");
$identif1 = $req1->fetch(PDO::FETCH_ASSOC);
@$number1 = $identif1[imgNum];
$none = "none";
$finalName1 = $number1."-1.jpg";
$finalName2 = $number1."-2.jpg";
$finalName3 = $number1."-3.jpg";
$finalName4 = $number1."-4.jpg";
$finalName5 = $number1."-5.jpg";
$finalName6 = $number1."-6.jpg";
$rep1 = dirname(__FILE__)."/../img/locations/appartements/";
move_uploaded_file($_FILES["nameImg1"]["tmp_name"], $rep1.$finalName1);
move_uploaded_file($_FILES["nameImg2"]["tmp_name"], $rep1.$finalName2);
move_uploaded_file($_FILES["nameImg3"]["tmp_name"], $rep1.$finalName3);
move_uploaded_file($_FILES["nameImg4"]["tmp_name"], $rep1.$finalName4);
move_uploaded_file($_FILES["nameImg5"]["tmp_name"], $rep1.$finalName5);
move_uploaded_file($_FILES["nameImg6"]["tmp_name"], $rep1.$finalName6);
}
}
?> |
