The simplest "way to do the connection thing" is, as is often the case in php,
to do nothing i.e. forget it.
If you don't specify a connect id MySQL happily uses the last one opened, so
the only thing you need do with the return from mysql_connect is check it for
errors i.e.
if (!mysql_connect("localhost","root"))
{
// panic
There's certainly no point in putting it in a session variable, the connection
is closed for you
as your script terminates.
The only time you might want to actually do something is if you were doing a LOT
of
switching between different database servers during one page request. Switching
between databases doesn't matter, but different servers = different connects.
George
connection if you don't specify one, so the
only thing I've ever done wih
David Johansen wrote:
> I was just wondering what the "right way" to do the MySQL connection thing
> is. Am I supposed to do it everytime through in the php code, should I make
> it a session variable, or is a global variable the way to go? Right now this
> is the code that I have
>
> if (empty($_SESSION['db']))
> {
> $_SESSION['db'] = mysql_connect("localhost", "root");
>
> mysql_select_db("clients",$_SESSION['db']);
> }
>
> Is that a "good" way to do it or is there a "better" way or anything like
> that. Thanks,
> Dave
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
