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