Bonjour , je possède un script de news . Mais il ne marche pas (sinon , que ferais-je ici 
?)
Voici le script de news tirée de http://g.carneus-design.com/news.php pour l'instant , je veut qu'il marche tout simplement et après je vais le coller dans le script de mon site .
news.php
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-2" />
<meta name="author" content="[ Autor dokumentu ]" />
<meta name="description" content="[ Opis dokumentu ]" />
<meta name="generator" content="EdHTML" />
<title>Wiadomosci Patrick.pl</title>
</head>
<body>
<?php
mysql_connect("localhost", "root", ""); // Connexion a MySQL
$retour = mysql_query('SELECT * FROM news_puissance');
while ($donnees = mysql_fetch_array($retour))
{
}
echo ''.$donnees['titre'].'<br><img src="images/'.$donnees['image'].'"/><br>';
echo ''.$donnees['contenu'].'<br><br>'; echo $donnees['auteur'];
?>
</body>
</html>
rediger_news.php
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-2" />
<meta name="author" content="[ Autor dokumentu ]" />
<meta name="description" content="[ Opis dokumentu ]" />
<meta name="generator" content="EdHTML" />
<title>Rediger news</title>
<script language="JavaScript" type="text/JavaScript">
function addText(instext) {
var mess = document.forum.contenu;
//IE support
if (document.selection) {
mess.focus();
sel = document.selection.createRange();
sel.text = instext;
document.forum.focus();
}
//MOZILLA/NETSCAPE support
else if (mess.selectionStart || mess.selectionStart == "0") {
var startPos = mess.selectionStart;
var endPos = mess.selectionEnd;
var chaine = mess.value;
mess.value = chaine.substring(0, startPos) + instext + chaine.substring(endPos, chaine.length);
mess.selectionStart = startPos + instext.length;
mess.selectionEnd = endPos + instext.length;
mess.focus();
} else {
mess.value += instext;
mess.focus();
}
}
</script>
</head>
<body>
<?php
mysql_connect("localhost", "root", ""); // Connexion a MySQL
if (isset($_POST['envoyer']) && $_POST['envoyer'] == 'Envoyer')
{
if (empty($_POST['titre']) || empty($_POST['contenu'])) {
$erreur = 'Vous devez remplir tout les champs !';
}
else
{
if ($lien_image != "none") {
$dest_image = "images/".$_FILES['lien_image']['name'];
$image = $_FILES['lien_image']['name'];
$source_file=stripslashes($lien_image);
$res_copy=copy($source_file , $dest_image); }
$sql = mysql_query('INSERT INTO news_puissance VALUES("","'.$_POST['titre'].'", "'.$pseudo.'", "'.$_POST['contenu'].'", "'.$image.'")') or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
echo 'Votre news est en ligne !';
}
}
?>
</body>
</html>
moderer_news.php
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-2" />
<meta name="author" content="[ Autor dokumentu ]" />
<meta name="description" content="[ Opis dokumentu ]" />
<meta name="generator" content="EdHTML" />
<title>Moderer news</title>
</head>
<body>
<?php
if (isset($_GET['supprimer_news']))
{
mysql_query('DELETE FROM news_puissance WHERE id=' . $_GET['supprimer_news']);
}
?>
<table border="1" cellspacing="0">
<tr>
<th width="80">Supprimer</th>
<th width="30">Lien</th>
<th width="6">Titre</th>
<th width="132">Modifier</th>
</tr>
<?php
$retour = mysql_query("SELECT * FROM news_puissance ORDER BY id DESC");
while ($donnees = mysql_fetch_array($retour))
{
?>
<tr>
<td><?php echo '<a href="moderer_news.php?supprimer_news=' . $donnees['id'] . '">'; ?>Supprimer</a></td>
<td><div align="center"><?php echo stripslashes($donnees['page']); ?></div></td>
<td><?php echo stripslashes($donnees['titre']); ?></td>
<td><?php echo '<a href="modifier_news.php?id=' . $donnees['id'] . '">'; ?>Modifier</td>
</tr>
}
</body>
</html>
modifier_news.php
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-2" />
<meta name="author" content="[ Autor dokumentu ]" />
<meta name="description" content="[ Opis dokumentu ]" />
<meta name="generator" content="EdHTML" />
<title>Modifier news</title>
<script language="JavaScript" type="text/JavaScript">
function addText(instext) {
var mess = document.forum.contenu;
//IE support
if (document.selection) {
mess.focus();
sel = document.selection.createRange();
sel.text = instext;
document.forum.focus();
}
//MOZILLA/NETSCAPE support
else if (mess.selectionStart || mess.selectionStart == "0") {
var startPos = mess.selectionStart;
var endPos = mess.selectionEnd;
var chaine = mess.value;
mess.value = chaine.substring(0, startPos) + instext + chaine.substring(endPos, chaine.length);
mess.selectionStart = startPos + instext.length;
mess.selectionEnd = endPos + instext.length;
mess.focus();
} else {
mess.value += instext;
mess.focus();
}
}
</script>
</head>
<body>
<?php
if ($modif==1) {
if (empty($_POST['titre2']) || empty($_POST['contenu2'])) {
$erreur = 'Vous devez remplir tout les champs !';
}
else
{
if ($lien_image != "none") {
$dest_image = "images/".$_FILES['lien_image']['name'];
$image = $_FILES['lien_image']['name'];
$source_file=stripslashes($lien_image);
$res_copy=copy($source_file , $dest_image); }
$sql = mysql_query('UPDATE news_puissance SET titre="'.$_POST['titre2'].'", contenu="'.$_POST['contenu2'].'" WHERE id='.$idarticle.', image="'.$image.'"') or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
} } ?>
<form name="forum" method="post" action="modifier_news.php?modif=1&id=">
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#333333">
<tr>
<td width="90" align="center" bgcolor="#DEBA42" class="texteTITRE">Titre :</td>
<td width="339" align="center" bgcolor="#D5B13F" class="textePRINCIPAL"><input name="titre2" type="text" id="titre2" value="<?php echo $table3['titre']; ?> " size="40"></td>
</tr>
<tr>
<td align="center" valign=top bgcolor="#FFFFFF" class="textePRINCIPAL2"> </td>
<td align="center" bgcolor="#FFFFFF" class="textePRINCIPAL"><textarea name="contenu2" cols="40" rows="10" id="contenu2">
</textarea></td>
</tr>
<tr>
<td></td><td><input type="file" name="lien_image" enctype="multipart/form-data"></td></tr>
<tr>
<td colspan="2" align="center" bgcolor="#D5B13F" class="textePRINCIPAL"><input type="submit" name="envoyer" value="Envoyer" ></td>
</tr>
</table>
</form>
</body>
</html>
Modifié par Spill (15 Aug 2006 - 21:21)
?) Voici le script de news tirée de http://g.carneus-design.com/news.php pour l'instant , je veut qu'il marche tout simplement et après je vais le coller dans le script de mon site .
news.php
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-2" />
<meta name="author" content="[ Autor dokumentu ]" />
<meta name="description" content="[ Opis dokumentu ]" />
<meta name="generator" content="EdHTML" />
<title>Wiadomosci Patrick.pl</title>
</head>
<body>
<?php
mysql_connect("localhost", "root", ""); // Connexion a MySQL
$retour = mysql_query('SELECT * FROM news_puissance');
while ($donnees = mysql_fetch_array($retour))
{
}
echo ''.$donnees['titre'].'<br><img src="images/'.$donnees['image'].'"/><br>';
echo ''.$donnees['contenu'].'<br><br>'; echo $donnees['auteur'];
?>
</body>
</html>
rediger_news.php
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-2" />
<meta name="author" content="[ Autor dokumentu ]" />
<meta name="description" content="[ Opis dokumentu ]" />
<meta name="generator" content="EdHTML" />
<title>Rediger news</title>
<script language="JavaScript" type="text/JavaScript">
function addText(instext) {
var mess = document.forum.contenu;
//IE support
if (document.selection) {
mess.focus();
sel = document.selection.createRange();
sel.text = instext;
document.forum.focus();
}
//MOZILLA/NETSCAPE support
else if (mess.selectionStart || mess.selectionStart == "0") {
var startPos = mess.selectionStart;
var endPos = mess.selectionEnd;
var chaine = mess.value;
mess.value = chaine.substring(0, startPos) + instext + chaine.substring(endPos, chaine.length);
mess.selectionStart = startPos + instext.length;
mess.selectionEnd = endPos + instext.length;
mess.focus();
} else {
mess.value += instext;
mess.focus();
}
}
</script>
</head>
<body>
<?php
mysql_connect("localhost", "root", ""); // Connexion a MySQL
if (isset($_POST['envoyer']) && $_POST['envoyer'] == 'Envoyer')
{
if (empty($_POST['titre']) || empty($_POST['contenu'])) {
$erreur = 'Vous devez remplir tout les champs !';
}
else
{
if ($lien_image != "none") {
$dest_image = "images/".$_FILES['lien_image']['name'];
$image = $_FILES['lien_image']['name'];
$source_file=stripslashes($lien_image);
$res_copy=copy($source_file , $dest_image); }
$sql = mysql_query('INSERT INTO news_puissance VALUES("","'.$_POST['titre'].'", "'.$pseudo.'", "'.$_POST['contenu'].'", "'.$image.'")') or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
echo 'Votre news est en ligne !';
}
}
?>
</body>
</html>
moderer_news.php
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-2" />
<meta name="author" content="[ Autor dokumentu ]" />
<meta name="description" content="[ Opis dokumentu ]" />
<meta name="generator" content="EdHTML" />
<title>Moderer news</title>
</head>
<body>
<?php
if (isset($_GET['supprimer_news']))
{
mysql_query('DELETE FROM news_puissance WHERE id=' . $_GET['supprimer_news']);
}
?>
<table border="1" cellspacing="0">
<tr>
<th width="80">Supprimer</th>
<th width="30">Lien</th>
<th width="6">Titre</th>
<th width="132">Modifier</th>
</tr>
<?php
$retour = mysql_query("SELECT * FROM news_puissance ORDER BY id DESC");
while ($donnees = mysql_fetch_array($retour))
{
?>
<tr>
<td><?php echo '<a href="moderer_news.php?supprimer_news=' . $donnees['id'] . '">'; ?>Supprimer</a></td>
<td><div align="center"><?php echo stripslashes($donnees['page']); ?></div></td>
<td><?php echo stripslashes($donnees['titre']); ?></td>
<td><?php echo '<a href="modifier_news.php?id=' . $donnees['id'] . '">'; ?>Modifier</td>
</tr>
}
</body>
</html>
modifier_news.php
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-2" />
<meta name="author" content="[ Autor dokumentu ]" />
<meta name="description" content="[ Opis dokumentu ]" />
<meta name="generator" content="EdHTML" />
<title>Modifier news</title>
<script language="JavaScript" type="text/JavaScript">
function addText(instext) {
var mess = document.forum.contenu;
//IE support
if (document.selection) {
mess.focus();
sel = document.selection.createRange();
sel.text = instext;
document.forum.focus();
}
//MOZILLA/NETSCAPE support
else if (mess.selectionStart || mess.selectionStart == "0") {
var startPos = mess.selectionStart;
var endPos = mess.selectionEnd;
var chaine = mess.value;
mess.value = chaine.substring(0, startPos) + instext + chaine.substring(endPos, chaine.length);
mess.selectionStart = startPos + instext.length;
mess.selectionEnd = endPos + instext.length;
mess.focus();
} else {
mess.value += instext;
mess.focus();
}
}
</script>
</head>
<body>
<?php
if ($modif==1) {
if (empty($_POST['titre2']) || empty($_POST['contenu2'])) {
$erreur = 'Vous devez remplir tout les champs !';
}
else
{
if ($lien_image != "none") {
$dest_image = "images/".$_FILES['lien_image']['name'];
$image = $_FILES['lien_image']['name'];
$source_file=stripslashes($lien_image);
$res_copy=copy($source_file , $dest_image); }
$sql = mysql_query('UPDATE news_puissance SET titre="'.$_POST['titre2'].'", contenu="'.$_POST['contenu2'].'" WHERE id='.$idarticle.', image="'.$image.'"') or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
} } ?>
<form name="forum" method="post" action="modifier_news.php?modif=1&id=">
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#333333">
<tr>
<td width="90" align="center" bgcolor="#DEBA42" class="texteTITRE">Titre :</td>
<td width="339" align="center" bgcolor="#D5B13F" class="textePRINCIPAL"><input name="titre2" type="text" id="titre2" value="<?php echo $table3['titre']; ?> " size="40"></td>
</tr>
<tr>
<td align="center" valign=top bgcolor="#FFFFFF" class="textePRINCIPAL2"> </td>
<td align="center" bgcolor="#FFFFFF" class="textePRINCIPAL"><textarea name="contenu2" cols="40" rows="10" id="contenu2">
</textarea></td>
</tr>
<tr>
<td></td><td><input type="file" name="lien_image" enctype="multipart/form-data"></td></tr>
<tr>
<td colspan="2" align="center" bgcolor="#D5B13F" class="textePRINCIPAL"><input type="submit" name="envoyer" value="Envoyer" ></td>
</tr>
</table>
</form>
</body>
</html>
Modifié par Spill (15 Aug 2006 - 21:21)