Re: [PHP] php temp table question (for mysql)

From: Marek Kilimajer (kilimajer_at_webglobe.sk)
Date: 10/31/03 

Date: Fri, 31 Oct 2003 20:46:19 +0100
To: Larry Brown <larry.brown@dimensionnetworks.com>

Session should not have any influence. Perhaps Keep-alive connection,
then by closing the browser the connection ends. If you would wait
enough the connection will be closed anyway.

But certainly this is valueable knowledge.

Larry Brown wrote:
> I'm now finding that persistent connections is allowing the temp table to
> remain. I have a sql query that creates the table and another that joins
> the temp table to another for a result set that I use. If I press refresh on
> the browser window I get an error that the sql query creating the table
> fails. I prepend a query that removes the table before the sql that creates
> it and then hit refresh and the query works. If I close the browser thus
> ending the session and reopen the browser and log in, the script fails to
> remove the temp table since it hasn't been created yet (and must have been
> removed). I changed my method of connecting to use mysql_connect instead of
> mysql_pconnect and removed the drop temp sql and it loads and reloads fine.
> Perhaps it is the combination of mysql_pconnect with sessions that creates
> this problem.
>
> -----Original Message-----
> From: CPT John W. Holmes [mailto:holmes072000@charter.net]
> Sent: Monday, October 27, 2003 4:43 PM
> To: Larry Brown; PHP List
> Subject: Re: [PHP] php temp table question (for mysql)
>
>
> From: "Larry Brown" <larry.brown@dimensionnetworks.com>
>
>>Does anyone know whether the use of persistent connections with php will
>>allow a temp table created by a script to linger around
>
>
> No, the table will still be removed at the end of the script whether you use
> persistant connections or not.
>
>
>>and cause a problem
>>with the next execution of the script when it tries to create the temp
>
> table
>
> Temporary tables are unique for that specific question. So you can have the
> same script creating the "same" temporary table and 100 people hit it
> without issues. Each script creates it's own temporary table with a unique
> name that only that connection has access to.
>
> ---John Holmes...
>

Relevant Pages

  • Re: How to unblock user waiting while PHP continue his work
    ... That will push all the output so far to the browser, ... The web browser still wait the end of the script to display "before" ... do at the end of script (close file, close connection, statistics ...) ...
    (comp.lang.php)
  • RE: [PHP] Closing a connection to browser without exiting the script
    ... Closing a connection to browser without exiting the ... I have a PHP page that displays a message, and then, performs a very ... what I would like is to be able to close the connection from ... the server-side, but without using the exitfunction, so my script ...
    (php.general)
  • Re: OT udp port 138 BROWSER traffic
    ... > policy is just to drop all ms browser traffic. ... >>router but that is all I know about it. ... send or receive any public network traffic from them. ... issues that are interfering with my connection at their end. ...
    (comp.os.linux.security)
  • Re: Problem in opening websites
    ... msg is "there was no XML in the response". ... the browser gets timed out (the msg is "The connection ... to the server was reset while the page was loading."). ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Cannot access some URLs
    ... > cause or symptom, I am unable to access certain websites. ... A telnet client is a useful tool for simulating and testing web browser ... you can use your HyperTerminal utility with its Winsock connection ... Since netstat reports cumulative statistics in order to get detailed ...
    (microsoft.public.windows.inetexplorer.ie6.browser)