la communauté d'entraide francophone dédiée au PHP
Problème d'écriture sortie de BDD en PHP
Eléphanteau du PHP |
49 Messages
Regarde ça : http://electron-libre.fassnet.net/utf8.php
Jérôme
http://www.jeromeweb.net
http://www.jeromeweb.net
Où doit-je la placer ?
<?php
if (empty($_GET['news']))
{
if (empty($_GET['envoi']))
{
header("Location: index.php");
}
else
{
$db = mysql_connect($serveur, $serveurlogin, $serveurpass);
$account = $_SESSION['account'];
mysql_select_db($dbother,$db);
$result20 = mysql_query("SELECT * FROM accounts WHERE account = '$account'");
$row21 = mysql_fetch_array($result20);
$pseudo22 = $row21['pseudo'];
$idnews = $_GET['envoi'];
$date = date("d-m-Y - H:i");
$commentaire = $_POST['elm1'];
$req = "INSERT INTO commentaires (title,content,news_id,created_at) VALUES('$pseudo22','$commentaire','$idnews','$date')";
mysql_query($req);
$dest = 'commentaire.php?news='.$idnews;
echo "<center>Votre commentaire a bien été envoyer !</center>";
}
}
else
{
$news = $_GET['news'];
$db = mysql_connect($serveur, $serveurlogin, $serveurpass);
mysql_select_db($dbother,$db);
$result = mysql_query("SELECT * FROM news WHERE id = '$news'");
$result2 = mysql_query("SELECT * FROM commentaires WHERE news_id = '$news'");
$row = mysql_fetch_array($result) or die(mysql_error());
?>
<h2><?php echo $row['titre'];?></h2>
<p><img class="article" src="<?php echo $row['image'];?>" alt="" height="110" width="110" />
<?php echo $row['text'];?>
<div class="clear"></div>
<h3><?php echo mysql_num_rows($result2);?> Commentaire(s)</h3>
<div id="comment">
<?php
if ( mysql_num_rows($result2) >0 )
{
?>
<div class="comment">
<?php while ($row2 = mysql_fetch_array($result2))
{
?>
<br />
<div class="message">
<div class="messaget">
<h5>Ecrit par
<span class="auteur"><font color="red"><?php echo $row2['title'];?></font></span>
le
<?php echo $row2['created_at'];?>
</h5>
<p><?php echo $row2['content'];?></p>
</div>
</div>
<div class="clear"></div>
<div class="clear"></div>
<?php }
}
else
{
echo "<br /><center>Aucun commentaire</center>";
}
?>
<br />
<br />
<script type="text/javascript" src="BBCode/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="BBCode/markitup/jquery.markitup.js"></script>
<script type="text/javascript" src="BBCode/markitup/sets/simple/set.js"></script>
<link rel="stylesheet" type="text/css" href="BBCode/markitup/skins/simple/style.css" />
<link rel="stylesheet" type="text/css" href="BBCode/markitup/sets/simple/style.css" />
<script type="text/javascript">
<!--
$(document).ready(function() {
// Add markItUp! to your textarea in one line
// $('textarea').markItUp( { Settings }, { OptionalExtraSettings } );
$('#markItUp').markItUp(mySettings);
// You can add content from anywhere in your page
// $.markItUp( { Settings } );
$('.add').click(function() {
$.markItUp( { openWith:'<opening tag>',
closeWith:'<\/closing tag>',
placeHolder:"New content"
}
);
return false;
});
// And you can add/remove markItUp! whenever you want
// $(textarea).markItUpRemove();
$('.toggle').click(function() {
if ($("#markItUp.markItUpEditor").length === 1) {
$("#markItUp").markItUpRemove();
$("span", this).text("get markItUp! back");
} else {
$('#markItUp').markItUp(mySettings);
$("span", this).text("remove markItUp!");
}
return false;
});
});
-->
</script><a name="commentaire"></a>
<div class="post">
<?php if (empty($_SESSION['account']))
{ ?>
<center><span class="erreur"><a href="">Connectez-vous</a> pour ajouter un commentaire.</span></center>
</div>
<?php
}
else
{
$db = mysql_connect($serveur, $serveurlogin, $serveurpass);
mysql_select_db($dbother,$db);
$account = $_SESSION['account'];
$result3 = mysql_query("SELECT * FROM accounts WHERE account = '$account'");
$row3 = mysql_fetch_array($result3) or die(mysql_error());
$pseudo10 = $row3['pseudo'];
if ($pseudo10 != NULL)
{
?>
<!-- TinyMCE -->
<script type="text/javascript" src="jscripts/tiny_mce/tiny_mce.js"></script>
<script type="text/javascript">
tinyMCE.init({
// General options
mode : "textareas",
theme : "advanced",
plugins : "pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,wordcount,advlist,autosave",
// Theme options
theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",
theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",
theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",
theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak,restoredraft",
theme_advanced_toolbar_location : "top",
theme_advanced_toolbar_align : "left",
theme_advanced_statusbar_location : "bottom",
theme_advanced_resizing : true,
// Example content CSS (should be your site CSS)
content_css : "css/content.css",
// Drop lists for link/image/media/template dialogs
template_external_list_url : "lists/template_list.js",
external_link_list_url : "lists/link_list.js",
external_image_list_url : "lists/image_list.js",
media_external_list_url : "lists/media_list.js",
// Style formats
style_formats : [
{title : 'Bold text', inline : 'b'},
{title : 'Red text', inline : 'span', styles : {color : '#ff0000'}},
{title : 'Red header', block : 'h1', styles : {color : '#ff0000'}},
{title : 'Example 1', inline : 'span', classes : 'example1'},
{title : 'Example 2', inline : 'span', classes : 'example2'},
{title : 'Table styles'},
{title : 'Table row 1', selector : 'tr', classes : 'tablerow1'}
],
formats : {
alignleft : {selector : 'p,h1,h2,h3,h4,h5,h6,td,th,div,ul,ol,li,table,img', classes : 'left'},
aligncenter : {selector : 'p,h1,h2,h3,h4,h5,h6,td,th,div,ul,ol,li,table,img', classes : 'center'},
alignright : {selector : 'p,h1,h2,h3,h4,h5,h6,td,th,div,ul,ol,li,table,img', classes : 'right'},
alignfull : {selector : 'p,h1,h2,h3,h4,h5,h6,td,th,div,ul,ol,li,table,img', classes : 'full'},
bold : {inline : 'span', 'classes' : 'bold'},
italic : {inline : 'span', 'classes' : 'italic'},
underline : {inline : 'span', 'classes' : 'underline', exact : true},
strikethrough : {inline : 'del'}
},
// Replace values for the template plugin
template_replace_values : {
username : "Some User",
staffid : "991234"
}
});
</script>
<!-- /TinyMCE -->
</head>
<?php
$db = mysql_connect($serveur, $serveurlogin, $serveurpass);
$account = $_SESSION['account'];
mysql_select_db($dbother,$db);
$result9 = mysql_query("SELECT * FROM accounts WHERE account = '$account'");
$row9 = mysql_fetch_array($result9);
$pseudo = $row9['pseudo'];
?>
<?php if ($row9['banned'] == 1) {echo"<center><b><p class='red'> Vous ne pouvez plus laissez de commentaire car votre compte a été banni</p></b></center><br />";} ?>
<?php if ($row9 ['banned'] == 0) {?>
<body>
<form method="post" action="commentaire.php?envoi=<?php echo $news;?>">
</div>
<input name="heure" type="hidden" value="<?php setlocale (LC_TIME, 'fr_FR.utf8','fra');
echo (strftime("%A %d %B"));
?>" />
<h3>Commentaire:</h3>
<p> </p>
<!-- Gets replaced with TinyMCE, remember HTML in a textarea should be encoded -->
<div>
<textarea id="elm1" name="elm1" rows="15" cols="80" style="width: 80%">
</textarea>
</div>
<!-- Some integration calls -->
<a href="javascript:;" onmousedown="tinyMCE.get('elm1').show();">[Montrer]</a>
<a href="javascript:;" onmousedown="tinyMCE.get('elm1').hide();">[Cacher]</a><br />
<br /><br />
<input type="submit" name="save" value="Envoyer" />
</form>
<?php
}
else
{
?>
