works well the xls sheet having 150 records. its limited to 20 records
per page to show on result page .there is a search box and button to
search some specific data , the search parameter giving the result
from first page result only. i can't get result from full excel sheet.
What is the expected output? What do you see instead?
i need the reader to search whole xls sheet and give me result, but
this one giving me from first 20 records only.
Please provide any additional information below.
i dont understan whats wrong here, y can't search full records on xls
sheet. im expecting some ones help to solve my problem. plz see the
attach file below for code
thnxx..
$searchparameter=$_GET['searchparameter'];
$startno=7;
$totalrow=$data->rowcount($sheet_index=0);
$rows=$i;
if ($_GET['page']!="")
$page=$_GET['page'];
else
$page=1;
echo 'TABLE
-------------------------------------
$count=0;
$recordno=1;
for($i=0;$i<$totalrow-6;$i++)
{
//echo "<br/> searchparameter = ". $searchparameter ." data2 ".
$data2 ;
if((($page-1)*$rows)<=$i && $i<($page*$rows))
{
//$data1=$data->val($startno+$i,1);
$data2=$data->val($startno+$i,2);
$data3=$data->val($startno+$i,3);
$data4=$data->val($startno+$i,6);
if((stristr($data2,$searchparameter) ||
stristr($data3,$searchparameter)|| stristr($data4,$searchparameter))||
$searchparameter=="")
{
echo 'TABLE
------------------------
}
$recordno=$recordno+1;
if($searchparameter=="")
$count=$totalrow;
$totalpage=$count/$rows;
$totalpage=ceil($totalpage);
for($i=1;$i<=$totalpage;$i++)
{
if ($i == $page)
echo $i;
--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php