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 

New version 0.2.4 of ApPHP MVC Framework has been released.

We've released next version 0.2.4 of our new product - ApPHP MVC Framework. ApPHP MVC Framework is designed to provide modern and rapid development of websites, web applications and web services.

It implements the the Model-View-Controller (MVC) design pattern and principles, including separation of display, logic, and data layers. It provides an architecture, components and tools for developers to build a complex web applications faster and safer.

Choosing ApPHP MVC Framework allows you to release your applications earlier, host and scale them without problem, and maintain them over time with easy.

Last changes:

• Feature: [added] added new demo - Simple Blog
• Feature: [added] added new core class CActiveRecords implements "Active Record" pattern
• Feature: [added] added real check for "mod_rewrite" in utils requirements checker
• Feature: [added] added core base class CComponent, now all application component classes extends CComponent
• Feature: [added] added get/SetResponseCode() for A class
• Feature: [added] added new widget "pagination" in helper Widget
• Feature: [added] added possibility to create and register application-level components
• Feature: [added] added new component CMessageSource for localization purposes
• Feature: [improved] suffix Model for model classes is now optional (not required)
• Feature: [improved] added new elements and properties in Widget::form() and Widget::formValidation()
• Feature: [improved] added new elements to Html helper
• Feature: [improved] minor changes in Auth helper
• Feature: [improved] minor changes in CController->errorAction()
• Feature: [improved] improved error handling in Database class
• Feature: [improved] all framework classes get prefix "C" to avoid name overlapping
• Feature: [improved] removed passing registry to CRouter::route()
• Feature: [improved] in CDatabase added possibility to define named placeholder with data type. e.g: i:id
• Bugs fixed

To download this script follow the link:
http://www.apphp.com/php-framework/index.php

To review DEMO sites, built on the framework:
http://www.apphp.com/php-framework/examples/demos/index.php

New version 2.0.2 of ApPHP DataValidator has been released

The new version 2.0.2 of of ApPHP DataValidator has been released and available now for downloading.

ApPHP DataValidator is a simple lightweight tool useful for primary general data checks. It handles numbers, strings, emails, URLs. A range of parameters is provided for a wide variety of different verifications. All parameters are used optionally and could be switched on and off for every specific value.
The DataValidator component accepts an array or an object as data container, so it can be easily used to check values got by HTTP request, obtained from database, parsed XML or CSV file or any other source as soon as data are in correct format (array('key'=>'value')). Error handling is made easy and flexible. If validation process fails, you can either obtain a generated error-message or use error-details for logging and user informing in you own style.

Data validation is typically used to make sure that incoming data has a certain quality/value. The validation process is running on a server-side.

Last changes: Version 2.0.2 (Mar 11, 2013)

• Feature: [added] new validation type: oneOfSet (class ValidatorTypeOneOfSet).
• Feature: [added] versioning. Validator class current version can be got with method $validator->GetVersion(), major version can be checked with $validator->CheckMajorVersion($needed).
• Feature: [added] method $validator->GetErrorArrayIndexedByField(), which returns error array as array($fieldName => array(ValidatorError $error1, ValidatorError $error2)).
• Feature: [improved] errors messages for strings are more specific: additional elements are added.
• Bugs fixed

To see the script in action click here: LIVE DEMO 

To check all recent changes click here: CHANGE LOG