مشكلة تعدد الصفحات

[shesh]

السلام عليكم ورحمة الله وبركاته

اخواني المبرمجين الرجاء مساعدتي في كود تعدد الصفحات بحيث اسبوع وانا ابحث عن الدرس واطبق ولم استطع النجاح .

كود PHP:

<?php


$queryn = "SELECT * FROM news WHERE cat = {$_GET['ID']} ORDER BY ID DESC LIMIT 20";
$resultn = mysql_query($queryn);
$nrowsn = mysql_num_rows($resultn);
$row = mysql_fetch_array($resultn);
while($rown = mysql_fetch_array($resultn)){
?>



                                    <table border="1" cellpadding="0" style="border-width:1px; border-collapse: collapse" width="99%" id="table360" bordercolor="#FFFFFF">
                                            <tr>
                                            <td height="100%" style="border-style: none; border-width: medium; ">
                                            <div align="center">
                                                <table border="0" cellpadding="0" style="border-collapse: collapse" width="100%" id="table369" height="221">
                                                    <tr>
                                                        <td valign="top" height="31">
                                                        <div align="center">
                                                            <table border="1" cellpadding="0" style="border-collapse: collapse; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; border-bottom-width: 4px" width="100%" id="table370" bordercolor="#FF0000">
                                                                <tr>
                                                                    <td bgcolor="#FFFFFF" height="20" style="border-left: medium none #DCDCDC; border-right: medium none #DCDCDC; border-top-style: none; border-top-width: medium">
                                                                    <div align="center">
                                                                        <table border="0" cellpadding="0" style="border-collapse: collapse" width="100%" id="table374" height="27">
                                                                            <tr>
                                                                                <td width="27" bgcolor="#F2F2F2">
                                                                                <p align="center">
                                <font face="Webdings" color="#295F7E">3</font></td>
                                                                                <td bgcolor="#F2F2F2"><span style="font-weight: 700" lang="ar-sa"><font face="Tahoma" style="font-size: 8pt" color="#295F7E"></font></span></td>
                                                                            </tr>
                                                                        </table>
                                                                    </div>
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </div>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px">
                                                        <div align="center">
                                                            <table border="0" cellpadding="0" style="border-collapse: collapse" width="100%" id="table376" height="100%" bgcolor="<?php echo $CatColor; ?>">
                                                                <tr>
                                                                    <td style="border-right-style: solid; border-right-width: 1px" valign="top">
                                                                    <div align="center">
                                                                    
<?php

while($rown = mysql_fetch_array($resultn)){
$sdata = str_replace("\n", " ", $rown['sdata']);
$sdata = substr($sdata,0,60);
$sdata=($sdata . "...");
?>

    <table border="0" cellpadding="0" style="border-collapse: collapse" width="100%" id="table378">
                                                                            <tr>
                                                <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium" bordercolor="#939393" width="119">
                                        <font color="#FFFFFF">
                                        <span style="font-size: 2pt" lang="en-us">
                                        .</span></font></td>
                                                <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium" bordercolor="#939393">
                                        <font color="#FFFFFF" style="font-size: 3pt">
                                        .</font></td>
                                                                            </tr>
                                                                            <tr>
                                                <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium" bordercolor="#939393" width="119" rowspan="2">
                                                <img title="<?php echo $rown['title']; ?>" border="0" src="thumb.php?name=<?php echo $rown['pic1']; ?>&width=128&height=88" width="128" height="88" style="border: 1px solid #FFFFFF"></td>
                                                <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: dotted; border-bottom-width: 1px" bordercolor="#939393">
                                        <div align="right">
                                            <p dir="rtl">
                                            <a target="_self" href= "dispNews.php?ID=<?php echo $rown['ID']; ?>">
                                            <font color="#07519A" face="Tahoma" style="font-size: 9pt; text-decoration:none">
                                            <?php echo $rown['title']; ?></font></a></div>
                                                </td>
                                                                            </tr>
                                                                            <tr>
                                                <td style="border-top-style: none; border-top-width: medium" height="51">
                                                <p dir="rtl" align="justify">
                                                <font face="Tahoma" style="font-size: 9pt; text-decoration:none">
                                                <a target="_self" href= "dispNews.php?ID=<?php echo $rown['ID']; ?>">
                                                <span style="text-decoration: none">
                                                <font color="#000000">
                                                    <?php echo $sdata ?></font></span></a></font></td>
                                                                            </tr>
                                                                        </table>
                                                                        
<?php
}
?>

ملاحظه في بداية الصفحة يوجد كود طلب البيانات من قواعد البيانات .

ادا من الممكن كود تعدد الصفحات على شكل المنتديات وشكرا
وشكرا لكم جزيلا مقدما .

[Kariro]

السلام عليكم
هذا درس باللغة الفرنسية
الرابط
وهذا باللغة العربية
الرابط

بالتوفيق إن شاء الله

[shesh]

هذا درس باللغة الفرنسية
الرابط
وهذا باللغة العربية
الرابط

شكرا اخي على المساعده .
ولكن اخي قرات هذا الدرس زتمتالتجربه ولكن لم انجح فيتطبيق العمل

وشكرا

[Abu Rayane]

الكاتب : shesh

شكرا اخي على المساعده .
ولكن اخي قرات هذا الدرس زتمتالتجربه ولكن لم انجح فيتطبيق العمل

وشكرا

كود PHP:

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8"> 
</head>

<?php


// information pour la connection a la DB
$host = '';
$user = '';
$pass = '';
$db = '';

//charset
$Charset = 'utf8';

// connection à la DB
$link = mysql_connect ($host,$user,$pass);
// encodage
mysql_query("SET NAMES $Charset;", $link) or die('Erreur: '.mysql_error());
// selection de la DB
mysql_select_db($db) or die ('Erreur: '.mysql_error());

if (isset($_GET['page']))
{
    $page = intval($_GET['page']);
}
else
{
    $page = 1;
}

 
if (!isset($start)) $start = 0; // si on arrive sur la page pour la première fois 

$number = '1';
$per_page = '4';
$premiere = '1';
$current = $page;
$suivante = $current + $number;
$precedente = $current - $number;
$start = ($page-1)*$per_page;
$end = $per_page;


$sql1 = "select * from news";
$results1 = mysql_query($sql1,$link) or die('Erreur: '.mysql_error());
$total1 = mysql_num_rows($results1);

if($total1){

$nbre_pages = $total1 / $per_page;
$derniere =ceil($nbre_pages);

$queryn = "SELECT * FROM news WHERE cat = {$_GET['ID']} ORDER BY ID DESC LIMIT ". $start .", ". $end ."";

$results = mysql_query($sql,$link) or die('Erreur: '.mysql_error());

while($row = mysql_fetch_array($results))
  {
  $id = $row['id'];
  $title = $row['title'];
  //...
 
 }
if(($current>= '1')&&($current <= $nbre_pages)){

echo '<a href="pagination.php?page=' .$suivante. '">suivante</a>'; 

} 

echo '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'; 


for ($i=$number; $i<=$derniere; $i++) 
{ 
    
    echo '[<a href="'.$_SERVER['php_self'].'?page=' .$i. '">' .$i. '</a>]&nbsp;';
    
} 


echo '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'; 

if(($current> '1')&&($current <= $derniere)){ 

echo '<a href="pagination.php?page=' .$precedente. '">precedente</a>'; 
} 
} 
    ?>