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.

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

Hj�lp til sideopdeling