Oracle session cursor
| From: | Doug Schasteen | Date: | Mon, 16 Apr 2001 04:32:49 +0000 |
| Subject: | Oracle session cursor | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8588@lists.php.net to get a copy of this message | ||
As you all know, PHP is stateless. Meaning that once the script ends, all connections are closed and
the program is done.
I have a project where I need to do just 1 query to oracle, but only get one row per page. So on the
first page it does the query and says "20 results total" and shows the first selected row.
Then I click next and it brings up the second row. I'm only supposed to show one row at a time.
I can probably cheat and parse the query on each page, but I'd like to find out from you nice
folks if its possible to do it with just one query. My guess is that I would be using a persistant
OCI connection and an oracle package/procedure, but I'm not familiar with either of those
enough to know if its possible or not. Or maybe I could store my parsed query in a PHP4 session?
Thats another thing I am not very familiar with at this time.
Any info would be helpful. This project is due on wednesday so I need the help ASAP.
Thanks.
- Doug Schasteen