Hi there.
on the reader php file , as u said earlier , its define as 0
" val($row,$col,$sheet=0) " , so do i need to make changes on it? or is that
okay to leave it like that?
and my scripts should work rite. but its giving result from first result
page only. unable to get data from balance pages.
("" $totalrow=$data->rowcount($sheet_index=1);
$rows=20;
if ($_GET['page']!="")
$page=$_GET['page'];
else
$page=1; "")
is there any wrong here to get data from all pages?
On Wed, Jul 27, 2011 at 11:15 AM, S.Mohammed Alsharaf
<[email protected]>wrote:
> Yes you are right. the script you have should work for one sheet.
>
> Sheet index starts with 0 not 1.
>
> Cheers
> Mohammed
>
> Blog: http://jamandcheese-on-phptoast.com/
> Email: [email protected]
> Mobile: 012 139 5924
>
>
> ------------------------------
> Date: Wed, 27 Jul 2011 10:22:10 +0800
> Subject: Re: [phpug] PHP with Excel Sheet
>
> From: [email protected]
> To: [email protected]
>
> Hi Mohammed,
>
> Thanks for ur msg, and i wanna say something here and i need ur advice .
>
> 1) i have 1 sheet only in my xls file, which is sheet 1. with 150 rows
> only.
> 2) i think the 2 points u indicate here, its wont be a problem here. am i
> right?
>
> im expecting ur advice on this.
>
> thnx..
>
> On Wed, Jul 27, 2011 at 6:51 AM, S.Mohammed Alsharaf <[email protected]
> > wrote:
>
> Hi
>
> If you search the reader php file, you will find a call to the val()
> function. There is a third parameter ' $sheet '. I think this is the sheet
> index. ' val($row,$col,$sheet=0) '
>
> In the script below:
> 1. $totalrow=$data->rowcount($sheet_index=0);
> you always returning the total number of rows in the first sheet
>
> 2. $data2=$data->val($startno+$i,2);
> return the value at,
> - row number $startno+$i
> - column number 2
> - no sheet index specified. The default number is 0, which is the first
> sheet.
>
>
> Cheers
> Mohammed
>
> Blog: http://jamandcheese-on-phptoast.com/
> Email: [email protected]
>
> > Date: Mon, 25 Jul 2011 22:38:27 -0700
> > Subject: [phpug] PHP with Excel Sheet
> > From: [email protected]
> > To: [email protected]
>
> >
> > 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]
>
> --
> NZ PHP Users Group: http://groups.google.com/group/nzphpug
> To post, send email to [email protected]
> To unsubscribe, send email to
> [email protected]
>
>
>
> --
> NZ PHP Users Group: http://groups.google.com/group/nzphpug
> To post, send email to [email protected]
> To unsubscribe, send email to
> [email protected]
>
> --
> NZ PHP Users Group: http://groups.google.com/group/nzphpug
> To post, send email to [email protected]
> To unsubscribe, send email to
> [email protected]
>
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
