Re: Too match text I think.


"Rik" <luiheidsgoeroe@xxxxxxxxxxx> schreef in bericht
news:55659$45371900$8259c69c$25733@xxxxxxxxxxxxxxxxxxx
linda wrote:
Hi Frits and welcome
to the wonders of php. I too am new to php.

And Frits is battling with the same page since februari this year (or
earlier?)... Not exactly new, but takes on a lot of known difficulties ;-)
Yes, it's a long time. First, I was start in a wrong way and second, I have
not so many time .

To maybe give Frits a few pointers (I do admit I haven't read this thread,
so possibly there's an overlap with other posts/possibly better
solutions):
Sometimes I start a new thread. That's becaurse I'm not sure if someone
helps me in the way i understand and like.

- I use TinyMCE to give users the possibilities to edit pages. Do not try
to let them be translated tag by tag. If the users put a 'chunk' of text
(however formatted) on your page, they should be able to format the other
language equally.
I like to create a database. with texts and users. I know hou to handle a
database, but I do not know how I can use it in php.

- Offcourse, on a dynamic page, there a reason for it's dynamic, and you
have other database fields that have different translations, otherwise
you'd be better of including static html-files.
I like to put a HTML text into a database.

- I created a seperate table for system messages, like 'Login is
incorrect'.
- Determine which fields exactly have to be translated.
- create a table with possible languages, and possibly other info (money
formatting, dns, postal code formatting etc.)
- create a table translations with:
id id of row in specific table of which it is a translation
table table name of text to be translated
field field name of text to be translated
language language identifier
value translation (with or without HTML-markup, that doesn't matter)
I like to do this, but do you know a free database program to do this? What
database program can I use for users and texts?

Thanks for help for so far.
The rest of your help, Rik, is for the next pass. (how to say in good
English?) When I can create a database, I'll learn how to use it in php.

Now, to build your page, first determine what language the user wants. I
use, in order of precedence:
- GET value (often obfuscated in an url, like
http:/example.com/nl/rest/of/path/to/file.php, which is parsed by
mod_rewrite on apache)
- cookie (on a GET value a cookie is set/changed offcourse)
- logged in users preference (on a change in preference offcourse a cookie
is set)
- HTTP header fo accepted languages (not always available for every
browser)
- when possible, trying to determine by referrer or remote adress suffix
what country, and possibly what language, the user prefers.
- is all else false, use default language

Now I set the constant LANGUAGE to preferred language.

On building the rest of the page, I can use queries with the set constant
LANGUAGE that the user prefers. For instance:

mysql_query'("SELECT
x.product_id AS id
IFNULL(y.value,x.name) AS name
IFNULL(z.value,x.desc) AS description
FROM products x
LEFT JOIN translations x
ON x.product_id = y.id
AND y.table = 'products'
AND y.field = 'name'
AND y.lang = '".LANGUAGE."'
LEFT JOIN translations z
ON x.product_id = z.id
AND z.table = 'products'
AND z.field = 'desc'
AND z.lang = '".LANGUAGE."'");

True, your queries are a bit longer, but in most servers the extra time
needed for the query is negligible.

You could even add your own logic to 'degrade' to some languages by
preference as indicated by the user (set a preference per available
language).
--
Grtz,

Rik Wasmus

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
4017 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!


.

Relevant Pages

  • Selecting the next language
    ... languages to write our application in, as Progress is becoming ... Progress is a 4GL language so it is very rapid development. ... We would like to be somewhat database agnostic but we are leaning ... I have seen PHP compilers are they any good. ...
    (comp.lang.php)
  • PHP versus Mason
    ... I am currently evaluating what language I should use to create a web ... having no website nor database set up yet. ... toward PHP as the language for the web application. ... Is Mason better? ...
    (comp.lang.php)
  • Re: PHP versus Mason
    ... having no website nor database set up yet. ... > toward PHP as the language for the web application. ... > something called Mason. ...
    (comp.lang.php)
  • Re: PHP
    ... We require translations for PHP, plz, r, boooks, thanx. ... PHP is the name a language; the name is probably an abbreviation ... of an off-topic post? ...
    (comp.lang.c)
  • Re: Languages Apache ???
    ... I have a portal written in PHP and I need to have it in another language ... Basically, it means a re-write of the PHP application, to allow on-the-fly ... translations of the content of the site. ... server files from different directories dependant on the browser context. ...
    (Fedora)