Dynamic routing names

I would often load the DB class in the routes file and do something like this

PHP Code:

require_once( BASEPATH .'database/DB'. EXT );
$db =& DB();

$uri = explode('?', $_SERVER['REQUEST_URI']); //We don't want to include querystring data
$uri = explode('/', $uri[0]);

if($uri[1]) //Not the homepage then check slugs
{
 if($uri[1] == 'blog' && $uri[2])
 {
 //Check blog slugs
 $db->select('post_id, post_slug');
 $db->where('post_slug', $uri[2]);
 $db->where('post_live', 1);
 
 if($post = $db->get('tbl_blog_post')->row_array())
 {
 $route['blog/'.$post['post_slug']] = 'blog/post/'.$post['post_id'];
 }
 }
} 


www.hotfootdesign.co.uk
regalo.gifts