Hi.. i'm new at this mailing list and you can say that i'm a newbie in
Php programming :)
i dont know how to pass a connection to a database between pages. I want
to show the results in multiple pages with a unique connection.
can anyone help me?
Thanks in advance.
Lucas
--
Lucas Lain
[EMAIL
This is how i handle this concept:
1. Determine the number of rows from the query.
2. Set up limits on how many rows to display per page.
3. Then do multiple queries with those limits.
Postgresql allows for queries with limits.
That should get you started...
Ray
On Wed, 2003-02-12 at 09:58,
Try this function... it's one part of a php class I've been thinking about
making open-source. Give it any sql statement and a page (0 based for the
page) and a number of records for a page and you are set.
I've only tested this on postgresql.
function pageSql( $sql, $page, $recs_per_page )
i will use it for the moment but i was thinking in a light solution
... i dont like the idea of creating a temp table for each page...
Joshua Moore-Oliva wrote:
Try this function... it's one part of a php class I've been thinking about
making open-source. Give it any sql statement and a page
There's really no other way to do it...
You can't serialize a connection or resultset since they are both resources...
If you really wanted you could turn a recordset into an array and store that
as a serialised object and pass it around... but
a) Depending on how much data a recordset
Oh btw, you will have to remove those isString and isint functions.. they are
other parts of my library that just check the type of a variable...
and log a message through an error handling system I've set up.. I'd have the
library up now but it's not that well commented..
Josh.
On February
6 matches
Mail list logo
