سلام عليكم اخواني تعبت من تعدد صفحات يعرض لي تحت صفحات بس استعلامات زي ماهي حطيت ثلاث استعلامات بصفحة فقط بس نفس حكاية يطلع لي عشين استعلام وتحت مكتوب صفحات 1 23 :
كود:
<?php
include ("lon.php");
$text = array(
'<img src="./images/a.gif" width="16" height="16">',
'<img src="./images/a.gif" width="16" height="16">',
'<img src="./images/a.gif" width="16" height="16">',
'<img src="./images/a.gif" width="16" height="16">',
'<img src="./images/a.gif" width="16" height="16">',
'<img src="./images/a.gif" width="16" height="16">',);
$body = array(
'(:',
':)',
':|',
'*:',
':&',
':+',);
$msg_of = str_replace($body,$text,$msg_of);
$query = "SELECT * FROM shoutbox";
$relst = mysql_query($query);
while ($ro=mysql_fetch_array($relst)){
?>
<center>
<table border='1' cellpadding='0' cellspacing='0' style='border-collapse: collapse' id='AutoNumber1' height='95' width="499">
<tr>
<td width='497' style='border-style: solid; border-width: 1' height='24' align='center' colspan="4" bgcolor="#F5F5F5">
</td>
</tr>
<tr>
<td width='36' style='border-style: solid; border-width: 1' height='18' align='center' bgcolor="#F5F5F5">
<font face='Tahoma' style="font-size: 9pt; font-weight:700"><?=(email_of)?><span lang="en-us">
:</span></font></td>
<td width='244' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18'>
<p align='center'>
<?=$ro['email_of']?></td>
<td width='57' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18' bgcolor="#F5F5F5">
<p align="center"><font face="Tahoma">
<span style="font-size: 9pt; font-weight:700"><?=(user_of)?><span lang="en-us"> :</span></span></font></td>
<td width='151' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18'>
<p align="center">
<?=$ro['user_of']?></td>
</tr>
<tr>
<td width='36' style='border-style: solid; border-width: 1' height='18' align='center' bgcolor="#F5F5F5">
<font face="Tahoma" style="font-size: 9pt; font-weight:700"><?=(site_of)?><span lang="en-us">
:</span></font></td>
<td width='244' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18'>
<p align="center">
<?=$ro['site_of']?></td>
<td width='67' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18' bgcolor="#F5F5F5">
<p align="center"><b><font face="Tahoma">
<span style="font-size: 9pt"> </span><span style="font-size: 9pt" lang="en-us">Ip
:</span></font></b></td>
<td width='151' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-bottom-style:solid; border-bottom-width:1' height='18'>
<p align="center">
4</td>
</tr>
<tr>
<td width='497' style='border-left-style:solid; border-left-width:1; border-right-style:solid; border-right-width:1; border-top-style:solid; border-top-width:1' height='25' align='center' bgcolor="#F5F5F5" colspan="4">
<?=(msg_of)?></td>
</tr>
<tr>
<td width='36' style='border-style: solid; border-width: 1' height='25' align='center' bgcolor="#F5F5F5">
</td>
<td width='461' style='border-style: solid; border-width: 1' height='25' colspan="3">
<p align='center'><?=$ro['msg_of']?></td>
</table>
</center>
</div>
<p align='center'> ==============
<br>
<?
}
ÇáÕÝæÝ ÇáÊí ÊæÏ ÅÙåÇÑåÇ Ýí ßá ÕÝÍÉ ..
$limit = 2;
$result = mysql_query("select * from shoutbox");
// ÚÏÏ ÇáÕÝæá Ýí ÇáÌÏæá ..
$numrows = mysql_num_rows($result);
if (empty($offset)) { $offset = 0; }
// $limit , $offset ÇáÇÎÊíÇÑ ãä ÇáÌÏæá ÇÚÊãÇÏÇð Úáì ãÊÛíÑíä åãÇ
$result = mysql_query("select * "." from shoutbox "." limit $offset,$limit");
echo "<table width=90% dir=rtl align=center cellspacing=1 cellpadding=1 border=1>";
while($row = mysql_fetch_array($result)) {
$id = $row["id"];
$title = $row["title"];
echo "<tr><td><font size=2><center>$id</td></tr>";
echo "<tr><td><font size=2><center>$title</td></tr>";
}
echo "</table>";
echo "<table width=90% dir=rtl align=center cellspacing=1 cellpadding=1 border=1>";
echo "<tr><td><font size=2><center>";
if ($offset >= 1) {
$prevoffset = $offset - $limit;
print "<a href=\"$PHP_SELF?offset=$prevoffset\">ÇáÓÜÇÈÞ</a> \n";
}
$pages=intval($numrows/$limit);
if ($numrows%$limit) {
$pages++;
}
for ($i = 1; $i <= $pages; $i++) {
$newoffset = $limit*($i-1);
if ($newoffset == $offset) {
print "<font size=2><b>$i</b></font> \n";
} else {
print "<a href=\"$PHP_SELF?offset=$newoffset\">$i</a> \n";
}
}
if (! ( ($offset/$limit) == ($pages - 1) ) && ($pages != 1) ) {
$newoffset = $offset+$limit;
print "<a href=\"$PHP_SELF?offset=$newoffset\">ÇáÊÜÇáí</a>\n";
}
echo "</td></tr></table>";
?>