[SOLVED] SQL LOGIN INFORMATION

[DarkSuperHero]

Would it be best to define any MySQL information in a CONSTANT or a variable ? Does it make much of a difference ?

<?php
define('HOST','localhost');
define('USER','root');
define('PASSWORD','');
define('DATABASE','test');

//OR.....

$host = 'localhost';
$user = 'root';
$password = '';
database = 'test';

 

by the way this is running on a local environment at the moment, but will be running on a production server in the future....

 

[cytech]

I would be curious to see if there is any security difference.

[hobeau]

The fastest most efficient way to do this is to do this as a class constant:

 

<?php
class db
{
    Const db_host = "localhost";
    Const db_username = "username";
    Const db_password = "password";
}
?>

 

PHP handles class constants much better than global constants. To use this simply include the file and say:

 

<?php
mysql_connect(db::db_host, db::db_username, db::db_password) or die(mysql_error());
?>

[gevans]

Unless your worried about overwriting data using a standard variable is fine, Apart from that neither will perform any differently.

 

I use an array to hold all my config data like this

 

$CONFIG =  array(
host => 'localhost'
user => 'root'
pass => ''
database => 'test'
);

 

It's just down to preference

[DarkSuperHero]

oh ok...sweet...ill probably end up using a class constant... :-) i also just finished reading first 3 tutorials on OO PHP here on php freaks and its been enlightening! :-)

 

thanx for the input! :-)