When is it the best time to close a database connect? Is it good to close it on every scripting page i do that uses it?
programmer12 0 Junior Poster in Training
Recommended Answers
Jump to PostError is based on coding and logic.
You have to increase your memory limit.
ini_set(’memory_limit’, '20M');But if your script is in end level recursion, above solution wont work.
Make sure your recursive function has one limit and break somewhere.
Jump to PostWhen is it the best time to close a database connect? Is it good to close it on every scripting page i do that uses it?
I use a database singleton design pattern. That makes easy with single close throughout the session!
All 7 Replies
Insensus 52 Junior Poster
When a PHP script is done executing all non-persistent connections will be closed.
Non-persistent connections are made with the _connect database functions so as long as you stick to that, there's nothing to worry about.
programmer12 0 Junior Poster in Training
okay thanks!...
One more question what is a recursion? And how do i fix those? My website use to read "Out of memory on line 12"?
vibhaJ 126 Master Poster
Error is based on coding and logic.
You have to increase your memory limit.
ini_set(’memory_limit’, '20M');
But if your script is in end level recursion, above solution wont work.
Make sure your recursive function has one limit and break somewhere.
programmer12 0 Junior Poster in Training
okay, so the only thing I have to do is fix the PHP ini file to accept more memory?
Stefano Mtangoo 455 Senior Poster
When is it the best time to close a database connect? Is it good to close it on every scripting page i do that uses it?
I use a database singleton design pattern. That makes easy with single close throughout the session!
programmer12 0 Junior Poster in Training
okay thank you! I will read up on that. ^_^
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.