Здравейте Как да добавя емотикони в коментарите си ето кода:
Код:
<?php
include "conn.php";
if(isset($_POST['submit']))
{
$vic_id = $_GET['id'];
$nick = mysql_real_escape_string(htmlspecialchars($_POST['nick']));
$coment = mysql_real_escape_string(htmlspecialchars($_POST['coment']));
$date = date('d/m/y');
$ip = $_SERVER['REMOTE_ADDR'];
if($nick == NULL)
echo "Въведете име";
elseif($coment == NULL)
echo "Въведете коментар";
else
$zapis = mysql_query("INSERT INTO comments(vic_id,nick,coment,date,ip) VALUES('$vic_id','$nick','$coment','$date','$ip')");
}
if(!empty($logged))
{
echo "
<center>
<form action='' method='POST'>
Автор: <br /><input name='nick' colspan = '3' class = 'fil' value='$logged[username]' readonly='readonly' /><br />
Коментар:<br /><textarea name='coment' class='fil' rows='3' cols='40'></textarea><br>
<input type='submit' name='submit' class = 'btn' value='Изпрати'>
</form></center>
";
}
$broinastranica = 10;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$vic_id = $_GET['id'];
$db = sprintf("SELECT * FROM comments WHERE vic_id='%d' ORDER BY id DESC LIMIT $redove, $broinastranica", $vic_id);
$results = mysql_query($db)or die(mysql_error());
while($row = mysql_fetch_array($results)){
$nick = $row['nick'];
$coment = stripslashes($row['coment']);
$date = $row['date'];
echo "
<center>
<TABLE border='1' align='center'>
<TR valign=top>
<TD width=207 height=12>
Име: <a href = /user:$nick />$nick</a></TD>
<TD width=169 height=12>
Добавен на: $date
</TD>
</TR>
<TR valign=top>
<TD colspan=2 height=79>
$coment
</TD>
</TR>
</TABLE>
</center>
";
}
$query = "SELECT COUNT(id) AS numrows FROM comments WHERE vic_id='$vic_id'";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?id=$vic_id&page=$page\">$page</a> ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href=\"$self?id=$vic_id&page=$page\"> [<] </a> ";
$parva = " <a href=\"$self?id=$vic_id&page=1\">[първа]</a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?id=$vic_id&page=$page\"> [>] </a> ";
$posledna = " <a href=\"$self?id=$vic_id&page=$maxPage\">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo $parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
?>