The same can be achieved in a much simpler way with Gettext! With gettext, you send a file to your translator, and receive the same file completed. Period. Instead of logging to a DB, the translator simply creates string translations with a user-friendly editor, such as the excellent POEdit (http://poedit.sourceforge.net) for Windows. Takes a dummy 2 minutes to understand how it works. I guarantee that with this method you will translate 500 strings in less than a day. In contrast, updating DB records one by one is much longer: requires a broadband connection, no cut-and-paste available (believe me, there is a lot of such!) Also, later updating your DB concurrently will be a nightmare. With Gettext, you simply regenerate the master file (eg English) from the application and send the language files to the translator(s). The few strings that are not yet translated will appear nicely in their editor. HTH Ignatius _________________________ ----- Original Message ----- From: "Dan Hewins" <dan@xxxxxxxxxxx> To: <php-db@xxxxxxxxxxxxxxxxxxx@lists.php.netphp-db@xxxxxxxxxxxxx> Sent: Friday, January 16, 2004 16:28 Subject: Re: multi-language site > This is true. And another aspect I forgot to mention is an admin > version of the whole site because the user wants to be able to update > and change text in either the English or Spanish site. This way I only > have to build (design, code HTML) the site once and then I essentially > have four different sites (English, Spanish, Admin-Eng, Admin-Esp). > > A separate question is this: where are the good resources for XML on > the web? > > Thanks. > > Dan > > > On Jan 16, 2004, at 4:18 AM, <lists@xxxxxxxxxxxxxxxxxxxxxx> wrote: > > > The advantage of doing it the way Dan describes is that it is > > very easy to set up an admin tool for the person doing the translating. > > Dan can fill up the English half of the db, and then write a > > page that queries the db for any empty Spanish entries, displays > > them in a select box, and allows the translator to enter the > > Spanish text in to the db. This way, when new English text is > > added, all the translator has to do is check the page, the new > > phrases will automatically be displyed. > > > > The translator doesn't need any knowledge of HTML, and doesn't > > need to involve any other person to upload the text. > > > > Maybe this can be done with XML as well, I don't know. But we > > recently used this system for a English/French site I worked > > on and it worked very well. > > > > -Lisi > > > > = = = Original message = = = > > > > Forgive me if this is pedestrian or has been covered before. > > I'm new > > to the list and I haven't used PHP too much (yet). > > > > Here's my question: > > > > I'm looking to use PHP for an upcoming site project where the > > site > > needs to be in either English or Spanish. Would PHP be a good > > approach? > > I was envisioning having a database with every text bit and image > > with > > text in it in two columns, one for English, and one for Spanish. > > Then > > each web page would reference some kind of global variable (a > > cookie?) > > to determine whether to pull the images and text from the English > > > > column or the Spanish column. Does this sound like a good approach? > > Is > > PHP capable of something like this? > > > > Thanks for any help or suggestions you can give. > > > > Dan Hewins > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > ___________________________________________________________ > > Sent by ePrompter, the premier email notification software. > > Free download at http://www.ePrompter.com. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
