Hi.
im doing a php page which is 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.
$searchparameter=$_GET['searchparameter'];
$totalrow=$data->rowcount($sheet_index=0);
$rows=20;
if ($_GET['page']!="")
$page=$_GET['page'];
else
$page=1;
echo 'table';
$count=0;
$recordno=1;
for($i=0;$i<$totalrow-6;$i++)
{
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';
}
i dont understan whats wrong here, y can't search full records on xls
sheet.
im expecting some ones help to solve my problem.
thnxx..
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
