public static function getInstance() { if (self::$instance == null) { self::$instance = new CModelConnectDB(DSN, DB_USER_NAME, DB_USER_PASS); return self::$instance->getDBConnection(); } else { /** * Using the one connection to Database for all * * if it need, it may return false to deny for all other except one */ return false; } }
public static function getInstance() { if (self::$instance == null) { $dsn = CApp::settings('APPLICATION')->db['dsn']; $user = CApp::settings('APPLICATION')->db['db_user']; $pass = CApp::settings('APPLICATION')->db['db_pass']; self::$instance = new CModelConnectDB($dsn, $user, $pass); return self::$instance->getDBConnection(); } else { /** * Using the one connection to Database for all * * if it need, it may return false to deny for all other except one */ return false; } }
public function __construct() { if ($db = CModelConnectDB::getInstance()) { $this->setDbConn($db); } }
public function createTable($tableName, $tableInfoArray) { $db = CModelConnectDB::getInstance(); $strQuery = "CREATE TABLE `" . $tableName . "` ("; foreach ($tableInfoArray as $nameRecord => $fieldsArray) { $strQuery .= $nameRecord . " "; foreach ($fieldsArray as $key => $value) { switch ($key) { case "type": $strQuery .= " " . $value; break; case "default": $strQuery .= " DEFAULT " . $value; break; case "constraint": $strQuery .= " CONSTRAINT " . $value; break; case "index": $strQuery .= " INDEX " . $value; break; case "length": $strQuery .= "(" . $value . ")"; break; case "auto_increment": $strQuery .= $value ? " auto_increment" : ""; break; case "not_null": $strQuery .= $value ? " not null" : ""; break; case "unique": $strQuery .= $value ? " unique" : ""; break; case "key": $strQuery .= " " . $value . " key"; break; default: break; } } $strQuery .= ", "; } $strQuery = substr($strQuery, 0, -2); $strQuery .= ")"; $db->exec($strQuery); }
public function __construct() { $db = new CModelConnectDB(DSN, DB_USER_NAME, DB_USER_PASS); $this->setDbConn($db->getDBConnection()); }