php - 创建一个 php 文件以动态翻译内容

Question

我有一个包含大约 700 个术语的数据库。我只想编写一个名为 Internationalize 的 php 文件，它会检查 mysql 数据库并返回正确的翻译。所有 PHP 变量都已设置，并且有包含所有语言翻译的 View 。大约有11种语言。我查了很多地方，但没有一个适合我的情况。任何建议将不胜感激。

if (!isset($_SESSION))
{
    session_start();
}

if (isset($setup))
{
    $lang=$_SESSION['setupLang'];
}
elseif (isset($_SESSION['lang']))
{
    $lang=$_SESSION['lang'];
}
else
{
require("fetchMainConfig.php");
}

$lang_code = $lang; 
//file_dir contains the language codes for example: il,fr,pt,ge and so on
$sql = "SELECT file_dir FROM `hydroserver_translation`.`language_file_dir`";
if($lang_code = $sql){
    // What should go in here??? What is the best way to
    // dynamically translate the database?
}

我还附上了数据库 View 的副本。我计划编写代码的方式是，如果没有语言翻译，则默认翻译为英语。

Answer 1

这就是我所做的并且有效。感谢您的帮助!

<?php
//Connects to the database
$mysqlserver="servername";
$mysqlusername="langreader";
$mysqlpassword="readHSLlang@9";
$error=0;
$link=mysqli_connect($mysqlserver, $mysqlusername, $mysqlpassword) or $error=1;

$dbname = 'translation';
mysqli_select_db($link, $dbname) or $error=1;
if(!$error)
{//check which is the session language

$language = $lang_code;
//language file path
$file_path = "languages/" .$language. ".php";
//Check if file exists

$file_exists = file_exists($file_path);
if($file_exists){
// The file exists. Now just check when it was last time created.
$file_created_time =  filemtime($file_path);
$timezone = date_default_timezone_set('UTC');
$current_time = time();
//Time lapse to check the difference between the current time and the last created time
$time_lapse = (abs($current_time-$file_created_time)/60/60);
//SQL statement to access the view from the database
$sql = "SELECT * FROM translation.translations_by_language";
$terms = mysqli_query($link, $sql);
//Will create a new file if it has been more than four hours
if($time_lapse >= '4.0'){
//Deleting the existing file to avoid any parsing errors
unlink($file_exists);
//Writing the new language_file
$lang_file= fopen("languages/" .$language. ".php","c+");
//Loops through the query and shows the translated terms 
//and english terms if there are no translations for the term
$new_file = "<?php" . "\n "; 
fwrite($lang_file, $new_file);
while($row = mysqli_fetch_array($terms)) {


        if ($row[$language] != "")
            fwrite($lang_file,$row['php_variable']. " = " . '"' . addslashes($row[$language]) . '"' . ";" . "\n ");
        else
            fwrite($lang_file,$row['php_variable']. " = " . '"' . addslashes($row['english_phrase']) . '"' . ";" . "\n ");
    }
    $last_line = "?>";
fwrite($lang_file, $last_line);
fclose($lang_file);
}   
}
else{
// Creating a new file if the file doesn't exist
$sql = "SELECT * FROM hydroserver_translation.translations_by_language";
$terms = mysqli_query($link, $sql);
$lang_file= fopen("languages/" .$language. ".php","c+");
$new_file = "<?php" . "\n "; 
fwrite($lang_file, $new_file);
while($row = mysqli_fetch_array($terms)) {
print_r($row);
        if ($row[$language] != "")
//Provide the translation
            fwrite($lang_file,$row['php_variable']. " = " . '"' . addslashes($row[$language]) . '"' . ";" . "\n ");
//If translation doesn't exist, just use the english phrase
        else
            fwrite($lang_file,$row['php_variable']. " = " . '"' . addslashes($row['english_phrase']) . '"' . ";" . "\n ");
    }
    $last_line = "?>";
fwrite($lang_file, $last_line);
fclose($lang_file);
//New language file succesfully created!!!!
}
}