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 arrays are used in php?

1039

---

What are php variables?

959

---

What is the difference between query and question?

949

---

What is the use of mysql_real_escape_string() function?

911

---

Why should I store logs in a database rather than a file?

1015

---

Xplain is it possible to use com component in php?

913

---

How to check a variable is array or not in php?

980

---

What is php's mysqli extension?

993

---

Explain what is the difference between for and foreach?

1023

---

Do csrf tokens expire?

961

---

What is Apache's configuration file typically called?

1117

---

CWD is a type of shell variable. State Whether True or False?

1081

---

How to create a text file in PHP?

1110

---

When a conditional statement is ended with an endif?

925

---

Does https prevent csrf?

895

---