Transition of resources(database connection) across pages

[dvd420]

Hi Friends,

 

I am developing a web app in PHP/Apache/Win. My prob is, after the database(oracle) transaction is complete, there is either a COMMIT or ROLLBACK as the script ends, depending upon the MODE. Now I don't want this. I am using a persistent connection and I want to prevent this behaviour at the script terminnation.

 

Looking fwd for help.

[RussellReal]

hello, I don't quite understand what you mean..

 

but, as you may know

 

as php exits, it destroys any resources and variables that has been created

 

so once php exits, you can't share the previous resource with another page.. you just need to re-connect to the database on the next page..

 

unless you mean share the resource with other pages rthat you are including..

 

which you shouldn't have a problem with..

[dvd420]

Hi Russel,

Thanks a lot for the response.

 

I just need to pass the resource variable to the next page. I tried using sessions etc..but no luck.

Is there any method, so that I can store it for future use. Or Is there any option by which I can

prevent PHP by destroying that resource.

[revraz]

Have you tried declaring your connection variable as global?

 

Not really sure if it will work or not, I don't use Oracle with PHP.