Containers Overview
Summary
Translation2 supports different storage drivers; this page is meant to highlight the differences among them.
PEAR::DB, PEAR::MDB, PEAR::MDB2
Translation2 can work with any of these database abstraction layers, just pass the appropriate connection options. These three containers are absolutely identical in what they do and in how they work (wrt Translation2, of course).
<?php
// connection options
$dbinfo = array(
'hostspec' => 'host',
'database' => 'dbname',
'phptype' => 'mysql',
'username' => 'user',
'password' => 'pwd'
);
//select the preferred driver
$driver = 'MDB2'; //switch to 'DB' or 'MDB' as needed
require_once 'Translation2.php';
$tr =& Translation2::factory($driver, $dbinfo, $params);
?>
If your table definition is different from the default one, you need to
specify it in the
$params
array.
DB_DataObject
The dataobjectsimple container is the natural choice
for those using
DB_DataObject,
as it is tightly tied to the DAO. This storage driver can use all databases supported by
the PEAR::DB
abstraction layer to fetch data.
For this container, you can't specify a custom table definition, since this feature is not supported yet. You must create a table with the following structure:
// meta data etc. not supported
table: translations
id // not null primary key autoincrement..
string_id // translation id
page // indexed varchar eg. (mytemplate.html)
lang // index varchar (eg. en|fr|.....)
translation // the translated value in language lang.
Here's the MySQL query that can be used to create the table:
create table translations (
id int(11) auto_increment not null primary key,
string_id int(11), page varchar(128),
lang varchar(10), translation text
);
alter table translations add index page (page);
alter table translations add index lang (lang);
alter table translations add index string_id (string_id);
then just run the dataobjects createtables script.
Gettext
This is a wrapper around the gettext base functions, and thanks to File_Gettext you can retrieve an entire domain or write to an existing/new domain without calling the command line compiler utility.
The gettext container requires PEAR::File_Gettext and PEAR::I18Nv2 0.9.1 or newer, make sure you have them installed.
The construction parameters are a bit different from the db ones. To make things as simple as possible, the domain definitions and the available language list are read from two INI files.
langs.ini example:
; If one does not specify the source encoding, ISO-8859-1 is assumed
; Beware that gettext can choke on bad encodings!
[en]
name = English
encoding = iso-8859-1
[de]
name = Deutsch
encoding = iso-8859-1
[it]
name = italiano
encoding = iso-8859-1
domains.ini example:
messages = /path/to/locale
2nddomain = /path/to/locale
3rddomain = /path/to/locale
Sample code to use Translation2 with the gettext container:
<?php
require_once 'Translation2.php';
$params = array(
'prefetch' => false,
'langs_avail_file' => 'path/to/langs.ini',
'domains_path_file' => 'path/to/domains.ini',
'default_domain' => 'messages',
//'file_type' => 'po',
);
// Better set prefetch to FALSE for the gettext container, so we don't need
// to read in the whole MO file with File_Gettext on every request.
$tr =& Translation2::factory('gettext', $params);
$tr->setLang('en');
// Note that, if there is no translation available for a string, the gettext
// container will return the string ID! This behaviour emulates native gettext.
echo $tr->get('mystring');
print_r($tr->getPage('3rddomain'));
?>
XML
The XML container requires PEAR::XML_Serializer 0.13.0 or newer, make sure you have it installed.
<?php
$driver = 'XML';
$options = array(
'filename' => 'i18n.xml',
'save_on_shutdown' => true, //set to FALSE to save in real time
);
require_once 'Translation2.php';
$tr =& Translation2::factory($driver, $options);
?>