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
| if(isset($_POST['send']) AND is_string($_POST['sexe']) AND is_string($_POST['categorie']) AND is_string($_POST['ville']) AND is_numeric($_POST['telephone']) AND filter_var($_POST['email'], FILTER_VALIDATE_EMAIL) AND is_string($_POST['titre'])){
//Si les champs obligatoires ne contiennent pas d'erreurs alors on continue
$sql = 'SELECT * FROM villes WHERE ville_nom_simple like "'.$_POST['ville'].'"';
$fsearch = $bdd->prepare($sql);
$fsearch->execute();
$count = $fsearch->rowCount($sql);
// date du jour
echo $date = date("d/m/Y");
// tableau des jours de la semaine
$joursem = array('dim', 'lun', 'mar', 'mer', 'jeu', 'ven', 'sam');
// extraction des jour, mois, an de la date
list($jour, $mois, $annee) = explode('/', $date);
// calcul du timestamp
$timestamp = mktime (0, 0, 0, $mois, $jour, $annee);
// affichage du jour de la semaine
echo $joursem[date("w",$timestamp)];
if ($count >= 1){
$valeurs = [':sex' => $_POST['sexe'], ':catego' => $_POST['categorie'], ':dep' => $_POST['departements'], ':vil' => $_POST['ville'], ':valid' => $_POST['validite'], ':tel' => $_POST['telephone'], ':mail' => $_POST['email'], ':descri' => $_POST['description'], ':ech' => $_POST['echange'], ':image1' => $img1, ':image2' => $img2, ':tit' => $_POST['titre'], ":date_enregistrement" => $_POST['time()']];
$requete = "INSERT INTO offres (sexe, categorie, departement, ville, validite, telephone, email, description, echange, image1, image2, titre, date_enregistrement) VALUES(:sex, :catego, :dep, :vil, :valid, :tel, :mail, :descri, :ech, :image1, :image2, :tit, :date_enr)";
$requete_preparee = $bdd->prepare($requete);
$requete_preparee->execute($valeurs);
} else {
echo '<p style="color: white;">Veuillez entrez une ville existante</p>';
}
}
?> |
Partager