how will i set pagination ?
Answers were Sorted based on User's Feedback
Answer / rajkumar (rk)
This is the oracle pagination for PHP script... We need to include this in our PHP
<?
$lv_pages = OCIParse($con, $lv_qry);
OCIExecute($lv_pages);
while (OCIFetch($lv_pages))
{
$total = $total+(OCINumCols($lv_pages)-1);
}
$lv_start_rec = $_SESSION['lv_start_rec'];
$lv_end_rec = $_SESSION['lv_end_rec'];
if($_POST['lv_flag']!='')
{
if($_POST['lv_flag']=='1')
{
$lv_first_rec = 1;
$lv_last_rec = 10;
}
if($_POST['lv_flag']=='2')
{
if($lv_start_rec == 1 && $lv_end_rec == 10)
{
$lv_first_rec = 1;
$lv_last_rec = 10;
}
else if($lv_start_rec >= 1 && $lv_end_rec <= 10)
{
$lv_first_rec = 1;
$lv_last_rec = 10;
}
else
{
$lv_first_rec = $lv_start_rec - 10;
$lv_last_rec = $lv_start_rec - 1;
}
}
if($_POST['lv_flag']=='3')
{
if($lv_start_rec == ($total-10) and $lv_end_rec == $total)
{
$lv_first_rec = $total-10;
$lv_last_rec = $total;
}
else if($lv_end_rec >= $total)
{
$lv_first_rec = $lv_start_rec;
$lv_last_rec = $lv_end_rec;
}
else
{
$lv_first_rec = $lv_start_rec + 10;
$lv_last_rec = $lv_end_rec + 10;
}
}
if($_POST['lv_flag']=='4')
{
if ($total <= 10)
$lv_first_rec = 1;
else if (($total%10) == 0)
$lv_first_rec = $total - 10+1;
else
$lv_first_rec = $total - ($total%10) +1;
$lv_last_rec = $total;
}
}
else
{
$lv_first_rec = 1;
$lv_last_rec = 10;
}
$_SESSION['lv_start_rec'] = $lv_first_rec;
$_SESSION['lv_end_rec'] = $lv_last_rec;
?>
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / rajkumar (rk)
Pagination is a big program... we can make using limit function
| Is This Answer Correct ? | 1 Yes | 6 No |
What is difference between get and post?
What is the use of isset() in php?
How to check a variable is array or not in php?
What are the different types of statements that are present in php?
What is the importance of "action" attribute in a html form?
Echo is used to Display message on screen. Which is used with echo to not output the trailing newline?
Explain different types of errors in PHP (i.e. arguments in errorreporting function)?
8 Answers Base2 Infotech, DCI, Microsoft, Tata Elxsi,
Which is the best php framework for a beginner?
How many ways you can delete a session variable ?
How to create a directory?
What is difference between mysql_connect and mysqli_connect?
How to create an array in php?