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 |
Explain some of the php string functions?
What are the different opening and closing tags available in PHP?
What is indexing how many types?
3 Answers DLF, Infosys, Net Solution, Vcare,
What is php's mysqli extension?
What is traits? How it is used in php?
How can we know that a session is started or not?
How to delete a file from the system?
How do I run php?
What library is used for pdf in php?
How do you compare strings in java?
What is the function mysql_pconnect() usefull for?
How many ways are there for passing variables between pages in PHP and what are they ?