bobo123
Programmer
- Oct 4, 2002
- 30
Please, how can I detect, that I've been connected to MySQL before using mysql_connect() ?? Only through SQL question or $PHPSESSID or some function in PHP or some trick ??
Thanks Bobo
Thanks Bobo
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Connection to MySQL
- Thread starter bobo123
- Start date
- Status
Hi Bobo123,
This is the only way I know to see if your php scripts connect to MySQL. It does connect using mysql_connect();
is there any reason why you don't want to use this?
Replace username and password with your MySQL username and password.
Hope this helps!
<html>
<head>
<title>
Connect To A MySQL Server
</title>
</head>
<body>
<?php
$linkID = mysql_connect("localhost","user","password"
;
if ($linkID != FALSE)
{
print "Congratulations!!!<br>The connection to the server was made successfully.";
}
else
{
print "The connection to the server failed.";
}
mysql_close($linkID);
?>
This is the only way I know to see if your php scripts connect to MySQL. It does connect using mysql_connect();
is there any reason why you don't want to use this?
Replace username and password with your MySQL username and password.
Hope this helps!
<html>
<head>
<title>
Connect To A MySQL Server
</title>
</head>
<body>
<?php
$linkID = mysql_connect("localhost","user","password"
;if ($linkID != FALSE)
{
print "Congratulations!!!<br>The connection to the server was made successfully.";
}
else
{
print "The connection to the server failed.";
}
mysql_close($linkID);
?>
- Thread starter
- #3
Sorry.
Try using SHOW STATUS (This is straight SQL)
There's a comprehensive list of SHOW STATUS variables at:
and incorporate what you need into your script.
Try using SHOW STATUS (This is straight SQL)
There's a comprehensive list of SHOW STATUS variables at:
and incorporate what you need into your script.
- Thread starter
- #5
sleipnir214
Programmer
There is no PHP function that does what you're looking for. For one thing, it is possible for an existing connection to be closed by MySQL for inactivity.
It's not a problem anyway -- the online manual page on mysql_connect() explicitly states: If a second call is made to mysql_connect() with the same arguments, no new link will be established, but instead, the link identifier of the already opened link will be returned. (
Want the best answers? Ask the best questions: TANSTAAFL!
It's not a problem anyway -- the online manual page on mysql_connect() explicitly states: If a second call is made to mysql_connect() with the same arguments, no new link will be established, but instead, the link identifier of the already opened link will be returned. (
Want the best answers? Ask the best questions: TANSTAAFL!
bobo123,
PHP 4.3.0 introduced a new function that probably does what you want:
mysql_ping(), read
But you've got to have 4.3.0 or later.
PHP 4.3.0 introduced a new function that probably does what you want:
mysql_ping(), read
But you've got to have 4.3.0 or later.
- Thread starter
- #8
- Status
Similar threads