CONNEXION
  • RetourJeux
    • Sorties
    • Hit Parade
    • Les + populaires
    • Les + attendus
    • Soluces
    • Tous les Jeux
    • Gaming
  • RetourActu Gaming
    • News
    • Astuces
    • Tests
    • Previews
    • Toute l'actu gaming
  • RetourBons plans
    • Bons plans
    • Bons plans Smartphone
    • Bons plans Hardware
    • Bons plans Image et Son
    • Bons plans Amazon
    • Bons plans Cdiscount
    • Bons plans Decathlon
    • Bons plans Fnac
    • Tous les Bons plans
  • RetourJVTech
    • Actus High-Tech
    • Intelligence Artificielle
    • Smartphones
    • Mobilité urbaine
    • Hardware
    • Image et son
    • Tutoriels
    • Tests produits High-Tech
    • Guides d'achat High-Tech
    • JVTech
  • RetourCulture
    • Actus Culture
    • Culture
  • RetourVidéos
    • A la une
    • Gaming Live
    • Vidéos Tests
    • Vidéos Previews
    • Gameplay
    • Trailers
    • Chroniques
    • Replay Web TV
    • Toutes les vidéos
  • RetourForums
    • Hardware PC
    • PS5
    • Switch 2
    • Xbox Series
    • Switch
    • Pokemon pocket
    • FC 25 Ultimate Team
    • League of Legends
    • Tous les Forums
  • PC
  • PS5
  • Xbox Series
  • Switch 2
  • PS4
  • One
  • Switch
  • iOS
  • Android
  • MMO
  • RPG
  • FPS
En ce moment Genshin Impact Valhalla Breath of the wild Animal Crossing GTA 5 Red dead 2
Liste des sujets

pb script news

Kety_StyLe93
Kety_StyLe93
Niveau 9
22 octobre 2005 à 12:19:58

salut a tous voila jai installer un script de news sur mon site mais il ya un blem

http://mega-dbz.performant-hosting.com/version2/

voila le fichier function_aff

<?php
include(´./tlNews/inc/config.php´);
include(´./tlNews/inc/sql_connect.php´);

function mystripslashes($string) {
if (get_magic_quotes_gpc()==1) {
return ($string);
}
else {
return (stripslashes ($string));
}
}

function myaddslashes($string) {
if (get_magic_quotes_gpc()==1) {
return ($string);
}
else {
return (mysql_real_escape_string ($string));
}
}

function afficher_news($nbr_news) {
if(isset($_GET[´idNouvelle´])){
$idnews = $_GET[´idNouvelle´];

$query1 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_news where id = ´$idnews´";
$result1 = mysql_query($query1) or die(´Erreur SQL : ´.mysql_error());
while ($row = mysql_fetch_array($result1)) {
$template = $row[´template´];
$query = "SELECT * FROM tlNews_template where title = ´$template´";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
$val = mysql_fetch_array($result);

$vign = $row[´vign´];
$query2 = "SELECT * FROM tlNews_vign where title = ´$vign´";
$result2 = mysql_query($query2) or die(´Erreur SQL : ´.mysql_error());
$row1 = mysql_fetch_array($result2);

$idnews = $row[´id´];
$query3 = "SELECT * FROM tlNews_comment where idNouvelle = ´$idnews´";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
$nb = mysql_num_rows($result3);

$val[´code´] = str_replace("[titre]", mystripslashes($row[´title´]), $val[´code´]);
$val[´code´] = str_replace("[auteur]", $row[´auteur´], $val[´code´]);
$val[´code´] = str_replace("[vign]", "<img src=´./tlNews/".$row1[´url´]."´ alt=´vign´ />", $val[´code´]);
$val[´code´] = str_replace("[date]", $row[´date´], $val[´code´]);
$val[´code´] = str_replace("[chapeau]", mystripslashes(nl2br($row[´chapeau´])), $val[´code´]);
$val[´code´] = str_replace("[suite]", mystripslashes(nl2br($row[´content´])), $val[´code´]);
$val[´code´] = str_replace("[src]", "<a href=´".$row[´src´]."´>".$row[´src´]."</a>", $val[´code´]);
$val[´code´] = str_replace("[comment]", "<a href=´?idNouvelle=".$idnews."#comment´>".$nb." commentaire(s)</a>", $val[´code´]);

echo $val[´code´];
}
echo "<div style=´text-align: center; font-weight: bold;´><a
href=´?idNouvelle=".$idnews."&comment=ajout´>A
jouter un commentaire.</a></div>";
echo "<div style=´text-align: center;´>";
if($_GET[´comment´] == ´ajout´){

echo "<form action=´?idNouvelle=".$idnews."&comment=send´ method=´post´>";
echo ´Auteur :<br /><input type="text" name="auteur" size="50" maxlength="255" /><br />´;

echo ´Commentaire :<br /><textarea name="msg" cols="50" rows="5"></textarea><br />´;

echo ´<input type="submit" name="submit" value="Ajouter" />´;
echo "</form>";

}
elseif($_GET[´comment´] == ´send´){
$auteur =
myaddslashes(htmlspecialchars($_POST[´auteur´]));

$msg = myaddslashes(htmlspecialchars($_POST[´msg´]));
$date = date("Y-m-d H:i:s");
$idnews = $_GET[´idNouvelle´];

if(empty($auteur) || empty($msg)){
echo "Veuillez remplir tous les champs.\n";
}
else{
$query = "INSERT INTO tlNews_comment(idNouvelle,date,auteur,msg) VALUES(´$idnews´,´$date´,´$auteur´,´$msg´)";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
echo "Votre commentaire a bien été ajouté.\n";
}
}
echo "</div>";
echo "<a id=´comment´></a><div style=´padding: 15px 15px 15px 15px; text-decoration: underline; font-weight: bold; font-size: 16px;´>Commentaires :</div>";

$query3 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_comment where idNouvelle = ´$idnews´ ORDER BY id DESC";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
while ($row3 = mysql_fetch_array($result3)) {
$msg = mystripslashes(nl2br($row3[´msg´]));

echo "<div style=´border-bottom: 1px dotted #000;´>".$row3[´date´]." par
<b>".mystripslashes($row3[´auteur´])."</b></div>";

echo "<div>".$msg."</div><hr />\n";

}

}
else{

$query1 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_news ORDER BY id DESC limit 0,$nbr_news";
$result1 = mysql_query($query1) or die(´Erreur SQL : ´.mysql_error());
while ($row = mysql_fetch_array($result1)) {
$template = $row[´template´];
$query = "SELECT * FROM tlNews_template where title = ´$template´";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
$val = mysql_fetch_array($result);

$vign = $row[´vign´];
$query2 = "SELECT * FROM tlNews_vign where title = ´$vign´";
$result2 = mysql_query($query2) or die(´Erreur SQL : ´.mysql_error());
$row1 = mysql_fetch_array($result2);

$idnews = $row[´id´];
$query3 = "SELECT * FROM tlNews_comment where idNouvelle = ´$idnews´";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
$nb = mysql_num_rows($result3);

$val[´code´] = str_replace("[titre]", mystripslashes($row[´title´]), $val[´code´]);
$val[´code´] = str_replace("[auteur]", $row[´auteur´], $val[´code´]);
$val[´code´] = str_replace("[vign]", "<img src=´./tlNews/".$row1[´url´]."´ alt=´vign´ />", $val[´code´]);
$val[´code´] = str_replace("[date]", $row[´date´], $val[´code´]);
$val[´code´] = str_replace("[chapeau]", mystripslashes(nl2br($row[´chapeau´])), $val[´code´]);
$val[´code´] = str_replace("[suite]", "<p><a href=´?idNouvelle=".$row[´id´]."´>Lire la Suite</a></p>", $val[´code´]);
$val[´code´] = str_replace("[src]", "<a href=´".$row[´src´]."´>".$row[´src´]."</a>", $val[´code´]);
$val[´code´] = str_replace("[comment]", "<a href=´?idNouvelle=".$idnews."#comment´>".$nb." commentaire(s)</a>", $val[´code´]);

echo $val[´code´];
}
}
echo "<hr /><div style=´text-align: center;´><a href=´http://www.tommyweb.org´ title=´Annuaire de scripts PHP / MySql´>tlNews par Tommy Leunen.</a></div>";
mysql_close();
}

function afficher_archives() {
if(isset($_GET[´annee´]) AND isset($_GET[´mois´])){
if($_GET[´mois´] <= "9") { $_GET[´mois´] = "0".$_GET[´mois´]; }
else { $_GET[´mois´]; }
$datearch = $_GET[´annee´]."-".$_GET[´mois´];
$query1 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_news WHERE date LIKE ´$datearch%´ ORDER BY id DESC";
$result1 = mysql_query($query1) or die(´Erreur SQL : ´.mysql_error());
while ($row = mysql_fetch_array($result1)) {
$template = $row[´template´];
$query = "SELECT * FROM tlNews_template where title = ´$template´";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
$val = mysql_fetch_array($result);

$vign = $row[´vign´];
$query2 = "SELECT * FROM tlNews_vign where title = ´$vign´";
$result2 = mysql_query($query2) or die(´Erreur SQL : ´.mysql_error());
$row1 = mysql_fetch_array($result2);

$idnews = $row[´id´];
$query3 = "SELECT * FROM tlNews_comment where idNouvelle = ´$idnews´";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
$nb = mysql_num_rows($result3);

$val[´code´] = str_replace("[titre]", mystripslashes($row[´title´]), $val[´code´]);
$val[´code´] = str_replace("[auteur]", $row[´auteur´], $val[´code´]);
$val[´code´] = str_replace("[vign]", "<img src=´./tlNews/".$row1[´url´]."´ alt=´vign´ />", $val[´code´]);
$val[´code´] = str_replace("[date]", $row[´date´], $val[´code´]);
$val[´code´] = str_replace("[chapeau]", mystripslashes(nl2br($row[´chapeau´])), $val[´code´]);
$val[´code´] = str_replace("[suite]", "<p><a href=´?idNouvelle=".$row[´id´]."´>Lire la Suite</a></p>", $val[´code´]);
$val[´code´] = str_replace("[src]", "<a href=´".$row[´src´]."´>".$row[´src´]."</a>", $val[´code´]);
$val[´code´] = str_replace("[comment]", "<a href=´?idNouvelle=".$idnews."#comment´>".$nb." commentaire(s)</a>", $val[´code´]);

echo $val[´code´];
}
}
elseif(isset($_GET[´idNouvelle´])){
$idnews = $_GET[´idNouvelle´];

$query1 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_news where id = ´$idnews´";
$result1 = mysql_query($query1) or die(´Erreur SQL : ´.mysql_error());
while ($row = mysql_fetch_array($result1)) {
$template = $row[´template´];
$query = "SELECT * FROM tlNews_template where title = ´$template´";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
$val = mysql_fetch_array($result);

$vign = $row[´vign´];
$query2 = "SELECT * FROM tlNews_vign where title = ´$vign´";
$result2 = mysql_query($query2) or die(´Erreur SQL : ´.mysql_error());
$row1 = mysql_fetch_array($result2);

$idnews = $row[´id´];
$query3 = "SELECT * FROM tlNews_comment where idNouvelle = ´$idnews´";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
$nb = mysql_num_rows($result3);

$val[´code´] = str_replace("[titre]", mystripslashes($row[´title´]), $val[´code´]);
$val[´code´] = str_replace("[auteur]", $row[´auteur´], $val[´code´]);
$val[´code´] = str_replace("[vign]", "<img src=´./tlNews/".$row1[´url´]."´ alt=´vign´ />", $val[´code´]);
$val[´code´] = str_replace("[date]", $row[´date´], $val[´code´]);
$val[´code´] = str_replace("[chapeau]", mystripslashes(nl2br($row[´chapeau´])), $val[´code´]);
$val[´code´] = str_replace("[suite]", mystripslashes(nl2br($row[´content´])), $val[´code´]);
$val[´code´] = str_replace("[src]", "<a href=´".$row[´src´]."´>".$row[´src´]."</a>", $val[´code´]);
$val[´code´] = str_replace("[comment]", "<a href=´?idNouvelle=".$idnews."#comment´>".$nb." commentaire(s)</a>", $val[´code´]);

echo $val[´code´];
}
echo "<div style=´text-align: center; font-weight: bold;´><a
href=´?idNouvelle=".$idnews."&comment=ajout´>A
jouter un commentaire.</a></div>";
echo "<div style=´text-align: center;´>";
if($_GET[´comment´] == ´ajout´){

echo "<form action=´?idNouvelle=".$idnews."&comment=send´ method=´post´>";
echo ´Auteur : <br /><input type="text" name="auteur" size="50" maxlength="255" /><br />´;

echo ´Commentaire : <br /><textarea name="msg" cols="50" rows="5"></textarea><br />´;

echo ´<input type="submit" name="submit" value="Ajouter" />´;
echo "</form>";

}
elseif($_GET[´comment´] == ´send´){
$auteur =
myaddslashes(htmlspecialchars($_POST[´auteur´]));

$msg = myaddslashes(htmlspecialchars($_POST[´msg´]));
$date = date("Y-m-d H:i:s");
$idnews = $_GET[´idNouvelle´];

if(empty($auteur) || empty($msg)){
echo "Veuillez remplir tous les champs.\n";
}
else{
$query = "INSERT INTO tlNews_comment(idNouvelle,date,auteur,msg) VALUES(´$idnews´,´$date´,´$auteur´,´$msg´)";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
echo "Votre commentaire a bien été ajouté.\n";
}
}
echo "</div>";
echo "<a id=´comment´></a><div style=´padding: 15px 15px 15px 15px; text-decoration: underline; font-weight: bold; font-size: 16px;´>Commentaires : </div>";

$query3 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_comment where idNouvelle = ´$idnews´ ORDER BY id DESC";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
while ($row3 = mysql_fetch_array($result3)) {
$msg = mystripslashes(nl2br($row3[´msg´]));

echo "<div style=´border-bottom: 1px dotted #000;´>".$row3[´date´]." par
<b>".mystripslashes($row3[´auteur´])."</b></div>";

echo "<div>".$msg."</div><hr />\n";

}

}
else{

$query = "SELECT DISTINCT MONTH(date) AS mois, YEAR(date) AS annee FROM tlNews_news ORDER BY annee DESC, mois DESC";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());

$annee = "grrrr";
echo "<ul>\r";

while ($val = mysql_fetch_array($result)) {
if($val[´mois´] <= "9") {
$mois = str_replace(array("1", "2", "3", "4", "5", "6", "7", "8", "9"), array("Janvier", "Février", "Mars", "Avril", "Mai", "Juin", "Juillet", "Août", "Septembre "), $val[´mois´]);
}
else{
$mois = str_replace(array("10", "11", "12"), array("Octobre", "Novembre", "Décembre"), $val[´mois´]);
}

if ($annee != $val[´annee´]) {
echo "<li style=´list-style-type: none; margin: 5px 0px 5px -35px; font-weight: bold;´>Archives des nouvelles postées en ".$val[´annee´].".</li>\r";
}
else{ }
echo "<li style=´list-style-type: square;´><a
href=´?annee=".$val[´annee´]."&mois=".$val[´mo
is´]."´>".$mois." ".$val[´annee´]."</a></li>\r"; //retirer ./?page=archives pour les autres
$annee = $val[´annee´];

}
echo "</ul>\r";
}
echo "<hr /><div style=´text-align: center;´><a href=´http://www.tommyweb.org´ title=´Annuaire de scripts PHP / MySql´><a href=´http://www.tommyweb.org´>tlNews par Tommy Leunen.</a></div>";
mysql_close();
}
?>

captain_torche
captain_torche
Niveau 10
22 octobre 2005 à 12:23:59

Apparemment, tu appelles deux fois le fichier function_aff.php, d´où le souci.

Kety_StyLe93
Kety_StyLe93
Niveau 9
22 octobre 2005 à 12:25:25

et comment régler le blem

A-spec59
A-spec59
Niveau 10
22 octobre 2005 à 12:30:12

ben tu l´apel qu´une seule fois
Perso moi mon script de news fé 46 lignes + pour afficher 10 ligne sa doit faire en tout 56 lignes alors quand je vois ton truc .... ^^

Sous forums
  • Aide à l'achat Mac
  • Création de Jeux
  • Linux
  • Création de sites web
  • Programmation
  • Internet
  • Steam Deck
  • Macintosh
  • Hardware
La vidéo du moment