FUDforum: comp.lang.php

Home » Imported messages » comp.lang.php » I need Help

Show: Today's Messages :: Polls :: Message Navigator

Re: I need Help [message #169721 is a reply to message #169717]

Thu, 23 September 2010 20:37

Beauregard T. Shagnas
Messages: 154
Registered: September 2010

Karma:

Senior Member

Michael Fesser wrote:

> .oO(Beauregard T. Shagnasty)
>> Jerry Stuckle wrote:
>>> Never a good idea to allow PHP to close the connection. Close it
>>> yourself when you're done!
>>
>> Rule 13:
>> open the db connection
>> do your query, your select, update, insert, whatever
>> close the db connection
>> proceed with other coding
>
> I open the connection when my scripts initialize themselves and close
> it when everything's done. I don't know beforehand which parts of my
> code might need DB access for answering the current request and I
> don't want to open/close the connection over and over again. So it
> stays open until the end. In fact in a normal PHP script it doesn't
> make much of a difference if you close the connection one or two
> milliseconds earlier.

Sure, if you have multiple db accesses, don't close it until the last
one is executed. That would be a given, of course. "Rule 13" was just a
basic guideline, stating the programmer should close the connection and
not allowing some timeout to handle it. ;-)

--
-bts
-Four wheels carry the body; two wheels move the soul

Report message to a moderator

[Message index]

		I need Help By: Patrick Ehrmann on Wed, 22 September 2010 20:23
		Re: I need Help By: me on Wed, 22 September 2010 20:38
		Re: I need Help By: Robert Hairgrove on Wed, 22 September 2010 20:46
		Re: I need Help By: Jerry Stuckle on Thu, 23 September 2010 03:24
		Re: I need Help By: Beauregard T. Shagnas on Thu, 23 September 2010 04:17
		Re: I need Help By: Michael Fesser on Thu, 23 September 2010 19:44
		Re: I need Help By: Beauregard T. Shagnas on Thu, 23 September 2010 20:37
		Re: I need Help By: Robert Hairgrove on Thu, 23 September 2010 07:47
		Re: I need Help By: Robert Hairgrove on Thu, 23 September 2010 07:56
		Re: I need Help By: Jerry Stuckle on Thu, 23 September 2010 13:20
		Re: I need Help By: Robert Hairgrove on Thu, 23 September 2010 17:01
		Re: I need Help By: Jerry Stuckle on Thu, 23 September 2010 19:19
		Re: I need Help By: Robert Hairgrove on Thu, 23 September 2010 20:19
		Re: I need Help By: Jerry Stuckle on Thu, 23 September 2010 21:59

Previous Topic:	Book problems and solution for windows 7
Next Topic:	Syntax for array?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 12:29:47 GMT 2024

Total time taken to generate the page: 0.04721 seconds