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); }