Re^2: how to test a connection with mysql db

But what about: how do I know if my connection is still OK ?
Is there a command to test the connection ? or what is the best way to test this ?

Thanks
Luca

Comment on Re^2: how to test a connection with mysql db

Replies are listed 'Best First'.
Re^3: how to test a connection with mysql db by wazoox (Prior) on Jul 22, 2005 at 07:17 UTC
You shouldn't have to worry that much about the connection; simply test the return value of each DBI statement, if it fails, then it MAY be because the connection's lost. `$dbh->something() or .... # put your error management code here`	[reply] [d/l]
Re^4: how to test a connection with mysql db by Anonymous Monk on Jul 22, 2005 at 07:42 UTC
What if the sql statement is wrong, than it also fails! Is there a difference between both ? Luca	[reply]
Re^5: how to test a connection with mysql db by wazoox (Prior) on Jul 22, 2005 at 09:34 UTC
The error message is different, yes. But it will also vary from a sgbd to another, or from a version to another. You can't really help there.	[reply]
Re^6: how to test a connection with mysql db by jeanluca (Deacon) on Jul 25, 2005 at 12:29 UTC
Re^7: how to test a connection with mysql db by wazoox (Prior) on Jul 25, 2005 at 13:09 UTC