im using a tutorial that make a dynamic next/previous button. I can get the menu to show up("previous 1 2 3 4 5 next")links, but my records that im trying to show is not. What am i missing ??? Please help. Here is the php class that im using
Code:
<?php
/*
Class navbar
Copyright Joao Prado Maia (jpm@musicalidade.net)
Sweet little class to build dynamic navigation links. Please
notice the beautiful simplicity of the code. This code is
free in any way you can imagine. If you use it on your own
script, please leave the credits as it is. Also, send me an
e-mail if you do, it makes me happy :)
Below goes an example of how to use this class:
===============================================
<?php
$nav = new navbar;
$nav->numrowsperpage = 1;
$sql = "SELECT * FROM links ";
$result = $nav->execute($sql, $db, "mysql");
$rows = mysql_num_rows($result);
for ($y = 0; $y < $rows; $y++) {
$data = mysql_fetch_object($result);
echo $data->url . "<br>\n";
}
echo "<hr>\n";
$links = $nav->getlinks("all", "on");
for ($y = 0; $y < count($links); $y++) {
echo $links[$y] . " ";
}
?>
*/
class navbar {
// Default values for the navigation link bar
var $numrowsperpage = 2;
var $str_previous = "Previous page";
var $str_next = "Next page";
// Variables used internally
var $file;
var $total_records;
// The next function runs the needed queries.
// It needs to run the first time to get the total
// number of rows returned, and the second one to
// get the limited number of rows.
//
// $sql parameter :
// . the actual SQL query to be performed
//
// $db parameter :
// . the database connection link
//
// $type parameter :
// . "mysql" - uses mysql php functions
// . "pgsql" - uses pgsql php functions
function execute($sql, $db, $type = "mysql") {
global $total_records, $row, $numtoshow;
$numtoshow = $this->numrowsperpage;
if (!isset($row)) $row = 0;
$start = $row * $numtoshow;
if ($type == "mysql") {
$result = mysql_query($sql, $db);
$total_records = mysql_num_rows($result);
$sql .= " LIMIT $start, $numtoshow";
$result = mysql_query($sql, $db);
} elseif ($type == "pgsql") {
$result = pg_Exec($db, $sql);
$total_records = pg_NumRows($result);
$sql .= " LIMIT $numtoshow, $start";
$result = pg_Exec($db, $sql);
}
return $result;
}
// This function creates a string that is going to be
// added to the url string for the navigation links.
// This is specially important to have dynamic links,
// so if you want to add extra options to the queries,
// the class is going to add it to the navigation links
// dynamically.
function build_geturl()
{
global $REQUEST_URI, $REQUEST_METHOD, $HTTP_GET_VARS, $HTTP_POST_VARS;
list($fullfile, $voided) = explode("?", $REQUEST_URI);
$this->file = $fullfile;
$cgi = $REQUEST_METHOD == 'GET' ? $HTTP_GET_VARS : $HTTP_POST_VARS;
reset ($cgi);
while (list($key, $value) = each($cgi)) {
if ($key != "row")
$query_string .= "&" . $key . "=" . $value;
}
return $query_string;
}
// This function creates an array of all the links for the
// navigation bar. This is useful since it is completely
// independent from the layout or design of the page.
// The function returns the array of navigation links to the
// caller php script, so it can build the layout with the
// navigation links content available.
//
// $option parameter (default to "all") :
// . "all" - return every navigation link
// . "pages" - return only the page numbering links
// . "sides" - return only the 'Next' and / or 'Previous' links
//
// $show_blank parameter (default to "off") :
// . "off" - don't show the "Next" or "Previous" when it is not needed
// . "on" - show the "Next" or "Previous" strings as plain text when it is not needed
function getlinks($option = "all", $show_blank = "on") {
global $total_records, $row, $numtoshow;
$extra_vars = $this->build_geturl();
$file = $this->file;
$number_of_pages = ceil($total_records / $numtoshow);
$subscript = 0;
for ($current = 0; $current < $number_of_pages; $current++) {
if ((($option == "all") || ($option == "sides")) && ($current == 0)) {
if ($row != 0)
$array[0] = '<A HREF="' . $file . '?row=' . ($row - 1) . $extra_vars . '">' . $this->str_previous . '</A>';
elseif (($row == 0) && ($show_blank == "on"))
$array[0] = $this->str_previous;
}
if (($option == "all") || ($option == "pages")) {
if ($row == $current)
$array[++$subscript] = ($current > 0 ? ($current + 1) : 1);
else
$array[++$subscript] = '<A HREF="' . $file . '?row=' . $current . $extra_vars . '">' . ($current + 1) . '</A>';
}
if ((($option == "all") || ($option == "sides")) && ($current == ($number_of_pages - 1))) {
if ($row != ($number_of_pages - 1))
$array[++$subscript] = '<A HREF="' . $file . '?row=' . ($row + 1) . $extra_vars . '">' . $this->str_next . '</A>';
elseif (($row == ($number_of_pages - 1)) && ($show_blank == "on"))
$array[++$subscript] = $this->str_next;
}
}
return $array;
}
}
?>
Here is the code im using to try and get the records to show.
Code:
// including the navbar class
include("./navbar.php");
// initiate it!
$nav = new navbar;
// set how many records to show at a time
$nav->numrowsperpage = 3;
$sql = " SELECT *
FROM `CSGraphics`
ORDER BY `CSGraphics`.`code` ASC ";
// the third parameter of execute() is optional
$result = $nav->execute($sql, $db, "mysql");
// handle the returned result set
$rows = mysql_num_rows($result);
for ($y = 0; $y < $rows; $y++) {
$data = mysql_fetch_object($result);
echo $data->url . "<br>\n";
}
echo "<hr>\n";
// build the returned array of navigation links
$links = $nav->getlinks("all", "on");
for ($y = 0; $y < count($links); $y++) {
echo $links[$y] . " ";
}
?>
I dont understand why it will not show up , but the link count is correct. Please help. Talkupation X 2 given to whoever helps me.
