Using variables in PHP

gericsb · 03-02-2007, 06:17 PM

I have defined the following constants in a file called global.php where I have used my actual database username, password etc.--I just replaced them here so nobody could see them:

<?php
// Database constants
DEFINE('DBUSER', 'mydatabaseusername');
DEFINE('DBPASS', 'mydatabasepassword');
DEFINE('DBHOST', 'localhost');
DEFINE('DB', 'nameofmydatabase');
?>

I then include the global.php file in my test page using the require_once command as seen below:

<?php
require_once('global.php');
$dbh=mysql_connect('DBHOST', 'DBUSER', 'DBPASS') or die ('I cannot connect to the database because: ' . mysql_error());
etc...........
?>

No matter how I include my constants in the connect command above, I cannot connect to my database. Now if I replace the DBHOST with "localhost" and the DBUSER with the actual name of my user etc.--all stuff I defined in the gloabl.php file--everything works fine. But--I must use the actual names in " " and not the constants like above.

I made sure my global.php page and my test page were in the same folder so its not a path issue...

So why aren't my DEFINE commands working?

Figured it out...

Couldn't have the single quotes around the DBHOST, DBUSER....etc.

Thanks anyway!

psalzmann · 03-02-2007, 07:58 PM

Quote:

Originally Posted by gericsb

<?php
require_once('global.php');
$dbh=mysql_connect('DBHOST', 'DBUSER', 'DBPASS') or die ('I cannot connect to the database because: ' . mysql_error());
etc...........
?>

Is your problem. You need to remove the single quotes if they are CONSTANTS.

Use this:

PHP Code:

  <?php

require_once('global.php');

$dbh=mysql_connect(DBHOST, DBUSER, DBPASS) or die ('I cannot connect to the database because: ' . mysql_error());

etc...........

?>

03-02-2007, 06:17 PM	#1 (permalink)
gericsb NamePros Regular Join Date: Jan 2006 Posts: 696 15.00 NP$ (Donate)	Using variables in PHP I have defined the following constants in a file called global.php where I have used my actual database username, password etc.--I just replaced them here so nobody could see them: <?php // Database constants DEFINE('DBUSER', 'mydatabaseusername'); DEFINE('DBPASS', 'mydatabasepassword'); DEFINE('DBHOST', 'localhost'); DEFINE('DB', 'nameofmydatabase'); ?> I then include the global.php file in my test page using the require_once command as seen below: <?php require_once('global.php'); $dbh=mysql_connect('DBHOST', 'DBUSER', 'DBPASS') or die ('I cannot connect to the database because: ' . mysql_error()); etc........... ?> No matter how I include my constants in the connect command above, I cannot connect to my database. Now if I replace the DBHOST with "localhost" and the DBUSER with the actual name of my user etc.--all stuff I defined in the gloabl.php file--everything works fine. But--I must use the actual names in " " and not the constants like above. I made sure my global.php page and my test page were in the same folder so its not a path issue... So why aren't my DEFINE commands working? Figured it out... Couldn't have the single quotes around the DBHOST, DBUSER....etc. Thanks anyway! __________________ Web Personals Online Affiliate Marketing Blog

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)