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 98 99 100 101 102
| <?php
try
{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$pdo_options[PDO::MYSQL_ATTR_INIT_COMMAND] = 'SET NAMES utf8';
$bdd = new PDO('mysql:host=localhost;dbname=projet', 'root', '', $pdo_options);
}
catch (PDOException $e)
{
die('Erreur : ' . $e->getMessage());
}
// Modification de l'actualité SI c'est le cas
if (isset($_POST['valider'], $_POST['id_news'], $_POST['contenu']))
{
$id = $_POST['id_news'];
$contenu = $_POST['contenu'];
$req = $bdd->prepare('UPDATE news SET contenu = :contenu WHERE id = :id');
$req->bindValue(':contenu', $contenu, PDO::PARAM_STR);
$req->bindValue(':id', $id, PDO::PARAM_INT);
$req->execute();
// Redirection vers la page d'acueil
header('location: affichage_news.php');
exit();
}
// Récupération de la news (Modifiée ou pas)
if (isset($_GET['id_news']))
{
echo 'hiiii';
$id = $_GET['id_news'];
$req = $bdd->prepare('SELECT id, titre, contenu FROM news WHERE id = :id');
$req->bindParam(':id', $id, PDO::PARAM_INT);
$req->execute();
$actualite = $req->fetch(PDO::FETCH_ASSOC);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head><title>ENSI MEDIATHEQUE</title><meta name="keywords" content=""><meta name="description" content=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="language" content="en"><link href="style.css" rel="stylesheet" type="text/css"></head><body>
<div id="main">
<div id="header">
<h1>ENSI MEDIATHEQUE</h1>
<div id="search">
<form method="post" action="formulaire_recherche.php" accept-charset="utf-8">
<input type="submit" class="submit" value="recherche" id=""></form>
</div>
</div>
<div id="menu"><div id="menu2">
<ul><li><a class="active" href="accueil.php">Accueil</a></li>
<li><a href="affichage_film.php">Films</a></li>
<li><a href="affichage_audio.php">Musique</a></li>
<li><a href="inscription.php">Enregistrement</a></li>
<li><a href="connexion.php">connexion</a></li>
<li><a href="affichage_news.php">actualités</a></li>
</ul></div></div>
<div id="middle"><div id="middle2">
<div id="left">
<div class="box">
<h2>Votre médiathèque en ligne</h2>
<p> <form action="modif_actualité.php" method="post">
<p>
Titre : <?php echo $actualite['titre']; ?><br />
<label for="contenu">Contenu</label> :<br />
<textarea name="contenu" rows="8" cols="45" id="contenu"><?php echo $actualite['contenu']; ?></textarea><br />
<input type="hidden" name="id_news" value="<?php echo $actualite['id']; ?>" />
<input type="submit" name="valider" value="Valider" />
</p>
</form>
</p>
</div>
<div class="box">
<h2></h2>
<p></p>
<p></p>
</div>
<div class="box">
<h2></h2>
<p></p>
<p></p>
</div>
</div>
<div id="sidebar">
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
</div>
<div class="clearing">*</div>
</div></div>
<div id="footer">
<p>Copyright © ENSI MEDIATHEQUE</p>
</div>
</div>
</body></html> |
Partager