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);
}
}
?> |
Partager