Tutorial - Multilanguage Database Design in MySQL

Building a multi-language website is not a trivial task and you will encounter many problems on this way, and one of them is how you're planning to store the content of the site in the database for each language.

You may perform a small research on the Web and find enough resources about it, but there is no a magic solution, you have to understand this - each solution depends on your personal requirements, size of the database, complexity of your site, etc. So we'll discuss only major techniques. If you want to learn more, you may find additional information with a Google search.

Ok, so... there are more or less 4 popular databases schemas for multilanguage website.

• Column Approach
• Multirow Approach
• Single Translation Table Approach
• Additional Translation Table Approach

Find more tutorials here.

Tutorials section added on the site

Hi everyone!

We've added a new section on our site called Tutorials, that  is designed for new and experienced users of PHP, ApPHP products and/or those who just started to learn PHP and web development. You are encouraged to take an active role in ApPHP web-developers community and submit new tutorials or post comments.

To access this section click here: Tutorials

New version 3.3.0 of ApPHP MicroBlog has been released

We've released new version 3.3.0 of ApPHP MicroBlog. ApPHP MicroBlog (ApPHP MicroB) is very simple and powerful PHP blog software. This product enables you to start your own blog within minutes. You can easy add and manage your posts and posting categories. This script is perfect for web designers and developers that want to empower their site and save the time on editing web pages every time they want to add more news. The script is very flexible, it written in object-oriented style and allows web developers easy change it to suit their needs.

Download the latest version

Last changes:

Version 3.3.0 (May 02, 2013)

• Feature: [added] possibility to view authors profiles by clicking on avatar or name link
• Feature: [added] Authors module with many settings : Accounts -> Settings -> Authors Settings
• Feature: [added] Pages module that allows to create stand-alone pages such as an "About Me" page etc.
• Feature: [improved] each author from now has specific directory for uploaded files
• Bugs fixed

Version 3.2.4 (Apr 22, 2013)

• Feature: [added] possibility to show Show Authors List via General -> Site Settings
• Feature: [added] new image upload plugin to TinyMCE editor
• Feature: [added] countries management page in admin panel
• Feature: [added] new settings for Gallery Module - Show Items Count in Album
• Feature: [added] highlighting for search results
• Feature: [added] possibility to use SMTP mailer via General -> Site Settings -> Email Settings
• Feature: [added] possibility to create "hidden" categories
• Feature: [added] possibility to define "posted by" test via Posts -> Settings -> Posts Settings
• Feature: [added] possibility to show "share to social networks" icons under post's text
• Feature: [improved] installation module: added admin email, changed some styles etc.
• Feature: [improved] minor changes in ModulesSettings class
• Feature: [improved] minor changes in Sessions class
• Feature: [improved] minor changes in Pool module
• Feature: [improved] minor changes in Backup module
• Feature: [improved] changes in expended panels in administration area
• Feature: [improved] minor changes in Contact module
• Feature: [improved] minor changes in Vocabulary class
• Feature: [improved] openWYSIWYG editor removed
• Bugs fixed