bankera1990
Registered
Значи не знам как да направя да ми показва само 5 коментара и след това да има втора в която да има др. 5 страница ето и кода
между другото не ми работят емотикони но това е др. въпрос
Код:
<?php
echo "";
$db = mysql_query("SELECT * FROM comments WHERE pesen_id='$id' ORDER by data DESC");
$broi = mysql_num_rows($db);
if($broi == 0)
{
echo "Все още няма добавени коментари към песента, ти би могъл да си първият. <div align='center'><br>";
}
while($row = mysql_fetch_assoc($db))
{
$date = $row['data'];
$comments = $row['komentar'];
$comments = str_replace(":)","<img src='emot/smile.gif'>",$comments);
$comments = str_replace(":D","<img src='emot/icon_biggrin.gif'>",$comments);
$comments = str_replace(":(","<img src='emot/icon_sad.gif'>",$comments);
$comments = str_replace(":O","<img src='emot/icon_surprised.gif'>",$comments);
$comments = str_replace(":shock:","<img src='emot/icon_eek.gif'>",$comments);
$comments = str_replace("::?","<img src='emot/icon_confused.gif'>",$comments);
$comments = str_replace("8)","<img src='emot/icon_cool.gif'>",$comments);
$comments = str_replace(":lol:","<img src='emot/icon_lol.gif'>",$comments);
$comments = str_replace(":x","<img src='emot/icon_mad.gif'>",$comments);
$comments = str_replace(":p","<img src='emot/icon_razz.gif'>",$comments);
$comments = str_replace("оoops:","<img src='emot/icon_redface.gif'>",$comments);
$comments = str_replace(":cry:","<img src='emot/icon_cry.gif'>",$comments);
$comments = str_replace(";)","<img src='emot/icon_wink.gif'>",$comments);
$comments = str_replace("!","<img src='emot/icon_exclaim.gif'>",$comments);
$comments = str_replace("?","<img src='emot/icon_question.gif'>",$comments);
$text = '$comments';
$newtext = wordwrap($comments, 60, "<br />", true);
echo "<table border='0' class='forumline' cellspacing='0' width='100%' cellpadding='3'>
<tr><td class='panel' width='100%'><font size='1'><b>От</b>: <span style='color:#fd8c0a;'><a href='index.php?m=profile&username=$row[username]'><font color='#fd8c0a'>$row[username]</font></a></span> Публикуван на <span style='color:#fd8c0a;'>".date('d-m-Y H:i:s ч.',$row['data'])."</span></td></tr></font><tr><td class='side-body' width='100%'>
<div align='center'></td></tr></table>
<center><table height='20%' width='70%' align='center'><tr><td style='background-color: #ffffff; padding: 5px; border: 1px solid #e5e5e5;' align='center'><span style='font-size: 10px; font-color: #ffcc00;'><div id='pole'>
<div class='scroll'>$newtext</div></div></span></td></tr></table></center><br>";
}
if ($username)
{
echo "<table border='0' class='forumline' cellspacing='0' width='100%' cellpadding='3'>
<tr><td class='panel' width='100%'>Емотикони:</td></tr><tr><td class='side-body' width='100%'>
<div align='center'></td></tr></table>
<a href='javascript:addemo(\" :)\");' title='Усмивка'><img src='emot/smile.gif' alt='Усмивка' border='0'></a>
<a href='javascript:addemo(\" :D\");' title='Смях'><img src='emot/icon_biggrin.gif' alt='Смях' border='0'></a>
<a href='javascript:addemo(\" :(\");' title='Тъжно лице'><img src='emot/icon_sad.gif' alt='Тъжно лице' border='0'></a>
<a href='javascript:addemo(\" :O\");' title='Изненада'><img src='emot/icon_surprised.gif' alt='Изненада' border='0'></a>
<a href='javascript:addemo(\" :shock:\");' title='Шокиран'><img src='emot/icon_eek.gif' alt='Шокиран' border='0'></a>
<a href='javascript:addemo(\" ::?\");' title='Кофти'><img src='emot/icon_confused.gif' alt='Кофти' border='0'></a>
<a href='javascript:addemo(\" 8)\");' title='Пич'><img src='emot/icon_cool.gif' alt='Пич' border='0'></a>
<a href='javascript:addemo(\" :lol:\");' title='Ха-ха-ха'><img src='emot/icon_lol.gif' alt='Ха-ха-ха' border='0'></a>
<a href='javascript:addemo(\" :x\");' title='Набурсучен'><img src='emot/icon_mad.gif' alt='Набурсучен' border='0'></a>
<a href='javascript:addemo(\" :p\");' title='Плезлио'><img src='emot/icon_razz.gif' alt='Плезлио' border='0'></a>
<a href='javascript:addemo(\" оoops:\");' title='Срам'><img src='emot/icon_redface.gif' alt='Срам' border='0'></a>
<a href='javascript:addemo(\" :cry:\");' title='Плач'><img src='emot/icon_cry.gif' alt='Плач' border='0'></a>
<a href='javascript:addemo(\" ;)\");' title='Мигване'><img src='emot/icon_wink.gif' alt='Мигване' border='0'></a>
<a href='javascript:addemo(\" !\");' title='Удивителен'><img src='emot/icon_exclaim.gif' alt='Удивителен!' border='0'></a>
<a href='javascript:addemo(\" ?\");' title='Въпросителен'><img src='emot/icon_question.gif' alt='Въпросителен?' border='0'></a>
<center>
<form method='post' name='message' id='message'> <table border='0' class='forumline' cellspacing='0' width='100%' cellpadding='3'>
<tr><td class='panel' width='100%'>Добави Коментар:</td></tr><tr><td class='side-body' width='100%'>
<div align='center'></td></tr></table><br>
<textarea id='message' name='komentar' cols='60' rows='3' class='inputs'></textarea><br><br>
<input type='submit' value='Добави' name='submit'>
</form><center>";
$username = $username;
$komentar = htmlspecialchars($_POST['komentar']);
$data = time();
if(isset($_POST['submit']))
{
if ($komentar == NULL)
{
echo "<center>Не сте въвели коментар!</center>";
}
else
{
mysql_query("INSERT INTO comments (pesen_id,username,komentar,data) VALUES ('$id','$username','$komentar','$data')") or die(mysql_error());
echo "<center>Коментара Ви е написан успешно!</center>";
die('<META HTTP-EQUIV="refresh" CONTENT="0;URL=index.php?m=play&id='.$id.'">');
}
}
}
else{
echo "<table border='0' class='forumline' cellspacing='0' width='100%' cellpadding='3'>
<tr><td class='panel' width='100%'>За да публикувате коментар трябва да сте регистриран потребител<a href='index.php?m=register'> Регистрация</a></td></tr></table><br>";
}
echo "";
mysql_query("");
$i++;
?>между другото не ми работят емотикони но това е др. въпрос