Re: php vs net.data

I wonder if this would work:
http://framework.zend.com/manual/en/zend.paginator.html

39.1. Introduction

Zend_Paginator is a flexible component for paginating collections of data and presenting that data to users.

The primary design goals of Zend_Paginator are as follows:

* Paginate arbitrary data, not just relational databases
* Fetch only the results that need to be displayed
* Do not force users to adhere to only one way of displaying data or rendering pagination controls
* Loosely couple Zend_Paginator to other Zend Framework components so that users who wish to use it independently of Zend_View, Zend_Db, etc. can do so








Scott Klement said the following on 12/3/2009 5:06 PM:

Kelly,

That will always return the first 50 rows. Which is fine if that's all you want. But folks often want to use this to load one page of records to be displayed, then after someone clicks the "next page" button, they want to display the next page of records. (yours would result in the same page being displayed every time)

Here are some previous discussions you might find interesting:

http://archive.midrange.com/web400/200810/msg00138.html
http://forums.systeminetwork.com/isnetforums/showthread.php?t=49938
http://forums.systeminetwork.com/isnetforums/showthread.php?t=52770





Kelly Cookson wrote:

Ahh...so here's what we can do with db2:

"SELECT * FROM MYLIB/MYFILE OPTIMIZE FOR 50 ROWS
FETCH FIRST 50 ROWS ONLY"

Or however many rows we want.

Kelly



-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Kelly Cookson
Sent: Thursday, December 03, 2009 2:57 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] php vs net.data

Here's a simple db2_ example. Suppose you wanted to read a file called
MYLIB/MEMBERS. The file has three fields: FNAME, LNAME, and PHONE.

//Connect to the database $conn = db2_connect("", "", "")
or die(db2_conn_errormsg());
//Prepare the SQL Query for execution
$query = "SELECT * FROM MYLIB.MEMBERS";
$statement = db2_prepare($conn, $query) or die(db2_stmt_errormsg());

//Execute the query
db2_execute($statement)
or die(db2_stmt_errormsg());

//Retrieve the results
while ($row = db2_fetch_assoc($statement)) {
$first_name = $row["FNAME"];
$last_name = $row["LNAME"];
$phone_number = $row["PHONE"];

//process or display the data

}

//Close the connection
db2_close($conn);

Hope that helps a little.
Kelly



-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Larry Kleinman
Sent: Thursday, December 03, 2009 2:38 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] php vs net.data

OK, I'll check it out, thanks


Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100



"Kelly Cookson" <KCookson@xxxxxxxxxxxx> Sent by: web400-bounces@xxxxxxxxxxxx
12/03/2009 03:28 PM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>


To
"Web Enabling the AS400 / iSeries" <web400@xxxxxxxxxxxx>
cc

Subject
Re: [WEB400] php vs net.data






I don't know. But you don't need to use the i5_ database functions. You
can use the db2_ functions. Check out the db2_ database functions at:
http://www.php.net/manual/en/ref.ibm-db2.php

I'm assuming that pagination with LIMIT would work with the db2_
database functions. I haven't tried it, though.

I prefer using the db2_ functions because you get more functionality
than provided in the PHP Toolkit. I especially like using
db2_fetch_assoc because you get an associative array where the key is
the name of the field in the DB2 file. It makes code that processes
results much easier to read. I grew up on COBOL and like
self-documenting code.

I do use i5_ functions for other stuff. I don't want to imply something
is wrong with the PHP Toolkit.

Kelly

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Larry Kleinman
Sent: Thursday, December 03, 2009 2:05 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] php vs net.data

Pretty cool, Kelly. The only question is will it work with ZendCore
using i5_query instead of mysql_query?

Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100



"Kelly Cookson" <KCookson@xxxxxxxxxxxx> Sent by: web400-bounces@xxxxxxxxxxxx
12/03/2009 02:50 PM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>


To
"Web Enabling the AS400 / iSeries" <web400@xxxxxxxxxxxx>
cc

Subject
Re: [WEB400] php vs net.data






Here's a page that may be along the lines of what you seek:
http://www.phpsimplicity.com/tips.php?id=1

Kelly

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Larry Kleinman
Sent: Thursday, December 03, 2009 1:03 PM
To: Web Enabling the AS400 / iSeries
Subject: [WEB400] php vs net.data

Does anyone know if there is a PHP equivalent for the Net.Data report variables called RPT_MAX_ROWS (which limits the number of report rows returned by a SQL call) and START_ROW_NUM (which determines the starting

row of a SQL result set to show)

Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100