Url Management Routing in CodeIgniter

$route[ 'default_controller' ]  = 'main';

$route[ '404_override' ]        = 'error404';

 

require_once( BASEPATH . 'database/DB' . EXT );
$db = & DB();
$query = $db->get('company_profile');
$result = $query->result();
if (!empty($result))
{
    foreach ($result as $row)
    {
        $route[$row->slug] = "profile";
    }
}