Persistent database

[devendraC]

Hi,
Could anyone tell me how to use persistent database connection in PHP, using Postgres database. Is any sample?

Please help
Regards
Devendra

[Weedpacket]

Exactly the same way you'd use an ordinary connection; the only difference is a few milliseconds or so saved in connecting and user validation in each script. See [man]pg_pconnect[/man], of course, for more information.

[devendraC]

Thanks

What I want:
1) Open database connection.
2) Fatch some rows.
3) If user clicks next button, Fetch next set of rows from previously opended record set(persisted)

Is it possible in PHP-PostgreSQL ?

Regards
Devendra

[Weedpacket]

In a persistent connection it is the connection that is persistent, not query results.

You're wanting a form of pagination. There are a couple of threads cited in the Coding Forum FAQ that go into this subject in great detail, and a couple of articles on this site. Your requirements would be quite a lot simpler than those threads, because what you're describing involes only one record per page; in the FAQ-linked threads, I suggest you look at the second one first.

Hint: you'll be learning how to use LIMIT in your SQL queries.