Skip to content

Instantly share code, notes, and snippets.

@ruckus
Created August 10, 2010 21:02
Show Gist options
  • Save ruckus/517998 to your computer and use it in GitHub Desktop.
Save ruckus/517998 to your computer and use it in GitHub Desktop.
function initDB(){
/* Get Sectors from session */
if(! isset($_SESSION['databaseURL'])){
include("conf/conf.php");
$dbConf = new DBConf();
$databaseURL = $dbConf->get_databaseURL();
$databaseUName = $dbConf->get_databaseUName();
$databasePWord = $dbConf->get_databasePWord();
$databaseName = $dbConf->get_databaseName();
//Set DB Info. in-session
$_SESSION['databaseURL']=$databaseURL;
$_SESSION['databaseUName']=$databaseUName;
$_SESSION['databasePWord']=$databasePWord;
$_SESSION['databaseName']=$databaseName;
$connection = mysql_connect($databaseURL,$databaseUName,$databasePWord);
// or die ("Error while connecting to localhost");
$db = mysql_select_db($databaseName,$connection);
//or die ("Error while connecting to database");
mysql_close($connection);
}
$databaseURL = $_SESSION['databaseURL'];
$databaseUName = $_SESSION['databaseUName'];
$databasePWord = $_SESSION['databasePWord'];
$databaseName = $_SESSION['databaseName'];
$connection = mysql_connect($databaseURL,$databaseUName,$databasePWord);
//or die ("Error while connecting to host");
$db = mysql_select_db($databaseName,$connection);
//or die ("Error while connecting to database");
return $connection;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment