419 		// default to the global read db
420 		if (!$dbx) {
421 			global $db;
422 			$dbx = $db;
423 		}
424 		// execute the query
425         elapsed('begin SQL: ' . $sql);
426 		$rows = $dbx->query($sql, PDO::FETCH_OBJ);
427         elapsed('end SQL');
428 		return $rows->fetchAll();
429 	}
430 
431 	function sql_array($SQL, $dbx=NULL){
432 		$rows = sql($SQL,$dbx);
433 		$rs = array();

0 string UTF-8 (157) "SELECT id FROM news WHERE active = 1 and news.slug = 'fhfa-d …"

SELECT id FROM news WHERE active = 1 and news.slug = 'fhfa-director-dr.-mark-a.-calabria's--statement-before-the-u.s.-house-committee--on-financial-services'

1 integer 5

182                 	if ($this->settings['database_folder']['where']) {
183                 		$sql .= ' and ' . $this->settings['database_folder']['where'];
184                 	}
185                 	if ($this->settings['database_folder']['order_by']) {
186                 		$sql .= ' order by ' . $this->settings['database_folder']['order_by'];
187                 	}
188                 	\elapsed($sql);
189                 	$rs = sql($sql);
190                 	if (count($rs)) {
191                 		$lookup_id = $rs[0]->id;
192                 	}
193                 	$rs = null;
194                 }
195 
196                 // clear database folder settings

sql string UTF-8 (157) "SELECT id FROM news WHERE active = 1 and news.slug = 'fhfa-d …"

SELECT id FROM news WHERE active = 1 and news.slug = 'fhfa-director-dr.-mark-a.-calabria's--statement-before-the-u.s.-house-committee--on-financial-services'

49 	}
50 
51 	/*
52 		@param (string)
53 		shortcut to checkPath using $path as a string
54 	*/
55 	public function routePath($path) {
56 		return $this->checkPath(explode('/', $path), 'pages');
57 	}
58 
59 	/*
60 		resets found settings to a clean state
61 		keeps codebases/db/default_page/page_404
62 	*/
63 	public function cleanSettings() {

qs array (3)

string UTF-8 (0) ""

string UTF-8 (8) "newsroom"

string UTF-8 (102) "fhfa-director-dr.-mark-a.-calabria's--statement-before-the-u …"

fhfa-director-dr.-mark-a.-calabria's--statement-before-the-u.s.-house-committee--on-financial-services

prefix string UTF-8 (5) "pages"

41 		$this->db = $o->db;
42 		if ($o->page_path_default) $this->page_path_default = $o->page_path_default;
43 		if ($o->page_path_404) $this->page_path_404 = $o->page_path_404;
44 		$this->uri = $o->uri;
45 	}
46 
47 	public function routeURI() {
48 		return $this->routePath($this->uri);
49 	}
50 
51 	/*
52 		@param (string)
53 		shortcut to checkPath using $path as a string
54 	*/
55 	public function routePath($path) {

path string UTF-8 (112) "/newsroom/fhfa-director-dr.-mark-a.-calabria's--statement-be …"

/newsroom/fhfa-director-dr.-mark-a.-calabria's--statement-before-the-u.s.-house-committee--on-financial-services

319 
320 
321 	/*
322 		returns an array of properties used to configure a new Page object
323 	*/
324 	public function getPageProperties() {
325 
326 		$this->routeURI();
327 		$this->checkPagePath();
328 
329 		$incpath = ($this->is_default)
330 			? substr($this->default_page, 0, strrpos($this->default_page, '/'))
331 			: null;
332 
333 		$path_keys = array_keys($this->page_path);

110     'db' => $db,
111     'page_path_404' => $page_404,
112     'page_path_default' => $default_page,
113     'uri' => $uri['path']
114 ));
115 
116 # instantiate page using PageRouter
117 $p = new \Sky\Page($router->getPageProperties());
118 $p->sky_start_time = $sky_start_time;
119 
120 $protocol = 'http';
121 if ($server_ssl_header && $_SERVER[$server_ssl_header]) $protocol = 'https';
122 if ($_SERVER['HTTPS']) $protocol = 'https';
123 
124 $p->protocol = $_SERVER['HTTPS'] ? 'https' : 'http';

23     'www.mbanj.com' => 'mbanj.com'
24 ];
25 
26 
27 // make sure this folder is writable
28 $skyphp_storage_path = "/var/www/storage/";
29 
30 include $skyphp_codebase_path . 'sky.php';

0 string UTF-8 (33) "/var/www/codebases/skyphp/sky.php"