database design - PHP web app internationalization -

-

i building php web app requires internationalization. have decided use get-text system related strings , perhaps database tables user generated content.

for example, user might able post blog post. should able post different versions of post in different languages. can implement storing posts in posts table column denoting language.

the difficult bit trying internationalize system strings stored in database.

for example, have table stores privileges. each privilege should have string describes privilege does.

at moment, stored in table this:

app_privileges

  • id
  • privilege
  • some other columns
  • description

i plan use application poedit generate gettext files. able search through php files grab strings. in cases string stored in database, can fair bit of work extract string transation. tricks , solutions handling this?

finally, lets have data types , forms users can create , define in app. example, defining "product type" shopping cart. means product have own unique set of attributes , descriptions. these attributes require translating along description.

the same case forms. user can create form might stored in set of tables. these forms need translated.

what database models can use store translations forms , product types?

cheers :)

for strings more "system"-oriented, :

  • buttons
  • feature names
  • privileges
  • etc

gettext good.

privileges, instance, more "system"-oriented (users don't create privileges, rather admins grant them users don't create new types of privileges). so, privileges table can have column "privilege_name" never displayed , contains gettext keys, instance : "privilege : user can edit posts in specified forum".

strings in application should not text user see, more detailed "menu: edit preferences".

those strings go through gettext (even english or site's "mother tongue") , translated proper user-visible strings.

you should use numbered sprintf-style arguments, ie not "price of %s %s" "price of %(1)s %(2)s".

this has several advantages :

  • gettext provides little context, , merges identical strings. translator sees "button: edit post" have lot more translator sees "edit". in languages, simple text "edit" may translate different words, or grammatical forms of same verb, depending on "edited".
  • you can change english text @ without breaking gettext keys other languages
  • numbered arguments handle languages different ordering of subject/verb/etc

if have text in images (like buttons) need take care of too. gettext can translate filenames, (images/buttons/en/submit.png => images/buttons/fr/valider.png although simple regexp nice too) , don't forget blind people using screen readers.

for multilingual user-generated content (stored in tables), usual relational approach better.

table posts( post_id ... ) table posts_translated( post_id foreign key, language_id foreign key, title, text, etc )

this allow use sql showing list of languages available post, allowing default languages, showing untranslated posts, fulltext search, etc.


Comments

Post a Comment

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

-
my group , running server based upon django , uses mod_wsgi run apache server. not working on project after over, attempting set cronjob similar functionality check if apache server has shut down(system restart or power failure), , if has, restart server me. i've found documentation on how check if apache server down , restart server if is, our server uses https , our start command pretty verbose. can use functionality provided in these examples: https://askubuntu.com/questions/277389/cron-job-to-restart-apache https://www.digitalocean.com/community/tutorials/how-to-use-a-simple-bash-script-to-restart-server-programs or need more complicated process make happen? the command use start server is python manage.py runmodwsgi --host 0.0.0.0 --port 8001 --https-port 8000 --ssl-certificate (certificate location) --server-name (domain name) i'm pretty new linux , using both mod-wsgi apache appreciated. you better off using --setup-only option mod_wsgi-expres...
Read more

actionscript 3 - TweenLite does not work with object -

-
i got following problem: i have object called tempscore game. this object blitted canvas renderer via copypixels method. object not display object. it's score-object (self made). score-object extends object called basicblitarrayobject. basicblitarrayobject extends eventdispatcher (therefore no display object). i tried apply several different tweenlite-plugins tempscore-object (i.e. transformaroundcenter, colormatrixfilter, etc.). nothing happens. absolutely nothing. sometimes error messages (when plugin requires display object , object not display object). far good. according greensock (maker of tweenlite) engine can tween numeric property of object. when plugin transformaroundcenter requires display object tweening have modify plugin working non-display object (tempscore). can't because it's way hard me. my game rests upon code: http://www.8bitrocket.com/book/ch11_blastermines.zip try apply tweenlite object called tempmine inside game class blastermines. ...
Read more

php - How can I edit my code to echo the data of child's element where my search term was found in, in XMLReader? -

-
i new in xmlreader, , think kind of hard find tutorials/code or advanced examples. question how can transform code have now, if search (through form) term jquery give me opportunity output value of <info></info> (and later other elements) in every <name></name> found in ? this code output names of books. <?php $reader = new xmlreader(); $reader->open("books.xml"); while ($reader->read()) { switch ($reader->nodetype) { case (xmlreader::element): if ($reader->localname == "name") { $reader->read(); echo $reader->value; break; }}} ?> the xml file <?xml version="1.0" encoding="iso-8859-1"?> <library> <book isbn="781"> <name>scjp 1.5</name> <info>sun certified java programmer book</info> </book> <bo...
Read more