Udvikleren.dk - Seneste [pagination] forum tr�de

Problemer med udtr�k i paginationsystem?

Tue, 19 Jun 2012 18:17:02 GMT

Hej

Jeg er igang med at lave et pagination-system, og det er ikke selve paginationen, der er problemet.

Kode:

Kode

$query = "SELECT * FROM nyhed_kommentar WHERE nyheder_emne = ?";
if ($stmt = $mysqli->prepare($query)) {

     $stmt->bind_param('i', $nyhed_id);
     
    /* execute query */
    $stmt->execute();

    /* store result */
    $stmt->store_result();
     
        
    $num_rows = mysqli_stmt_num_rows($stmt);


    /* close statement */
    $stmt->close();
}



if (!$_GET['page'])
{
    $page = 1;
    $per_page = 2;
    $limit = $per_page * $page;
    $minimum = 0;
    $count = ceil($num_rows / $per_page);
}
else if ($_GET['page'] == 1)
{
    $page = 1;
    $per_page = 2;
    $limit = $per_page * $page;
   $minimum = 0;
   $count = ceil($num_rows / $per_page);
}

else {
   $page = $_GET['page'];
   $per_page = 2;
   $limit = $per_page * $page;
   $minimum = $limit - 2;
   $count = ceil($num_rows / $per_page);

   
}





$forhold = $count - $page;








echo '<div class="underemne">
Du er p� side ' . $page . ' ud af ' . $count . '<br />
Der er ialt postet ' . $num_rows . ' kommentare. </div>';	




/* Opret et prepared statement */
if ($stmt = $mysqli->prepare('SELECT nyhed_kommentar.nyheds_kommentar_id, nyhed_kommentar.nyheds_kommentar, nyhed_kommentar.nyhed_kommentar_tidspunkt, nyhed_kommentar.nyheds_kommentar_by, nyhed_kommentar.nyheder_emne, brugere.id, brugere.brugernavn FROM nyhed_kommentar LEFT JOIN brugere ON brugere.id = nyhed_kommentar.nyheds_kommentar_by WHERE nyhed_kommentar.nyheder_emne = ? ORDER BY nyhed_kommentar.nyheds_kommentar_id ASC LIMIT ?, ?'))
{
    /* Bind parametre */
    $stmt->bind_param('iii', $nyhed_id, $minimum, $limit);
	
 
 
  
    /* Eksekver foresp?rgslen */
    $stmt->execute();

    /* Bind resultatet */
     $stmt->bind_result($kommentar_nyhed_id, $nyheds_kommentar, $nyhed_kommentar_tidspunkt, $kommentar_tidspunkt, $nyheder_emne, $kommentar_by, $nyhed_kommentar_brugernavn);
    
   
   
     
          
          while ($stmt->fetch()) {
          
          
          echo '<div class="kommentarovertop620"><p class="by"><a class="white" href="profil.php?id=' . $kommentar_by . '">' . $nyhed_kommentar_brugernavn . '</a> @ ' .  $nyhed_kommentar_tidspunkt . '</p></div>';
echo '<div class="kommentaremne">' . nl2br(BBcode($nyheds_kommentar)) . '</div>';	
	
          
          
                  }
    
    
    /* Luk statement */
    $stmt->close();

} else {
    /* Der er opst?et en fejl */
    echo 'Der opstod en fejl i erkl�ringen ';
}



$current = $page;

$current_next = $page + 1;
$current_back = $page - 1;

$current_one = $page + 1;
$current_two = $page + 2;
$current_three = $page + 3;
$current_fore = $page + 4;

$current_minus_one = $page - 1;
$current_minus_two = $page - 2;
$current_minus_three = $page - 3;
$current_minus_fore = $page - 4;

$start = 1;
$end = $count;

echo 'minmun; ' . $minimum . ' limit: ' . $limit . ' <br /><br />';
echo '<br /><br />';


$side = 'nyheder.php';


if ($current > 1 AND $forhold > 1)
{
   echo '<a class="paginate" href="' . $side . '?page=' . $current_back . '">Tilbage</a>';
}

if ($current > 5 AND $forhold > 4)
{
   echo '<a class="paginate" href="' . $side . '?page=' . $start . '">' . $start . '</a>';
}








if ($count > 4 AND $current > 4)
{
   echo '<a class="paginate" href="' . $side . '?page=' . $current_minus_fore . '">' . $current_minus_fore . '</a>';
}

if ($count > 3 AND $current > 3)
{
   echo '<a class="paginate" href="' . $side . '?page=' . $current_minus_three  . '">' . $current_minus_three . '</a>';
}


if ($count > 2 AND $current > 2)
{
   echo '<a class="paginate" href="' . $side . '?page=' . $current_minus_two . '">' . $current_minus_two . '</a>';
}


if ($count > 1 AND $current > 1)
{
   echo '<a class="paginate" href="' . $side . '?page=' . $current_minus_one . '">' . $current_minus_one . '</a>';
}

if ($count > 1) 
{
echo '<a class="current">' . $current . '</a>';
}



if ($count > 1 AND $forhold > 1)
{
     echo '<a class="paginate" href="' . $side . '?page=' . $current_one . '">' . $current_one . '</a>';
}

if ($count > 2 AND $forhold > 2)
{
     echo '<a class="paginate" href="' . $side . '?page=' . $current_two . '">' . $current_two . '</a>';
}

if ($count > 3 AND $forhold > 3)
{
     echo '<a class="paginate" href="' . $side . '?page=' . $current_three . '">' . $current_three . '</a>';
}

if ($count > 4 AND $forhold > 4)
{
     echo '<a class="paginate" href="' . $side . '?page=' . $current_fore . '">' . $current_fore . '</a>';
}





if ($count > 4 AND $forhold > 3)
{
echo '<a class="paginate" href="' . $side . '?page=' . $end . '">' . $end . '</a>';
}

if ($count > 4 AND $forhold > 0)
{
echo '<a class="paginate" href="' . $side . '?page=' . $current_next . '">N�ste</a>';
}

I dette tilf�lde f�r jeg i alt 5 sider.
P� f�rste side bliver der, som der skal 2 poster vist i browseren, men anden side 5 poster udvist. Men min minimum og limit stiger for hver side som de skal og de er jo inde i min mysli prepare statement, men alligevel fungerer det ikke?

Nogen, der kan finde fejlen?

P� forh�nd tak for hj�lpen

Pagination og "?=something"

Mon, 21 Nov 2011 21:51:24 GMT

Hej Udviklere!

Jeg sidder og roder med pagination. Mit script er som f�lgende:

PHP kode

 <?php
     **Database stuff**
     mysql_select_db($database,$db);    
     
     $tbl_name="pictures";        
     $adjacents = 3;
     
     
     $query = "SELECT COUNT(*) as num FROM $tbl_name";
     $total_pages = mysql_fetch_array(mysql_query($query));
     $total_pages = $total_pages[num];
     
     
     $targetpage = "";
     $limit = 72;
     $page = $_GET['page'];
     if($page) 
         $start = ($page - 1) * $limit;             
     else
         $start = 0;
     
     
     $sql = "SELECT ********** FROM $tbl_name WHERE *************** ORDER BY id DESC LIMIT $start, $limit";
     $result = mysql_query($sql);
     
     
     if ($page == 0) $page = 1;
     $prev = $page - 1;
     $next = $page + 1;
     $lastpage = ceil($total_pages/$limit);
     $lpm1 = $lastpage - 1;
     
 
     $pagination = "";
     if($lastpage > 1)
     {    
         $pagination .= "<div class=\"pagination\">";
         if ($page > 1) 
             $pagination.= "<a href=\"$targetpage?page=$prev\"><img src=\"../img/prev.png\" /></a>";
         else
             $pagination.= "<img src=\"../img/prev_disabled.png\" />";    
         
         if ($lastpage < 7 + ($adjacents * 2))
         {    
             for ($counter = 1; $counter <= $lastpage; $counter++)
             {
                 if ($counter == $page)
                     $pagination.= "<span class=\"current\"> $counter</span>";
                 else
                     $pagination.= "<a href=\"$targetpage?page=$counter\"> $counter</a>";                    
             }
         }
         elseif($lastpage > 5 + ($adjacents * 2))
         {
             if($page < 1 + ($adjacents * 2))        
             {
                 for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
                 {
                     if ($counter == $page)
                         $pagination.= "<span class=\"current\"> $counter</span>";
                     else
                         $pagination.= "<a href=\"$targetpage?page=$counter\"> $counter</a>";                    
                 }
                 $pagination.= "...";
                 $pagination.= "<a href=\"$targetpage?page=$lpm1\"> $lpm1</a>";
                 $pagination.= "<a href=\"$targetpage?page=$lastpage\"> $lastpage</a>";        
             }
             elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
             {
                 $pagination.= "<a href=\"$targetpage?page=1\"> 1</a>";
                 $pagination.= "<a href=\"$targetpage?page=2\"> 2</a>";
                 $pagination.= "...";
                 for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
                 {
                     if ($counter == $page)
                         $pagination.= "<span class=\"current\"> $counter</span>";
                     else
                         $pagination.= "<a href=\"$targetpage?page=$counter\"> $counter</a>";                    
                 }
                 $pagination.= "...";
                 $pagination.= "<a href=\"$targetpage?page=$lpm1\"> $lpm1</a>";
                 $pagination.= "<a href=\"$targetpage?page=$lastpage\"> $lastpage</a>";        
             }
             else
             {
                 $pagination.= "<a href=\"$targetpage?page=1\"> 1</a>";
                 $pagination.= "<a href=\"$targetpage?page=2\"> 2</a>";
                 $pagination.= "...";
                 for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
                 {
                     if ($counter == $page)
                         $pagination.= "<span class=\"current\"> $counter</span>";
                     else
                         $pagination.= "<a href=\"$targetpage?page=$counter\"> $counter</a>";                    
                 }
             }
         }
         
         if ($page < $counter - 1) 
             $pagination.= "<a href=\"$targetpage?page=$next\"><img src=\"../img/next.png\" />";
         else
             $pagination.= "<img src=\"../img/next_disabled.png\" />";
         $pagination.= "</div>\n";        
     }
 ?>

Scriptet er fra en god guide, jeg fandt p� Google.
Anyway, mnit sp�rgsm�l er.

N�r jeg bladrer i en side, tilf�jer scriptet automatisk "?=page=2" til URL'en.
S� t�nker jeg logisk, og t�nker at hvis jeg nu s�tter targetpage til:

PHP kode

 $targetpage = "category=animals";

.. ville min url blive: ?category=animals&page=2

Thing is, det virker bare ikke.

Er der nogle der har en id� om hvorfor?

P� forh�nd mange tak!

Med venlig hilsen,
Rai.

Hj�lp til sideopdeling

Sat, 15 Oct 2011 17:20:01 GMT

Hej udviklere!

Jeg sidder og k�mper med at opdele SQL udtr�k i sider. Jeg fandt et lille script p� nettet, men jeg har et lille problem med det.
Jeg antager det virker fint, problemet er bare, at det ikke tr�kker noget ud af min database. Lad mig lige give jer scriptet, og s� hvad jeg tror fejlen er!

PHP kode

 <?php
     include('dbopen.php');    // include your code to connect to DB.
 
     // How many adjacent pages should be shown on each side?
     $adjacents = 1;
     
     /* 
        First get total number of rows in data table. 
        If you have a WHERE clause in your query, make sure you mirror it here.
     */
     $query = "SELECT COUNT(*) as num FROM texts WHERE godkendt =1";
     $total_pages = mysql_fetch_array(mysql_query($query));
     $total_pages = $total_pages[num];
     
     /* Setup vars for query. */
     $targetpage = "oversigt.php";     //your file name  (the name of this file)
     $limit = 25;                                 //how many items to show per page
     $page = $_GET['page'];
     if($page) 
         $start = ($page - 1) * $limit;             //first item to display on this page
     else
         $start = 0;                                //if no page var is given, set start to 0
     
     /* Get data. */
     $sql = mysql_query("SELECT id, text, addedBy FROM texts WHERE godkendt = 1 LIMIT $start, $limit");
     
     /* Setup page vars for display. */
     if ($page == 0) $page = 1;                    //if no page var is given, default to 1.
     $prev = $page - 1;                            //previous page is page - 1
     $next = $page + 1;                            //next page is page + 1
     $lastpage = ceil($total_pages/$limit);        //lastpage is = total pages / items per page, rounded up.
     $lpm1 = $lastpage - 1;                        //last page minus 1
     
     /* 
         Now we apply our rules and draw the pagination object. 
         We're actually saving the code to a variable in case we want to draw it more than once.
     */
     $pagination = "";
     if($lastpage > 1)
     {    
         $pagination .= "<div class=\"pagination\">";
         //previous button
         if ($page > 1) 
             $pagination.= "<a href=\"$targetpage?page=$prev\">« previous</a>";
         else
             $pagination.= "<span class=\"disabled\">« previous</span>";    
         
         //pages    
         if ($lastpage < 7 + ($adjacents * 2))    //not enough pages to bother breaking it up
         {    
             for ($counter = 1; $counter <= $lastpage; $counter++)
             {
                 if ($counter == $page)
                     $pagination.= "<span class=\"current\">$counter</span>";
                 else
                     $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
             }
         }
         elseif($lastpage > 5 + ($adjacents * 2))    //enough pages to hide some
         {
             //close to beginning; only hide later pages
             if($page < 1 + ($adjacents * 2))        
             {
                 for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
                 {
                     if ($counter == $page)
                         $pagination.= "<span class=\"current\">$counter</span>";
                     else
                         $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
                 }
                 $pagination.= "...";
                 $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
                 $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";        
             }
             //in middle; hide some front and some back
             elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
             {
                 $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
                 $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
                 $pagination.= "...";
                 for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
                 {
                     if ($counter == $page)
                         $pagination.= "<span class=\"current\">$counter</span>";
                     else
                         $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
                 }
                 $pagination.= "...";
                 $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
                 $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";        
             }
             //close to end; only hide early pages
             else
             {
                 $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
                 $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
                 $pagination.= "...";
                 for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
                 {
                     if ($counter == $page)
                         $pagination.= "<span class=\"current\">$counter</span>";
                     else
                         $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
                 }
             }
         }
         
         //next button
         if ($page < $counter - 1) 
             $pagination.= "<a href=\"$targetpage?page=$next\">next »</a>";
         else
             $pagination.= "<span class=\"disabled\">next »</span>";
         $pagination.= "</div>\n";        
     }
 ?>
     <?php
     echo "<div class='text'>";
     echo "<table>";
         while($row = mysql_fetch_array($sql))
         {
     
         echo "<tr><td style=\"vertical-align:top;padding:15px;\" >";
         echo "<b>";
         echo "<a href='oversigt.php?page=view&id=". $row['id'] . "'>"; 
         echo ""  . $row["text"];
         echo "</a>";
         echo "</b>";
         echo ", " . $row["addedBy"];
         echo "<br />";
         echo "</td></tr>";
     }
     echo "</table>";
     
     ?>
 
 <?php
 echo $pagination;
 ?>

Jeg g�tter p�, at fejlen ligger i �bningen af databasen:

PHP kode

 $sql = mysql_query("SELECT id, text, addedBy FROM texts WHERE godkendt = 1 LIMIT $start, $limit");

Jeg har siddet og k�mpet med det hele denne l�rdag, men m� give op nu, og s�ge hj�lp herinde

P� forh�nd rigtig mange gange tak, og god weekend!

Rai.