Establishing an database connection

php

/** @var PageModel $objPage */
global $objPage;
$this->import('Database');
$vars = array();

// Get the global theme variables
$objTheme = $this->Database->prepare("SELECT tl_theme.vars FROM tl_theme, tl_layout WHERE tl_theme.id=tl_layout.pid AND tl_layout.id=?")
						   ->limit(1)
						   ->execute($objPage->layoutId);

if ($objTheme->vars != '' && \is_array(($tmp = StringUtil::deserialize($objTheme->vars))))
{
	foreach ($tmp as $v)
	{
		// remove $ for backwards compatability with existing entries on the key
		$vars[str_replace('$', '', $v['key'])] = $v['value'];
	}
}