par
Larker » 12 juin 2016, 15:46
D'accord, voici le code complet :
<?php
if(!defined(PROTECTION_FICHIER) && PROTECTION_FICHIER != 'protection_Projet')
{
header('Location: index.php');
}
// Stats visite critique
$id_news = $_GET['id'];
$visitIpQuery = $bdd->prepare("SELECT ip FROM visite_news WHERE id_news = :id AND ip='".$_SERVER['REMOTE_ADDR']."'");
$visitIpQuery->bindValue(':id',$_GET['id'],PDO::PARAM_INT);
if (!$visitIpQuery->execute()) {
echo 'ERREUR';
exit; //pas obligatoire
}
$visiteur = $visitIpQuery->fetch();
$visitIpQuery->closeCursor();
if($visitIpQuery->rowCount() == 0) {
$req = $bdd->prepare('INSERT INTO visite_news(id_news, ip, date) VALUES(:id_news, :ip, :date)');
$req->execute(array(
'id_news' => $id_news,
'ip' => $_SERVER['REMOTE_ADDR'],
'date' => date('d\-n\-Y')
));
}
?>
<?php
$visitNews = $bdd->prepare("SELECT COUNT(ip) AS 'nb' FROM visite_news WHERE id_news = :id");
$visitNews->bindValue(':id',$_GET['id'],PDO::PARAM_INT);
if (!$visitNews->execute()) {
echo 'ERREUR';
exit; //pas obligatoire
}
$visit = $visitNews->fetch();
$visitNews->closeCursor();
?>
<div class="container_12">
<div class="grid_8" style="overflow:hidden;">
<div id="news" class="page-news">
<?php
if (!empty($_GET)) {
if (isset($_GET[id])) {
$stmt = $bdd->prepare("SELECT id, titre, posteur, id_posteur, resume, img, contenu, DATE_FORMAT(date, '%d/%m/%Y') AS date, active FROM news WHERE active=1 AND id = :id");
$stmt->bindValue(':id',$_GET['id'],PDO::PARAM_INT);
if (!$stmt->execute()) {
echo 'ERREUR';
exit; //pas obligatoire
}
$data = $stmt->fetch();
$stmt->closeCursor();
}
}
?>
<?php
if (!empty($data)){
?>
<h4 class="news-title"><?=$data['titre']; ?></h4>
<div class="contenuviewnews">
<div id="news-date">
<i>Ajouté le <?=$data['date']; ?>, Par <a href="?mod=profil&id=<?=$data['id_posteur']; ?>" class="lien_profil"><?=$data['posteur']; ?></a> <img src="images/vu.jpg" title="Nombre de visites"/>
<b><?=$visit['nb']; ?></b>
</i>
</div>
<div id="news-contenu">
<?php
$stmt = $bdd->prepare("SELECT * FROM news_genre WHERE id_news = :id");
$stmt->bindValue(':id',$_GET['id'],PDO::PARAM_INT);
if (!$stmt->execute()) {
echo 'ERREUR';
exit; //pas obligatoire
}
while ($getGenre = $stmt->fetch()) {
?>
<a style="text-decoration:none;" href="?mod=genre news&genre=<?=$getGenre['genre']; ?>"><div class="genre"><?=$getGenre['genre']; ?></div></a>
<? } ?>
<br><br>
<b><?=nl2br(stripslashes($data['resume'])); ?></b><br><br>
<div>
<?=nl2br(stripslashes($data['contenu'])); ?>
</div>
</div>
</div>
<?php } else{
echo '<script language="Javascript">
<!--
document.location.replace(\'?mod=accueil\');
// -->
</script>';} ?>
</div>
<div id="fb-root"></div>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/fr_FR/sdk.js#xfbml=1&version=v2.0";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>
<div class="fb-comments" data-href="" data-numposts="5" data-colorscheme="light" data-width="100%"></div>
</div>
<div class="grid_4">
<?php
$getNewsQuery = $bdd->prepare("SELECT id, titre, posteur, contenu, resume, genre, img, DATE_FORMAT(date, '%d/%m/%Y') AS date FROM `news` WHERE `active` = '1' AND id != :id ORDER BY `id` DESC LIMIT 0,5");
$getNewsQuery->bindValue(':id',$_GET['id'],PDO::PARAM_INT);
if (!$getNewsQuery->execute()) {
echo 'ERREUR';
exit; //pas obligatoire
}
while ($getNews = $getNewsQuery->fetch()) {
?>
<div class="wrapper img-top2">
<div class="img-indent1"><a href="?mod=news&id=<?=$getNews['id']; ?>"><div class="grows imgnews"><img src="<?=$getNews['img']; ?>" width="300" height="168" alt="img"></div></a></div>
<div class="autocollant"><?if ($getNews['genre'] == "1")
{
echo 'Film';
}
elseif ($getNews['genre'] == "2")
{
echo 'Série';
}
elseif ($getNews['genre'] == "3")
{
echo 'Tv';
}
?></div>
<div class="element-news"><a style="color:#FFF;text-decoration:none;font-weight:bold" href="?mod=news&id=<?=$getNews['id']; ?>"><?=$getNews['titre']; ?></a></div>
</div>
<?php } ?><br>
</div>
<div class="wrapper">
<div class="grid_12">
<div class="border1"></div>
</div>
</div>
</div>
D'accord, voici le code complet :
[php]<?php
if(!defined(PROTECTION_FICHIER) && PROTECTION_FICHIER != 'protection_Projet')
{
header('Location: index.php');
}
// Stats visite critique
$id_news = $_GET['id'];
$visitIpQuery = $bdd->prepare("SELECT ip FROM visite_news WHERE id_news = :id AND ip='".$_SERVER['REMOTE_ADDR']."'");
$visitIpQuery->bindValue(':id',$_GET['id'],PDO::PARAM_INT);
if (!$visitIpQuery->execute()) {
echo 'ERREUR';
exit; //pas obligatoire
}
$visiteur = $visitIpQuery->fetch();
$visitIpQuery->closeCursor();
if($visitIpQuery->rowCount() == 0) {
$req = $bdd->prepare('INSERT INTO visite_news(id_news, ip, date) VALUES(:id_news, :ip, :date)');
$req->execute(array(
'id_news' => $id_news,
'ip' => $_SERVER['REMOTE_ADDR'],
'date' => date('d\-n\-Y')
));
}
?>
<?php
$visitNews = $bdd->prepare("SELECT COUNT(ip) AS 'nb' FROM visite_news WHERE id_news = :id");
$visitNews->bindValue(':id',$_GET['id'],PDO::PARAM_INT);
if (!$visitNews->execute()) {
echo 'ERREUR';
exit; //pas obligatoire
}
$visit = $visitNews->fetch();
$visitNews->closeCursor();
?>
<div class="container_12">
<div class="grid_8" style="overflow:hidden;">
<div id="news" class="page-news">
<?php
if (!empty($_GET)) {
if (isset($_GET[id])) {
$stmt = $bdd->prepare("SELECT id, titre, posteur, id_posteur, resume, img, contenu, DATE_FORMAT(date, '%d/%m/%Y') AS date, active FROM news WHERE active=1 AND id = :id");
$stmt->bindValue(':id',$_GET['id'],PDO::PARAM_INT);
if (!$stmt->execute()) {
echo 'ERREUR';
exit; //pas obligatoire
}
$data = $stmt->fetch();
$stmt->closeCursor();
}
}
?>
<?php
if (!empty($data)){
?>
<h4 class="news-title"><?=$data['titre']; ?></h4>
<div class="contenuviewnews">
<div id="news-date">
<i>Ajouté le <?=$data['date']; ?>, Par <a href="?mod=profil&id=<?=$data['id_posteur']; ?>" class="lien_profil"><?=$data['posteur']; ?></a> <img src="images/vu.jpg" title="Nombre de visites"/>
<b><?=$visit['nb']; ?></b>
</i>
</div>
<div id="news-contenu">
<?php
$stmt = $bdd->prepare("SELECT * FROM news_genre WHERE id_news = :id");
$stmt->bindValue(':id',$_GET['id'],PDO::PARAM_INT);
if (!$stmt->execute()) {
echo 'ERREUR';
exit; //pas obligatoire
}
while ($getGenre = $stmt->fetch()) {
?>
<a style="text-decoration:none;" href="?mod=genre news&genre=<?=$getGenre['genre']; ?>"><div class="genre"><?=$getGenre['genre']; ?></div></a>
<? } ?>
<br><br>
<b><?=nl2br(stripslashes($data['resume'])); ?></b><br><br>
<div>
<?=nl2br(stripslashes($data['contenu'])); ?>
</div>
</div>
</div>
<?php } else{
echo '<script language="Javascript">
<!--
document.location.replace(\'?mod=accueil\');
// -->
</script>';} ?>
</div>
<div id="fb-root"></div>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/fr_FR/sdk.js#xfbml=1&version=v2.0";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>
<div class="fb-comments" data-href="" data-numposts="5" data-colorscheme="light" data-width="100%"></div>
</div>
<div class="grid_4">
<?php
$getNewsQuery = $bdd->prepare("SELECT id, titre, posteur, contenu, resume, genre, img, DATE_FORMAT(date, '%d/%m/%Y') AS date FROM `news` WHERE `active` = '1' AND id != :id ORDER BY `id` DESC LIMIT 0,5");
$getNewsQuery->bindValue(':id',$_GET['id'],PDO::PARAM_INT);
if (!$getNewsQuery->execute()) {
echo 'ERREUR';
exit; //pas obligatoire
}
while ($getNews = $getNewsQuery->fetch()) {
?>
<div class="wrapper img-top2">
<div class="img-indent1"><a href="?mod=news&id=<?=$getNews['id']; ?>"><div class="grows imgnews"><img src="<?=$getNews['img']; ?>" width="300" height="168" alt="img"></div></a></div>
<div class="autocollant"><?if ($getNews['genre'] == "1")
{
echo 'Film';
}
elseif ($getNews['genre'] == "2")
{
echo 'Série';
}
elseif ($getNews['genre'] == "3")
{
echo 'Tv';
}
?></div>
<div class="element-news"><a style="color:#FFF;text-decoration:none;font-weight:bold" href="?mod=news&id=<?=$getNews['id']; ?>"><?=$getNews['titre']; ?></a></div>
</div>
<?php } ?><br>
</div>
<div class="wrapper">
<div class="grid_12">
<div class="border1"></div>
</div>
</div>
</div>[/php]