| |
| ارجو مساعدة في تعدد صفحات
سلام عليكم اخواني تعبت من تعدد صفحات يعرض لي تحت صفحات بس استعلامات زي ماهي حطيت ثلاث استعلامات بصفحة فقط بس نفس حكاية يطلع لي عشين استعلام وتحت مكتوب صفحات 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>";
?>
|
01-02-2006, 03:04 PM
| | | | |