news story titles in urls

[eluser]Flayra[/eluser]
CI has a built-in converter, url_title() that takes your title as a parameter and returns "friendly" url:

Code:

$title = 'The Greatest Blog Post ever(tm)';
$urltitle = url_title($title); // returns 'the-greatest-blog-post-ever-tm'

You then save this url in your database together with your blog (or news, or whatever) post, and when it's called you search for that string and return that post.

Code:

// Assuming the called URL is something like news/show/the-greatest-blog-post-ever-tm/
$title = $this->uri->segment(3);
$q = $this->db->getwhere('blog', array('urltitle' => $title));
// Show it

I hope this helps clarify it