how to translate dynamic content using php and mysql

//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 = " . "\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 = " . "\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!!!!
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Gokhul Varman9y ago
2. //Connects to the database
3. $mysqlserver="servername";
4. $mysqlusername="langreader";
5. $mysqlpassword="readHSLlang@9";
6. $error=0;
7. $link=mysqli_connect($mysqlserver, $mysqlusername, $mysqlpassword) or $error=1;
9. $dbname = 'translation';
10. mysqli_select_db($link, $dbname) or $error=1;
11. if(!$error)
12. {//check which is the session language
14. $language = $lang_code;
15. //language file path
16. $file_path = "languages/" .$language. ".php";
17. //Check if file exists
19. $file_exists = file_exists($file_path);
20. if($file_exists){
21. // The file exists. Now just check when it was last time created.
22. $file_created_time = filemtime($file_path);
23. $timezone = date_default_timezone_set('UTC');
24. $current_time = time();
25. //Time lapse to check the difference between the current time and the last created time
26. $time_lapse = (abs($current_time-$file_created_time)/60/60);
27. //SQL statement to access the view from the database
28. $sql = "SELECT * FROM translation.translations_by_language";
29. $terms = mysqli_query($link, $sql);
30. //Will create a new file if it has been more than four hours
31. if($time_lapse >= '4.0'){
32. //Deleting the existing file to avoid any parsing errors
33. unlink($file_exists);
34. //Writing the new language_file
35. $lang_file= fopen("languages/" .$language. ".php","c+");
36. //Loops through the query and shows the translated terms
37. //and english terms if there are no translations for the term
38. $new_file = " . "\n ";
39. fwrite($lang_file, $new_file);
40. while($row = mysqli_fetch_array($terms)) {
43. if ($row[$language] != "")
44. fwrite($lang_file,$row['php_variable']. " = " . '"' . addslashes($row[$language]) . '"' . ";" . "\n ");
45. else
46. fwrite($lang_file,$row['php_variable']. " = " . '"' . addslashes($row['english_phrase']) . '"' . ";" . "\n ");
47. }
48. $last_line = "?>";
49. fwrite($lang_file, $last_line);
50. fclose($lang_file);
51. }
52. }
53. else{
54. // Creating a new file if the file doesn't exist
55. $sql = "SELECT * FROM hydroserver_translation.translations_by_language";
56. $terms = mysqli_query($link, $sql);
57. $lang_file= fopen("languages/" .$language. ".php","c+");
58. $new_file = " . "\n ";
59. fwrite($lang_file, $new_file);
60. while($row = mysqli_fetch_array($terms)) {
61. print_r($row);
62. if ($row[$language] != "")
63. //Provide the translation
64. fwrite($lang_file,$row['php_variable']. " = " . '"' . addslashes($row[$language]) . '"' . ";" . "\n ");
65. //If translation doesn't exist, just use the english phrase
66. else
67. fwrite($lang_file,$row['php_variable']. " = " . '"' . addslashes($row['english_phrase']) . '"' . ";" . "\n ");
68. }
69. $last_line = "?>";
70. fwrite($lang_file, $last_line);
71. fclose($lang_file);
72. //New language file succesfully created!!!!
73. }
74. }
0