MySQL-Paging med sorteringsvalg

[lokeland]

Jeg har snappet opp denne koden på phpfreaks.com, men vil legge til en mulighet for å kunne sortere resultatene (se øverst på denne siden for å få en pekepinne om hva jeg mener: http://www.pixel2life.com/tutorials/php.php?tut=10) via drop-down's på toppen og nederst for resultatet!

 

<?php 

// Database Connection 
include 'db.php'; 

// If current page number, use it 
// if not, set one! 

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

// Define the number of results per page 
$max_results = 10; 

// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 

// Perform MySQL query on only the current page number's results 

$sql = mysql_query("SELECT * FROM pages LIMIT $from, $max_results"); 

while($row = mysql_fetch_array($sql)){ 
   // Build your formatted results here. 
   echo $row['title']."<br />"; 
} 

// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM pages"),0); 

// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 

// Build Page Number Hyperlinks 
echo "<center>Select a Page<br />"; 

// Build Previous Link 
if($page > 1){ 
   $prev = ($page - 1); 
   echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<Previous</a> "; 
} 

for($i = 1; $i <= $total_pages; $i++){ 
   if(($page) == $i){ 
       echo "$i "; 
       } else { 
           echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "; 
   } 
} 

// Build Next Link 
if($page < $total_pages){ 
   $next = ($page + 1); 
   echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next>></a>"; 
} 
echo "</center>"; 
?>

Endret 4. november 2004 av brainbug90