Hi all,

Can Someone please help me in navigating through the data present in database table on a form by using " NEXT " & " PREVIOUS " buttons using JSP.



                             Id : 009
                        Name : Abc
                Percentage : 81


                 << PREVIOUS NEXT >>


this is the structure.

Thanks in advance,
Prad.

Prad,
First you need to know the total no of rows in your Select query in your example:

$con = mysqli_connect($host, $username, $password, $databasename);

$sql = "SELECT * FROM tablename";

$rst = $con->query($sql);

$num_rows = $rst->num_rows;

// Assuming you want to show 3 record ins a page:
$offset = 0;
$limit = 3

SELECT Id, Name, Percentage
FROM tablename
LIMIT $offset, $limit;

// create a script to show your example here:

// Your footer:
// Create the 'previous' link
if ($offset > 0) {
   $prev = $offset - $limit;;
   $url = $_SERVER['PHP_SELF']."?offset=$prev";
   echo "<a href=\"$url\">Previous</a> ";
}

// Create the 'next' link
if ($offset < ($num_rows-$limit)) {
   $next = $offset + $limit;
   $url = $_SERVER['PHP_SELF']."?offset=$next";
   echo "<a href=\"$url\">Next</a>";
}

enjoy

Hi Jmaronilla,

    Thanks for your help, your code really helped me a lot. I have one more problem, Can u give me some more help in doing the same application using Java Server Pages.
Thanks in advance,
Prad.

Prad,
Sorry, I don't know Java Server Pages.

Hi Jmaronilla,
  No problem, anyway thank you very much.

Prad