用 PHP 构建多语言网站：消除语言障碍

CREATE TABLE translations (
id INT NOT NULL AUTO_INCREMENT,
locale VARCHAR(255) NOT NULL,
key VARCHAR(255) NOT NULL,
value TEXT NOT NULL,
PRIMARY KEY (id)
);

// 获取当前语言
$current_locale = isset($_GET["locale"]) ? $_GET["locale"] : "en";

// 语言链接
$languages = array("en", "es", "fr");
foreach ($languages as $lang) {
echo "<a href="?locale=$lang">$lang</a> ";
}

// 查询翻译
$translations = $db->prepare("SELECT * FROM translations WHERE locale = ?");
$translations->execute(array($current_locale));

// 存储翻译数组
$tr = array();
foreach ($translations as $row) {
$tr[$row["key"]] = $row["value"];
}

// 使用 gettext 获取翻译
echo gettext("This is a test");

// 创建 DateTime 对象
$dt = new DateTime();

// 国际化日期和时间格式
$dt->setTimezone(new DateTimeZone("Europe/London"));
echo $dt->fORMat("Y-m-d H:i:s");

// 创建 NumberFormatter 对象
$formatter = new NumberFormatter("en_US", NumberFormatter::CURRENCY);

// 格式化货币
$amount = 1000;
echo $formatter->formatCurrency($amount, "USD");

function t($key) {
global $tr;
return isset($tr[$key]) ? $tr[$key] : $key;
}