[RESOLVED] Concatenate lang var to query result

kamy99

Working on a bilingual website on CodeIgniter. The lang variable is being passed properly. for example en, fa

What I wanna do in my view is to concatenate the language to my query result to display that language’s part only.

For example to display title:

$myLng=$this->lang->lang();

<? foreach($query->result() as $row): ?>

<?=$row->title_.$myLng;?>

<? endforeach?>

I echo $myLng and it always corresponds to my selected language. but for some reason I can’t attach it to my query result.
for example in the single langugae version it is :

<? foreach($query->result() as $row): ?>

<?=$row->title_en;?>

<? endforeach?>

Any ideas what I’m doing wrong?

thanks

johanafm

If you are actually pulling text in all different languages every time, you aren't dealing with this in the right place. And if you aren't pulling all different language versions, then why not simply keep the text, no matter what language it is in, in a var called title?

class C
{
	private $db;
	public $title;

public function __construct($lang)
{
	$this->db = pdo_connect();
	$this->init_texts($lang)
}

private function init_texts($lang)
{
	# get the needed texts in one single language, not all
	# and since you only ever deal with one language, there's no need
	# to use multiple $title_LANGUAGE variable. $title will do fine
	$this->db->query("SELECT title FROM texts WHERE lang='$lang'");
	$r = $db->fetch(PDO::FETCH_ASSOC);
	$this->title = $r['title'];
}

}

As for answering the very specific quetion

->{'title_'.$lang}

kamy99

Thanks for your reply. I saw it too late ! but I ended up doing something similar to what you suggested, basically I pass the lang name within the controller in the actual SQL statement, then just display the text.