dongyu4455 2018-08-29 15:19
浏览 90

PHP-SQL - 国际化和本地化 - Gettext-POedit

I'm creating a site that I want to display in multiple languages for different countries, but this is my first time doing this and not sure what est practices are.

So for all my static text in my code I just wrap it in the translate function and POedit is able to extract the strings.

Then for all my dynamic text that is being generated via PHP from my DB, when I add something new to my DB on the back end, I also do a file_put_contents() into the PO file as well so I have those strings to be translated.

So everything in my database is in english but gets added to my PO file. The issue is I also have a search bar. This searches my DB for various items but can only search in english.

What I am trying to do at the moment is something like this, where I translate the actual input using Google Translate API and search in English:

$term = $_POST['search_text'];
$result = $translate->translate($term, [
    'target' => 'en'
$translation = $result['text'];
$new_term = '%'.$translation.'%';
$params = [$new_term];
$sql = "SELECT * FROM products WHERE product_name LIKE ?";
$stmt = DB::run($sql,$params);

Obviously this isn't perfect because I'm relying on Google to do translate the search terms, but it is picking up the right results in general.

Is there a better way of doing this because this seems like I'm going about it the wrong way. Any help or suggestions with this would be greatly appreciated.

  • 写回答

1条回答 默认 最新

  • dongyi9484 2019-07-31 09:08

    What I ended up doing was searching in english and seaching with a translation and combining the results so it will hopefully pick up everything.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥500 亚马逊 COOKIE我如何才能实现 登录一个亚马逊账户 下发新 COOKIE ..我使用下发新COOKIE 导入ADS 指纹浏览器登录,我把账户密码 修改过后,原来下发新COOKIE 不会失效的方式
  • ¥20 玩游戏gpu和cpu利用率特别低,玩游戏卡顿
  • ¥25 oracle中的正则匹配
  • ¥15 关于#vscode#的问题:把软件卸载不会再出现蓝屏
  • ¥15 vimplus出现的错误
  • ¥15 usb无线网卡转typec口
  • ¥30 怎么使用AVL fire ESE软件自带的优化模式来优化设计Soot和NOx?
  • ¥15 Ubuntu20.04.4.LTS系统如何下载安装VirtualBox虚拟机?
  • ¥15 如何用QDomDocument读取内容为空格的xml数据
  • ¥15 请阅读下面代码,帮我修改下代码