The one i am having trouble with relates to a blog that I've set up. The table for the blog entries has an SEO keyword column for each respective entry. The current URL comes up as http://www.imbued.co.uk/blog?news_id=5 with 5 being the 5th blog entry. I would rather the URL was cleaner such as http://www.imbued.co.uk/blog/seokeywordfromthetable
Can the SEO URL file below be tweaked for it to come as such?
<?php
class ControllerCommonSeoUrl extends Controller {
/* SEO Custom URL */
private $url_list = array (
'common/home' => '',
'checkout/cart' => 'basket',
'product/special' => 'special',
'product/search' => 'search',
'affiliate/account' => 'affiliate',
'account/voucher' => 'gift-voucher',
'checkout/success' => 'checkout/success',
'product/manufacturer' => 'brand',
'account/transaction' => 'transactions',
'information/contact' => 'contact-us',
'product/compare' => 'compare',
'information/news' => 'blog',
'information/sitemap' => 'sitemap',
);
/* SEO Custom URL */
public function index() {
// Add rewrite to url class
if ($this->config->get('config_seo_url')) {
$this->url->addRewrite($this);
}
// Decode URL
if (isset($this->request->get['_route_'])) {
$parts = explode('/', $this->request->get['_route_']);
foreach ($parts as $part) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE keyword = '" . $this->db->escape($part) . "'");
if ($query->num_rows) {