developing cakephp multilingual website

To develop any multilingual website (Translated database content only) using cakephp framework all basic steps are discussed below. If you want fully multilingual website with translated button text or label text then go forward with Internationalizing your application
To manage multiple language translated content for any specific models specific field cakephp has a core behavior named TranslateBehavior.
Suppose we want a website with multiple number of language support and site administrator can add/edit/delete any language and front-end user can choose any language to visit the website.
Here are the list of steps given below.
Step 1: Create a db language table

CREATE TABLE `languages` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(120) NOT NULL,
  `flag` varchar(100) default NULL,
  `code_2_digit` varchar(2) NOT NULL,
  `code_4_digit` varchar(6) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

now do a management for languages db table for site administrator
Read More