im using this php reader to retrieving data from xls sheet and its
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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
