Sunday, July 31, 2011

Search Function in PHP Excel Reader - Error

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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: