网站内部化 - 最佳规则[已结束]

Question

I'm using PHP.

I've a system that I need to translate in french, italian, spanish, ...

So I came with two solutions.

Solution 1: All the language strings are store in a DB to allow easy editing after for the administrator. So on each page I will need to call this table in order to get the correct strings.

Solution 2: Same like the first one except that I will generate after each change a Json file. This Json file will be call on each page to print the right strings.

Witch of my solution is the best pleas ?

Perhaps, another solution exists for that ?

Thanks.

Answer 1

Use a database: you can hold questions and answers in a table that has each language answer in columns - its simple enough to then set up an RBAC module to allow specific users to add new questions and answers.

questions_table:
    question_id (int) 255 PK AUTO_INCREMENT
    question (varchar) 160

answers_table:
    answer_id (int) 255 PK AUTO_INCREMENT
    question_id (int) 255
    language_id (int) 255
    answer (varchar)

language_table:
    language_id (int) 255 PK AUTO_INCREMENT
    language (varchar) 30

user table and user answer table also

using this, you'll be able to reference between tables using INNER JOIN sql statements, then all you need to do is create a driver object for your connection (preferably pdo) and then objects for answering questions, logging in, registering, admin and a front end display.