Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // config-------------------------------------
- $host = "localhost"; //your database host
- $user = "USERNAME"; // your database user name
- $pass = "PASSWORD"; // your database password
- $db = "DATABASENAME"; // your database name
- $filename = "test.php"; // name of this file
- $option = array (5, 10, 25, 50, 100, 200);
- $default = 10; // default number of records per page
- $action = $_SERVER['PHP_SELF']; // if this doesn't work, enter the filename
- $query = "SELECT `memberName` FROM `smf_members`ORDER BY `dateRegistered`"; // 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->memberName\">$row->memberName</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";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement