Esempio n. 1
0
 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;
     }
 }
Esempio n. 2
0
 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;
     }
 }
Esempio n. 3
0
 public function __construct()
 {
     if ($db = CModelConnectDB::getInstance()) {
         $this->setDbConn($db);
     }
 }
Esempio n. 4
0
 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);
 }
Esempio n. 5
0
 public function __construct()
 {
     $db = new CModelConnectDB(DSN, DB_USER_NAME, DB_USER_PASS);
     $this->setDbConn($db->getDBConnection());
 }