Connecting to a database

sbukoski

Assume I have the following variable assignments:

$dbhost = "localhost";
$dbuser = "me";
$dbpasswd = "MY$SELF^";

Will the following code work?

$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd")

I ask because of the $ in the value for $dbpasswd. I'm not sure if PHP gets confused and thinks that part of the variable is, itself, a variable. I'm trying to get my version of phpBB working, and at this point, I receive the error that it was unable to connect to the database. Any help is appreciated.

lurius

I'm not sure if that's legal password but anyway:

Use single quoted string:
$dbpasswd = 'MY$SELF^';

-Lurius

lunar

$dbhost = "localhost";
$dbuser = "me";
$dbpasswd = "MY$SELF^";

This way it will not work, as PHP will parse $SELF.
If $SELF has not been set, mysql will use MY^ as password.

So you have to use single quotes:

$dbpasswd = 'MY$SELF^';

Just try echo $dbpasswd; and you will see what PHP will send to mysql.

BTW: You dont need to quote the strings, you can just use
$db = @mysql_connect($dbhost, $dbuser, $dbpasswd)

sbukoski

The single quotes did the trick for me. Of course, now there are other issues, but I know what those are and am working with my help desk. Thanks...