| | |||||||
| |||||||
| |||||||
|
|
|
|
|
|
|
This script enables you to create page number links and previous / next links. It is useful when displaying search results or large amount of data. It also allows user to choose how many records to display per page. By : tebrino <?php /* This script enables you to create page number links and previous / next links. It is useful when displaying search results or large amount of data. It also allows user to choose how many records to display per page. To use it simply replace MySQL queries with your own. With small changes you can use it with any database server. To use it simply edit the config part and line marked with text "EDIT ME" and that's it. Enjoy. If you have any questions, comments, or if you find any bugs please feel free to contact me: Author: Ilir Fekaj Contact: tebrino@hotmail.com Website / live demo: http://www.freemidi.breezeland.com/page_numbers.php Created: July 01. 2003. Modified: July 02. 2003. Version: 1.0.1 If you like it, use it, you can also give me a credit. */ // config------------------------------------- $host = "localhost"; //your database host $user = "username"; // your database user name $pass = "password"; // your database password $db = "database_name"; // your database name $filename = "your_file_name.php"; // name of this file $option = array (5, 10, 25, 50, 100, 200); $default = 25; // default number of records per page $action = $_SERVER['PHP_SELF']; // if this doesn't work, enter the filename $query = "SELECT title, url FROM table_name ORDER BY title"; // database query. Enter your query here // end config--------------------------------- $opt_cnt = count ($option); $go = $_GET['go']; // paranoid if ($go == "") { $go = $default; } elseif (!in_array ($go, $option)) { $go = $default; } elseif (!is_numeric ($go)) { $go = $default; } $nol = $go; $limit = "0, $nol"; $count = 1; echo "<form name=\"form1\" id=\"form1\" method=\"get\" action=\"$action\">\r\n"; echo "<select name=\"go\" id=\"go\">\r\n"; for ($i = 0; $i <= $opt_cnt; $i ++) { if ($option[$i] == $go) { echo "<option value=\"".$option[$i]."\" selected=\"selected\">".$option[$i]."</option>\r\n"; } else { echo "<option value=\"".$option[$i]."\">".$option[$i]."</option>\r\n"; } } echo "</select>\r\n"; echo "<input type=\"submit\" name=\"Submit\" id=\"Submit\" value=\"Go\" />\r\n"; echo "</form>\r\n"; $connection = mysql_connect ($host, $user, $pass) or die ("Unable to connect"); mysql_select_db ($db) or die ("Unable to select database $db"); // control query------------------------------ /* this query checks how many records you have in your table. I created this query so we could be able to check if user is trying to append number larger than the number of records to the query string.*/ $off_sql = mysql_query ("$query") or die ("Error in query: $off_sql".mysql_error()); $off_pag = ceil (mysql_num_rows($off_sql) / $nol); //-------------------------------------------- $off = $_GET['offset']; //paranoid if (get_magic_quotes_gpc() == 0) { $off = addslashes ($off); } if (!is_numeric ($off)) { $off = 1; } // this checks if user is trying to put something stupid in query string if ($off > $off_pag) { $off = 1; } if ($off == "1") { $limit = "0, $nol"; } elseif ($off <> "") { for ($i = 0; $i <= ($off - 1) * $nol; $i ++) { $limit = "$i, $nol"; $count = $i + 1; } } // Query to extract records from database. $sql = mysql_query ("$query LIMIT $limit") or die ("Error in query: $sql".mysql_error()); while ($row = mysql_fetch_object($sql)) { // EDIT ME. Edit the line below to match your own table. Just replace $row->url with $row->your_table_column echo "$count. <a href=\"$row->url\">$row->title</a><br />\r\n"; // this is example, you may enter here anything you like $count += 1; } echo "<br /><br />\r\n"; if ($off <> 1) { $prev = $off - 1; echo "[ < <a href=\"$filename?offset=$prev&go=$go\">prev</a> ] \r\n"; } for ($i = 1; $i <= $off_pag; $i ++) { if ($i == $off) { echo "[<b> $i </b>] \r\n"; } else { echo "[ <a href=\"$filename?offset=$i&go=$go\">$i</a> ] \r\n"; } } if ($off < $off_pag) { $next = $off + 1; echo "[ <a href=\"$filename?offset=$next&go=$go\">next</a> > ] \r\n"; } echo "<br /><br />\r\n"; echo "Page $off of $off_pag<br />\r\n"; ?>
More Site Navigation Code Articles |
| |
| |