$dbc $gDbManager - HTML Forums

wolfdogg · 09-18-2006, 08:43 PM

$dbc $gDbManager,
are these 2 teh same function? are these common variables used for connections? or do they server 2 different purposes. currently, they are confusing me. ill include some code to see if you can help me figure out what variable i should be using.

heres my db connec in my config.php file

Code:

// database login info
define("USE_PERSISTENT_CONNECTIONS", "true");
define("DB_HOST", "localhost");
define("DB_USER", "user");
define("DB_PASSWORD", "password");
define("DB_NAME", "database_name");
define("MYSQL_CONNECTION_STRING", "mysqli://" . DB_USER . ":" .
	DB_PASSWORD . "@" . DB_HOST . "/" . DB_NAME);	//$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

will this allow me to use $dbc to connect as in

Code:

// Execute the query:
		$r = mysqli_query ($dbc, $q);

or does this line thats in cluded in the header change all that

Code:

// global DbManager instance                                 
$gDbManager = new DbManager(MYSQL_CONNECTION_STRING);   
                                                                                                                 
?>

prompting me to use DbManager instead such as

Code:

mysqli_close($gDbManager);

?

i cant figure out why both are used. they must be 2 different functionsssss.....?????

erisco · 09-18-2006, 09:03 PM

$dbc is equal to this:

Code:

mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

But you need to uncomment the line.

DbManager is not a variable, it is a class (I think) that was defined also in your config file. The define() function just defines a constant, which is the exact same as a variable, except you cannot change the value, ever.

wolfdogg · 09-18-2006, 09:21 PM

not sure what line you mean to uncomment?

ahhhhhhh, ok, i see it. i think i commented that line a while back because i was having mysqli problems. thanks for noticing that.....

so,
what connection string should i use then? if i use $dbc, without creating any more variables, will it call my connection properly then? or do i have to use something else....

let me show you the exzact line that is in question. Will this following $dbc connection work ok on my existing setup assuming i uncomment that line?

Code:

// Display the expense categories:
	$r = mysqli_query ($dbc, 'SELECT * FROM vehicle_category ORDER BY vehicle_category');
	while ($row = mysqli_fetch_array ($r, MYSQLI_NUM)) {
		echo "<option value=\"$row[0]\">$row[1]</option>\n";

scoutt · 09-19-2006, 04:47 PM

ok lets follow this through.

PHP Code:


			
// database login info
define("USE_PERSISTENT_CONNECTIONS", "true");
define("DB_HOST", "localhost");
define("DB_USER", "user");
define("DB_PASSWORD", "password");
define("DB_NAME", "database_name");
define("MYSQL_CONNECTION_STRING", "mysqli://" . DB_USER . ":" .
    DB_PASSWORD . "@" . DB_HOST . "/" . DB_NAME);    
//$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

the reason you see two ways to connect is that on some server where php5 is installed it uses mysqli while older version of php there is mysql. now, if all depends on which one you have. it will not use both.

erisco · 09-19-2006, 05:22 PM

I'm attentive scoutt, I really don't know what is going on with this code either.

wolfdogg · 09-20-2006, 02:39 PM

blame it on Darie, go to www.christiandarie.ro and you meet the author. hehe. i think i added that 2nd connection string however, and commented it out, because i wanted it there for comparison and learning. all the code is here http://www.apress.com/ApressCorporat...93928-2358.zip