function req_last_news_deleted()
{
include 'fonc_connect.php';
$id = req_last_news();
$req_last_delete = $bdd->prepare('DELETE FROM news WHERE img = :id');
$req_last_delete->execute(array(':id' => $id)) or die(print_r($bdd->errorInfo()));
return $req_last_delete;
}
/* news.upload.1 -> au moins un des champs est vide */
header('Location:../espace_membre.php?upload=x&update=x&delete=x&news=0&photos=0&videos=0,coms=x&error=news.upload.1');
} else {
if ($_FILES['image_news']['error'] == 4) {
/* news.upload.2 -> Le fichier n'a pas été chargé */
header('Location:../espace_membre.php?upload=x&update=x&delete=x&news=0&photos=0&videos=0,coms=x&error=news.upload.2');
} else {
$extensions_autorisees = array('jpeg', 'jpg', 'png', 'JPEG', 'JPG', 'PNG');
$tmp = explode('.', $_FILES['image_news']['name']);
$extension = $tmp[1];
if (!in_array($extension, $extensions_autorisees)) {
/* news.upload.3 -> Le type de fichier est incorrect : <b>jpeg, jpg ou png</b> */
header('Location:../espace_membre.php?upload=x&update=x&delete=x&news=0&photos=0&videos=0,coms=x&error=news.upload.3');
} else {
include 'requetes_news.php';
$id_img_news = req_last_news() + 1;
/* upload de l'image */
$chemin = '../view/data/photos_news/';
$fichier = $id_img_news . '.' . $extension;
if (move_uploaded_file($_FILES['image_news']['tmp_name'], $chemin . $fichier)) {
/* enregistrement de la requete */
$titre_news = $_POST['titre_news'];
$date_news = $_POST['date_news'];
$contenu_news = $_POST['contenu_news'];
$req_insert_news = req_insert_news($id_img_news, $titre_news, $date_news, $contenu_news);
if ($req_insert_news == true) {
/* true */
header('Location:../espace_membre.php?upload=true&update=x&delete=x&news=0&photos=0&videos=0,coms=x&error=0');
} else {
/* false */
header('Location:../espace_membre.php?upload=false&update=x&delete=x&news=0&photos=0&videos=0,coms=x&error=0');
