Showing query time and closing connection id
- From: jayadiesel@xxxxxxxxx
- Date: Thu, 2 Oct 2008 01:21:13 -0700 (PDT)
i'm just acquainted to this php -mysql not so long. i have several
issues i came across while developing my own localhost site.
1) what command i should use to show query time, such as shown
automatically on prompt.
(Query took 0.3435 sec)
I have seen sql and php manual but none addressed this issue.
2) i connected to db with mysql_pconnect() however without storing the
return value. Later i tried to close several openned connection
numbers which were shown :
$p = mysql_list_processes();
while ($row = mysql_fetch_row($p)) {
list($id,...) = $row;
echo "link: $id<br/>";
}
there were several numbers shown from $id. Assuming 5,6, 10 were
listed, i thought i was able to close any numbers thereof and i picked
up value 5 and executed mysql_close(5); and later i checked with
mysql_list_processes. connection number 5 was still active. how should
i do to close this connection, does this relate to persistent
connection ?
.
- Prev by Date: need help on imagecreatefromjpeg
- Next by Date: Re: [PHP] store array into session variable and get it back later
- Previous by thread: need help on imagecreatefromjpeg
- Next by thread: php server push
- Index(es):
Relevant Pages
|
