Menu
Community /Pin to ProfileBookmark
@NogDogApr 17.2008 — #If your intent is to use PHP's built in super-global array $GLOBALS, note that its name has no underscore and is plural. If, on the other hand $_GLOBAL is not intended to be that array, then I would just pass it as a function parameter, in order to avoid the "evils" of globalization. ?
@NogDogApr 21.2008 — #You could put the connection values in a separate .ini file, putting that file in a directory outside of the web document root. E.g.: if your web document root is "/home/users/icrane/public_html", then save it as "/home/users/icrane/includes/db.ini". Then you could pass its path to your DB class's constructor, and parse it there:
ini file:
Usage:
db won’t connect with globals in class
I have a class that connects to the db. I’m using global variables to pass the server, login, password, and database. This works in a function but not in a method. I can print_r and see the properties but still errors out when I try it in the class. Here an example of what works and not.
Doesn’t work:
public function connection(){
require_once(‘includes/DBconn.php’);
$this->_connection = mssql_connect($_GLOBAL[‘login’],$
if(!mssql_select_db($_GLOBAL[‘database’],$this->
die(“Could not select DB”);
}
}
works:
public function connection(){
$this->_connection = mssql_connect(‘server’,’login’,’password’);
if(!mssql_select_db(‘database’,$this->
die(“Could not select DB”);
}
}
I know it’s likely something stupid I’m doing. Let me know.
Thanks.
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogApr 17.2008 — #If your intent is to use PHP's built in super-global array $GLOBALS, note that its name has no underscore and is plural. If, on the other hand $_GLOBAL is not intended to be that array, then I would just pass it as a function parameter, in order to avoid the "evils" of globalization. ?[code=php]
function connect($_GLOBAL) {
// etc....
}
[/code]0
@NogDogApr 21.2008 — #You could put the connection values in a separate .ini file, putting that file in a directory outside of the web document root. E.g.: if your web document root is "/home/users/icrane/public_html", then save it as "/home/users/icrane/includes/db.ini". Then you could pass its path to your DB class's constructor, and parse it there:[code=php]
class DB
{
private $dbHost;
private $dbUser;
private $dbPwd;
private $dbName;
private $connx;
public function __construct($iniFilePath)
{
$iniArray = parse_ini_file($iniFilePath);
if(empty($iniArray))
{
throw new Exception("No data from ini file");
}
foreach(array('dbHost', 'dbUser', 'dbPwd', 'dbName') as $key)
{
if(!empty($iniArray[$key]))
{
$this->$key = $iniArray[$key];
}
else
{
throw new Exception("Missing key '$key' in ini file");
}
}
}
public function connect();
{
$this->connx = mysql_connect($this->dbHost, $this->dbUser, $this->dbPwd);
if($this->connx !== false)
{
if(mysql_select_db($this->dbName) === false)
{
user_error(mysql_error());
return false;
}
return true;
}
user_error(mysql_error());
return false;
}
}
[/code]ini file:
<i>
</i>dbHost="localhost"
dbUser="foobar"
dbPwd="raboof"
dbName="my_database"
Usage:
[code=php]
try {
$db = new DB('/home/users/icrane/includes/db.ini');
}
catch (Exception $e) {
die("Uh-Oh!");
}
if($db->connect() === false)
die("DB connection failed");
[/code]