localization issue

You should have a language column on mysql for any table (pages, products, blog etc).
On your controller you can retrieve your datas by using: slug + language, or id + language

For example (Controller):

Code:

public function about_us()
{

$lang = $this->request->uri->getSegment(1);
$page_slug = $this->request->uri->getSegment(2);

$data['page'] = $this->PageModel->fetch_page($lang, $page_slug);

echo view ('site/assets/header',$data);
echo view ('site/page');

}

Model:

PHP Code:

public function fetch_page($lang, $page_slug){
        $db      = \Config\Database::connect();
        $builder = $db->table('pages');
        $query = $builder->where('page_slug', $page_slug)
                    ->where('page_lang', $lang)
                ->get();

            return $query->getRow();
    } 


+ you can name your routes in any language, and get the source from the same Controller and Method.

Code:

$routes->get('{locale}/about-us', 'Helloworld::about_us');
$routes->get('{locale}/chi-siamo', 'Helloworld::about_us');
$routes->get('{locale}/wer-wir-sind', 'Helloworld::about_us');

Everything is clear.