Select Database Table Row Function

[mgazi]

    function selectLanguage($c)
    {
        global $l; // Get language code from url via $_GET method
        
        if (($l) AND (($l == 'en') OR ($l == 'de')))
        {
            if ($l == 'en')
            {
                return $c;
            }
            if ($l == 'de')
            {
                return $c.'_l1';
            }
        }
        else
        {
        return $c;
        }    
    } 

I have a sql table. It's name is content.
In content table, i have 2 rows. These are content_main and content_main_l1.

The rows are have same content. content_main is in english. content_main_l1 is in german.

My links are like;

xxx.com/en/content
xxx.com/de/content

I want, if url contains en, the function returns content_main and if url contains de the function return content_main_l1.

echo selectLanguage($content->content_main);  // I use ezsql class so i write row name like $content->content main 

I use the function like above. But the output is like;
$content->content_main_l1 or $content->content_main

OR

if i use quote or double quote the output is like;

contentOfRow_lr or contentOfRow

So how can i run this function correct.

[eval(BadCode)]

In my experience this is passed as part of the request headers ($_GET):

http://yourURL.ext/pages/page.php?lang=en

if(isset($_GET['lang'])) 
  switch($_GET['lang']):
    case('en'): 
      echo selectLanguage($content->content_main);
      break;
    case('de'): 
      echo selectLanguage($content->content_main_l1);; break;
    default:    
      echo selectLanguage($content->content_main);
      break;
   endswitch;

#or 

echo (isset($_GET['lang']) && $_GET['lang'] == 'de') ? 
  $content->content_main_l1 : 
  $content->content_main; 

Cheers

[NoEffinWay]

I would do it like this (if you dont like the GET method):

$lang = explode('/',$_SERVER['PATH_INFO']);
if($lang[1] == 'en'){
      echo selectLanguage($content->content_main);
}elseif($lang[1] == 'de'){
      echo selectLanguage($content->content_main_l1);
}else{
      echo 'Invalid Language';
} 

[mgazi]

These are not solution of my problem. Because content->content_main is just a sample. I have lots of tables and rows. So i'm trying to write a function.


anyway...

I found the solution.

function selectLanguage($c)
{
    global $l;

    if (($l) AND (($l == 'tr') OR ($l == 'en')))
    {
        if ($l == 'tr')
        {
            return $c;
        }
        if ($l == 'en')
        {
            return ${$c.'_l1'};
        }
    }
    else
    {
    return $c;
    }    
}