在PHP中循环进入一个开关？

Question

I am trying to make a website in different languages and I retrieve this information from a database. For now I have two languages in there: English and Dutch.

What I would like to do is getting all the language possibilities and put this into a switch. So if people will click on for example this link: index.php?page=NL they will get the Dutch translation of the page.

So this is the code that I am using. It works so far but it shows I think the language option and the default option. Because when I remove default I only get the code ones.

    <div id="content">
    <?php 
    //Retrieve languages
    $querySwitchLang = "SELECT * FROM languages";
    $resultSwitchLang = mysql_query($querySwitchLang);
    ?>
    <?php
    while($rowSwitchLang = mysql_fetch_array($resultSwitchLang)){
        switch($page){
            case $rowSwitchLang['langCode']:include('page.php');break;
            default: include('pageDefault.php'); 
            break;
        }
    }
    ?>   
    </div>

So actually I wanted to have it like this because now it runs the switch statements as many times as there are languages I think:

    <div id="content">
    <?php 
    //Retrieve languages
    $querySwitchLang = "SELECT * FROM languages";
    $resultSwitchLang = mysql_query($querySwitchLang);
    ?>
    <?php
    include('functions.php');

        switch($page){
                        while($rowSwitchLang = mysql_fetch_array($resultSwitchLang)){
            case $rowSwitchLang['langCode']:include('page.php');break;
                        }
            default: include('pageDefault.php'); 
            break;

    }
    ?>   
    </div>

But this doesn't work because then I will get this error:

Parse error: syntax error, unexpected 'while' (T_WHILE), expecting case (T_CASE) or default (T_DEFAULT) or '}' in C:\wamp\www\glimpler\index.php on line 6

I can't realy figure out how to solve this problem.

Answer 1

i think you're approach is a bit messy is to use file for the translation instead of db, like this:

NL.php

   <?php
      return [
         'welcome' =>'welkom',
         'goodbye' =>'afscheid'
         ];

then in your index

$translationFile =$_GET['page'].'.php';
if(file_exists(translationFile)){
    $language = include(translationFile);
}
else{
 die("Couldn't find translation file. Page Terminated!");
}

and then just echo your translation.

echo $language['welcome'] . ' USER';

the advantage is not havinge multiple page for every language and that make it easier to update. reguarding the default you can just set $_GET['page'] to 'EN' if is not set.