Answer Posted / 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;

?>

How do you parse and process html/xml in php?

1030

---

Do you know what does mvc stand for and what does each component do?

962

---

What is the scope of a variable defined outside a function?

1048

---

Is it possible to use com component in php?

987

---

Can we use include ("xyz.php") two times in a php page "index.php"?

1025

---

Tell us why did you choose this particular career path?

950

---

What is include in php?

962

---

Explain me what is the importance of "method" attribute in a html form?

929

---

How to remove an empty directory?

1046

---

What is the use of mvc in php?

993

---

What is php good for?

928

---

How does api connect to database?

1077

---

What is an object in php?

1112

---

Explain what is the difference between mysql_fetch_array() and mysql_fetch_assoc()?

908

---

How to test if a variable is an array?

1126

---