The multilingual website is necessary if you would like to make your website internationally. To make your website support multiple language, only 3 steps are needed. Create the language file for each language Create a parsing file to include different language file based on cookie/session/user profile Include the parsing file in the homepage and use […]
Read More →In order to support multi-language website, I would like to use PEAR Translation2 But only install Translation is not enough, MDB2 and MDB2#mysql also need to install pear install MDB2 pear install MDB2#mysql pear install Translation2-2.0.4 Then we would use Translation2::factory(‘MDB2’, $db_info, $params); to initialize the translation engine where $db_info consist the database information and […]
Read More →For table, we could use ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; For database, we could use ALTER DATABASE database_name charset=utf8;
Read More →In MAC, when using ‘localhost’ to connect the mysql. I get this error. The solution is to modify /etc/php.ini find the word /var/mysql/mysql.socket and modify it to /tmp/mysql.socket 🙂
Read More →