Archief - PHP: Gezocht: Data opsplitsen in pagina's

<?php
mysql_connect("localhost", "your_username", "your_password") or die("could not connect");
mysql_select_db("your_database");

  $result = mysql_query("select count(id) from you_table");
  $count = mysql_result($result,0);
  echo "<b>$count</b> items in the database.<hr>";
  mysql_free_result($result);

  //If register globals is off in php.ini: $page=$_GET["page"];
  $pagelinks = "&nbsp;";

  $rpp = 3;  // result per page
  if ($page) {
    $sqlstart = ($page - 1) * $rpp;
  } else {
    $sqlstart = 0;
    $page = 1;
  }

  if ($count >= $rpp && $count > 0) {

	$pages = $count / $rpp;
    $pages = ceil($pages);

	$to= $pages;

	$from=1;
	
	$previous= $page-1;
	$next= $page+1;

	if ($next>$pages) 
	{
		$next = $pages;
	}
	
	$pagelinks .= "<a href=\"list.php?page=1\">|<< First</a>&nbsp;&nbsp;&nbsp;";
    $pagelinks .= "<a href=\"list.php?page=$previous\"><<< Previous</a> ";
	$pagelinks .= "&nbsp;<a href=\"list.php?page=$next\">Next >>></a>";
	$pagelinks .= "&nbsp;&nbsp;&nbsp;<a href=\"list.php?page=$pages\">Last >>|</a></font><br>";

    for ($i = $from; $i <= $to; $i++) 
	{
      if ($i != $page) 
		{
        $pagelinks .= "&nbsp;<a href=\"list.php?page=$i\">$i</a>&nbsp;";
      } else 
			{
        $pagelinks .= "&nbsp;<font color=\"#000000\" size=\"6\"><b>$i</b></font>&nbsp;";
			}
		}
	}

  // If there are more results than specified in $rpp then show the prvious and next links together with the numbred pages.
    if($count > $rpp){
      echo "$pagelinks<br><br>";
    }

    $query = "select * from your_table order by id limit $sqlstart, $rpp";
    $result = mysql_query($query) or die(mysql_error());

    while ($r = mysql_fetch_array($result)) {
	// print the code...

	$id = $r["id"];
	$waarde = $r["waarde"];


	echo "$waarde";
	
}

?>

$page = isset($_GET['page'])?$_GET['page']:0;