59 	 *  - password: The password to log on with
60 	 *  - database: The database to connect to
61 	 *  - timezone: (optional) The timezone offset. For example: +12:00, "Pacific/Auckland", or "SYSTEM"
62 	 */
63 	public function __construct($parameters) {
64 		if(!empty($parameters['port'])) {
65 			$this->dbConn = new MySQLi($parameters['server'], $parameters['username'], $parameters['password'],
66 				'', $parameters['port']);
67 		} else {
68 			$this->dbConn = new MySQLi($parameters['server'], $parameters['username'], $parameters['password']);
69 		}
70 
71 		if($this->dbConn->connect_error) {
72 			$this->databaseError("Couldn't connect to MySQL database | " . $this->dbConn->connect_error);
73 		}
74 		

589 	}
590 
591 	public function databaseError($msg, $errorLevel = E_USER_ERROR) {
592 		// try to extract and format query
593 		if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
594 			$formatter = new SQLFormatter();
595 			$msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
596 		}
597 
598 		user_error($msg, $errorLevel);
599 	}
600 
601 	/**
602 	 * Return a boolean type-formatted string
603 	 *
604 	 * @param array $values Contains a tokenised list of info about this data type

133 
134 			Debug::message("Will execute: $sql");
135 			return;
136 		}
137 
138 		if(isset($_REQUEST['showqueries']) && Director::isDev(true)) {
139 			$starttime = microtime(true);
140 		}
141 
142 		$handle = $this->dbConn->query($sql);
143 
144 		if(isset($_REQUEST['showqueries']) && Director::isDev(true)) {
145 			$endtime = round(microtime(true) - $starttime,4);
146 			Debug::message("\n$sql\n{$endtime}ms\n", false);
147 		}
148 

141 
142 		$handle = $this->dbConn->query($sql);
143 
144 		if(isset($_REQUEST['showqueries']) && Director::isDev(true)) {
145 			$endtime = round(microtime(true) - $starttime,4);
146 			Debug::message("\n$sql\n{$endtime}ms\n", false);
147 		}
148 
149 		if(!$handle && $errorLevel) {
150 			$this->databaseError("Couldn't run query: $sql | " . $this->dbConn->error, $errorLevel);
151 		}
152 		return new MySQLQuery($this, $handle);
153 	}
154 
155 	public function getGeneratedID($table) {
156 		return $this->dbConn->insert_id;

589 	}
590 
591 	public function databaseError($msg, $errorLevel = E_USER_ERROR) {
592 		// try to extract and format query
593 		if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
594 			$formatter = new SQLFormatter();
595 			$msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
596 		}
597 
598 		user_error($msg, $errorLevel);
599 	}
600 
601 	/**
602 	 * Return a boolean type-formatted string
603 	 *
604 	 * @param array $values Contains a tokenised list of info about this data type

69 		}
70 
71 		if($this->dbConn->connect_error) {
72 			$this->databaseError("Couldn't connect to MySQL database | " . $this->dbConn->connect_error);
73 		}
74 		
75 		$this->query("SET sql_mode = 'ANSI'");
76 
77 		if(Config::inst()->get('MySQLDatabase', 'connection_charset')) {
78 			$this->dbConn->set_charset(Config::inst()->get('MySQLDatabase', 'connection_charset'));
79 		}
80 
81 		$this->active = $this->dbConn->select_db($parameters['database']);
82 		$this->database = $parameters['database'];
83 
84 		if(isset($parameters['timezone'])) {

72 			$this->databaseError("Couldn't connect to MySQL database | " . $this->dbConn->connect_error);
73 		}
74 		
75 		$this->query("SET sql_mode = 'ANSI'");
76 
77 		if(Config::inst()->get('MySQLDatabase', 'connection_charset')) {
78 			$this->dbConn->set_charset(Config::inst()->get('MySQLDatabase', 'connection_charset'));
79 		}
80 
81 		$this->active = $this->dbConn->select_db($parameters['database']);
82 		$this->database = $parameters['database'];
83 
84 		if(isset($parameters['timezone'])) {
85 			$this->query(sprintf("SET SESSION time_zone = '%s'", $parameters['timezone']));
86 		}
87 	}

Redirecting to https://gitpackage.com/dev/build?returnURL=%2Fpackage-advance-search-ko-kr%2Fdestination%2F... (output started on /home/devpackage/public_html/framework/core/manifest/ManifestCache.php, line 35)

82 		$this->database = $parameters['database'];
83 
84 		if(isset($parameters['timezone'])) {
85 			$this->query(sprintf("SET SESSION time_zone = '%s'", $parameters['timezone']));
86 		}
87 	}
88 
89 	public function __destruct() {
90 		if($this->dbConn) {
91 			mysqli_close($this->dbConn);
92 		}
93 	}
94 
95 	/**
96 	 * Not implemented, needed for PDO
97 	 */