здравейте искам да питам как 6те стане тая система когато показва новините да ограничава текста до 30 символа и след това "повече" и като се натисне повече да отваря новината да отделна страница
Код:
$conn = @mysql_connect( "localhost","root","root")
or die ( "Грешка при свързването");
$rs = @mysql_select_db( "bobi", $conn)
or die ("Няма връзка с базаданните");
$broinastranica = 100;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$query = "select ime,text,avtor,pic from $bobi order by id desc" .
" LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('');
echo "<table border=1>";
while($row = mysql_fetch_array($result))
{
echo ( "<table id=\"table\" align=\"center\"><td>
<table id=\"table1\" >
<td><center>".$row['ime']."</center>
</td>
</table>
<table id=\"table2\">
<tr><td width=\"90px\" height=\"60px\"><a href=".$row['pic']."><img src=".$row['pic']." width=\"90px\" height=\"60px\" border=\"0\"></a>
<td>".$row['text']."
</td>
</tr>
</table>
<table id=\"table3\" >
<td><center>22.09.2008</center></td>
</table>
<table id=\"table4\">
<td>Публикувано от: ".$row['avtor']."</td>
</table>
</td>
</table><br>");
}
echo"</table>";
$query = "SELECT COUNT(ime) AS numrows FROM $bobi";
$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?page=$page\">$page</a> ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href=\"$self?page=$page\"> </a> ";
}
else
{
$predishna = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page\" </a> ";
}
else
{
$sledvashta = ' ';
}
?>
<center><?php echo $predishna . $nomeranastranici . $sledvashta ;?></center>