Re: Php and codeigniter

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

Hey Mike
First let me say I'm relatively new to PHP and totally new to CI.  
So I have CI loaded and working and connecting to DB2 on the I.  I found
a wiki that someone had created a DB2 driver for CI.  So I tried to add
pagination to my script.  It uses _limit in the db2c_driver which goes
something like this. 
function _limit($sql, $limit, $offset = 0)
	{
		if ($offset == 0)
		{
			$offset = '';
		}
		else
		{
			$offset .= ", ";
		}

		return $sql."RETURN FIRST  " . $limit . " ROWS ONLY";

Of course db2 doesn't support this.  I quckly changed the return to
FETCH and I can get results, but I think that is all I can ever get with
this statement.  
So I looked at the mysql driver which uses a limit and offset.  Again
db2 doesn't support this
So I tried changing myself to this
$sql = "SELECT * FROM (select row_number() over (order by LAST_NAME) as
RN, ID, LAST_NAME,
FIRST_NAME,DEPARTMENT,EXTENSION,PAGER,CELLPHONE#,USERIMAGE
        from ". $this->ar_from[0].") x where RN between " . $offset . "
and " . $limit; 

The problem is that I can't figure out where I would need to change
these values $offset, &limit, so that on subsequent pages the values
would increase and I would get the next set of records.  

I hope this makes sense.



-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Mike Eovino
Sent: Wednesday, September 10, 2008 12:18 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Php and codeigniter


Mike,

I have used CodeIgniter (and love it), but not on the I.  What problem
are you having with pagination?  I don't monitor this mailbox very
frequently, so please forgive me if I don't respond quickly.

Mike E.

On Mon, Sep 8, 2008 at 2:25 PM, Smith, Mike
<Mike_Smith@xxxxxxxxxxxxxxxx> wrote:
> I have been playing with PHP and Codeigniter.   I am having problems
> with pagination and was wondering if anybody has used Codeignter on 
> the I?
> --
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To 
> post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, 
> or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at 
> http://archive.midrange.com/web400.