static function getSEFPath($non_sef) { if (self::$sef_path !== false) { return self::$sef_path; } $db = CoreFactory::getDB(); $config = CoreConfig::getInstance(); $urls_db_table = $config->get('urls_db_table'); $query = "\n\t\t\t\tSELECT sef FROM `{$urls_db_table}` WHERE non_sef = '{$non_sef}'\n\t\t\t"; self::$sef_path = $db->setQuery($query)->getResult(); return self::$sef_path; }
static function build($non_sef, $alias, $is_add_base_url = 0) { $alias = Route::buildAlias($alias); //trim($path, '/\\') // return '/'.$alias.'/'; $non_sef = trim($non_sef, " \t./\\"); $sef_url = trim($alias, " \t./\\") . '.html'; $config = CoreConfig::getInstance(); $is_use_sef_urls = $config->get('is_use_sef_urls'); if (!$is_use_sef_urls) { if ($is_add_base_url) { return base_url() . $non_sef . '/'; } return $non_sef . '/'; } $db = CoreFactory::getDB(); $urls_db_table = $config->get('urls_db_table'); $query = "\n\t\t\tSELECT non_sef FROM `{$urls_db_table}` WHERE sef = '{$sef_url}'\n\t\t"; $current_non_sef = $db->setQuery($query)->getResult(); if ($current_non_sef && $current_non_sef == $non_sef) { if ($is_add_base_url) { return base_url() . $sef_url; } return $sef_url; } $query = "\n\t\t\tSELECT sef FROM `{$urls_db_table}` WHERE non_sef = '{$non_sef}'\n\t\t"; $cur_sef_url = $db->setQuery($query)->getResult(); if ($cur_sef_url) { $sef_url = $cur_sef_url; } else { $query = "\n\t\t\t\tINSERT INTO `{$urls_db_table}` SET sef = '{$sef_url}', non_sef = '{$non_sef}'\n\t\t\t"; $db->setQuery($query)->execute(); } if ($is_add_base_url) { return base_url() . $sef_url; } return $sef_url; }
include_once CORE_FOLDER . 'factory.php'; include_once CORE_FOLDER . 'base.php'; include_once CORE_FOLDER . 'config.php'; include_once CORE_FOLDER . 'controller.php'; include_once CORE_FOLDER . 'url.php'; include_once CORE_FOLDER . 'db/mysqli.php'; include_once CORE_FOLDER . 'db/active_record.php'; include_once CORE_FOLDER . 'db/statement.php'; include_once CORE_FOLDER . 'views_loader.php'; include_once CORE_FOLDER . 'models_loader.php'; include_once CORE_FOLDER . 'model.php'; include_once CORE_FOLDER . 'input.php'; include_once CORE_FOLDER . 'route.php'; include_once CORE_FOLDER . 'session.php'; include_once CORE_FOLDER . 'files_upload.php'; $db = CoreFactory::getDB(); //$db->setQuery('SET NAMES "utf8"')->execute(); $config = CoreConfig::getInstance(); $controller = URL::segment(1); if (!$controller) { if (!$config->get('default_controller')) { error('No default controller assigned'); exit; } $controller = $config->get('default_controller'); } $controller = strtolower($controller); $controller_file = APPLICATION_FOLDER . 'controllers/' . $controller . '.php'; if (!file_exists($controller_file)) { error('Controller file does not exist', 404); exit;
function __construct() { $this->db = CoreFactory::getDB(); }
function write() { // $session_table = Sessions::getInstance(); // $session_table->where('id', $this->sess_info['id']); // $session_table->user_data = addslashes(serialize($this->data)); // $session_table->update(); $config = CoreConfig::getInstance(); $db = CoreFactory::getDB(); $query = "\n\t\t\tUPDATE `" . $config->get('sess_db_table') . "`\n\t\t\tSET\n\t\t\t\t`user_data` = '" . addslashes(serialize($this->data)) . "'\n\t\t\tWHERE `id` = '{$this->sess_info['id']}'\n\t\t"; $db->setQuery($query)->execute(); }