Posted by Steve on 10/12/06 13:20

that's ok. your english is *far* better than my german or dutch. ;^)

what database are you going to use? what web server? what version of php?
are you using your own server or one hosted by someone else?


"Frits van Leeuwen" <Frits.vanLeeuwen@nospam.nl> wrote in message
news:caa50$452dee9a$c2ab6db8$21970@news1.tudelft.nl...
| wow, big answare... thanks.
| No the most of the text does not change many times.
| I try to build a website. Before I did it with Front Page, but now I need
| PHP I think. But I have so little experience with PHP, so I need Help. Now
i
| have a PHP page. But 3 times a text where I think 1 time is enough. I like
| to change it. But I do not know how.
| I know, I can do it with a DB, before I need 1 good looking page.
| My first start was the language chooice. Now I like the posebilety to
change
| my texts ones. (not 3 times)
| I think I can link the page to a text. But when I know how to create and
use
| a DB I like to use the DB.
| I can not use MYSQL.
|
| My English is not so well, I'm sorry for it. So I need time read and
| understand your help.
|
|
| "Steve" <no.one@example.com> schreef in bericht
| news:SPeXg.3238$%l1.3162@newsfe07.lga...
| > sorry for the text-wrapping...
| >
| > i'll try. you may have better luck with the hundreds of resources on the
| web
| > though.
| >
| > what kind of content will you have? does it change much?
| >
| > anyway, for starters your code should define constants for either
sections
| > of text that are static or phrases (like in error messages). that way
when
| > programming, you refer to the constant which elimenates language (except
| for
| > php) altogether. ex.:
| >
| > define('ERROR_INVALID_DATA_TEXT', 45);
| > define('EMAIL', 53);
| >
| > if (!isEmail($email)){ echo translate($language,
| > array(ERROR_INVALID_DATA_TEXT, EMAIL)); }
| >
| > 45 and 53 would refer to the db id of the item in a translation table.
| > translate(...) is a function you'd create that simply to query the db
and
| > return the appropriate text.
| >
| > if you have php 5, you can make this much more friendly.
| >
| > ========
| >
| >
| > class errors
| > {
| > static const $invalidData = 45;
| > }
| >
| > class phrases
| > {
| > // constants here to define individual phrases
| > }
| >
| > class words
| > {
| > static const $email = 53;
| > }
| >
| > class language
| > {
| > private $_currentLanguage;
| > static function setLanguage($language){ $this->_currentLanguage =
| > $language; }
| > static function translate($id, $concat = null)
| > {
| > if (!is_array($id)){ $id = array($id); }
| > $text = array();
| > foreach ($id as $toText)
| > {
| > // get text from db from id supplied
| > $text[$id] = record['VALUE']; // ficticious record object from db
| > }
| > if (!$concat){ return $text; }
| > return implode($concat, $text);
| > }
| > }
| >
| > ======
| >
| > if (!isEmail($email)){ echo
language.translate(array(errors::$invalidData,
| > words::$email), true); }
| >
| > anyway, an OO approach allows you segement and refer to language id's in
a
| > grouped and ordered fashion rather than trying to achieve the same thing
| > with VERY LONG define names...plus, they can be static so that you don't
| > have to explicitly create an instance of each of them.
| >
| > again, try and keep everything segmented - from code, html, and
language.
| it
| > then becomes more manageable. the first thing i'd create is a front-end
| for
| > the db translation table so that you can integrate the defined table
| > constants and change them automatically as you update your table...
| >
| > let's say you define things in code as i have done...error text,
phrases,
| > and individual words. i chose these because the a word in one language
by
| > itself may look totally different when it is in a phrase. and a phrase
| that
| > is imphatic may be worded *entirely* differently that the tone of a
| warning
| > or error. the other thing to consider is gender...which most languages
| have
| > (i didn't account for it in the translate(...) function example, but you
| get
| > the gist). here's what my translation table would look like:
| >
| > create table language
| > {
| > id int null auto_increment primary ,
| > varName varchar(255) not null ,
| > lang int not null , // assume your
| > supported langs. in other linked table
| > type enum('error', 'phrase', 'word' not null , // mysql assumed
and
| > not sure of syntax
| > gender int not null , // assume genders
in
| > other linked table
| > value text
| > }
| > on primary;
| >
| > i think from that, you can figure out the query for the translate(...)
| > function. as for auto-updating the errors, phrases, words...make each a
| > require_once page. after an entry in this table is updated from your
| > maintenance web page, have php query the db and output the data to file
so
| > that the output is actually php language itself for each varName and id
| > returned from the query. for you as a programmer, you'll need to make
sure
| > that an email is automatically generated so that the change is
| > announced...especially if you work on a team of developers.
| >
| > anyway, that's the bulk of it as briefly and precisely as i can get
here.
| > i18n is a huge topic of discussion. it is covered by many, many, MANY
| > approaches...this is just a basic way to cover the bases.
| >
| > hope that gets you started.
| >
| >
| >
| > "Frits van Leeuwen" <fleeuwen@wanadoo.nlx> wrote in message
| > news:452d6cfb$0$13688$dbd4b001@news.wanadoo.nl...
| > | You are right. That's why I asking for help.
| > | So, can you help me step by step to fix a DB for my text?
| > |
| > | "Steve" <no.one@example.com> schreef in bericht
| > | news:10dXg.196$di5.75@newsfe06.lga...
| > | > your architecture is all wrong. separate the language from the html
as
| > | > much
| > | > as possible. either store a page's content in a db or in it's own
file
| > for
| > | > each language you intend to support...or keep each language in its
own
| > | > directory and redirect to that directory as a virtual server. you
| cannot
| > | > hope to be able to maintain one page of code showing all language
| > versions
| > | > between switch statements.
| > | >
| > | > look for 'programming i18n' on google to shorten the learning curve.
| > | >
| > | > hope that helps.
| > | >
| > | >
| > | > "Frits van Leeuwen" <fleeuwen@wanadoo.nlx> wrote in message
| > | > news:452d5699$0$45649$dbd4f001@news.wanadoo.nl...
| > | > | Hello,
| > | > | I have index.php and language.php
| > | > | At index.php are buttons for choose language.
| > | > | In language I set a cookie and go back to index.php. (I'm happy,
| it's
| > | > | working)
| > | > |
| > | > | But index.php has too match text I think.
| > | > | In the following code, I show you "**** English text ****" and
| > | > "****Dutch
| > | > | text ****" thise are all the same texts. The difrence is the
| language.
| > | > But
| > | > | when you look to the code, You will see 3 times Enlis text and 3
| times
| > | > Dutch
| > | > | text. I think it has to be one time for both of them.
| > | > |
| > | > | This is index.php
| > | > |
| > | > | <?php
| > | > | if (isset($_COOKIE["LeeuwendeelTaal"]))
| > | > | {
| > | > | switch ($_COOKIE["LeeuwendeelTaal"])
| > | > | {
| > | > | case "EN": // ENGLISH
| > | > | ?>
| > | > | <html>
| > | > | <head>
| > | > | <title>Begin Leeuwendeel.info</title>
| > | > | </head>
| > | > | <body link="#0000FF" vlink="#800080" alink="#00FFFF"
text="#FF0000"
| > | > | bgcolor="#FFFFE1">
| > | > | <div align="center">
| > | > | <table border="1" width="100%" id="table1" style="border-width:
0px"
| > | > | height="530">
| > | > | <tr>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | **** English text ****
| > | > | </td>
| > | > | <td rowspan="1" style="border-style: none; border-width: medium">
| > | > | <p align="right"><img border="0"
| src="images/underconstruction.gif"
| > | > | width="480" height="379"></p>
| > | > | </td>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | <!--vlag NL-->
| > | > | <p align="right"><a href="/language.php?ln=NL"><img border="0"
| > | > | src="knoppen/vlagNL.jpg" width="33" height="20" alt="Klik hier,
| > wanneer
| > | > u
| > | > de
| > | > | site in het Nederlands wilt lezen."></a></p>
| > | > | <!--vlag EN-->
| > | > | <p align="right"><a href="/language.php?ln=EN"><img border="2"
| > | > | src="knoppen/vlagEN.jpg" width="33" height="20" alt="Click here,
| when
| > | > you
| > | > | like to read the website in English."></a></p>
| > | > | </td>
| > | > | </tr>
| > | > | </table>
| > | > | </div>
| > | > | <p align="center"><font size="1">Last change:
| > | > |
| > | > | <?php
| > | > | break; // einde ENGLISH
| > | > |
| > | > | case "NL": // NEDERLANDS
| > | > | ?>
| > | > | <html>
| > | > | <head>
| > | > | <title>Begin Leeuwendeel.info</title>
| > | > | </head>
| > | > | <body link="#0000FF" vlink="#800080" alink="#00FFFF"
text="#FF0000"
| > | > | bgcolor="#FFFFE1">
| > | > | <div align="center">
| > | > | <table border="1" width="100%" id="table1" style="border-width:
0px"
| > | > | height="530">
| > | > | <tr>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | **** Dutch text **** </td>
| > | > | <td rowspan="1" style="border-style: none; border-width: medium">
| > | > | <p align="right"><img border="0"
| src="images/underconstruction.gif"
| > | > | width="480" height="379"></p>
| > | > | </td>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | <!--vlag NL-->
| > | > | <p align="right"><a href="/language.php?ln=NL"><img border="2"
| > | > | src="knoppen/vlagNL.jpg" width="33" height="20" alt="Klik hier,
| > wanneer
| > | > u
| > | > de
| > | > | site in het Nederlands wilt lezen."></a></p>
| > | > | <!--vlag EN-->
| > | > | <p align="right"><a href="/language.php?ln=EN"><img border="0"
| > | > | src="knoppen/vlagEN.jpg" width="33" height="20" alt="Click here,
| when
| > | > you
| > | > | like to read the website in English."></a></p>
| > | > | </td>
| > | > | </tr>
| > | > | </table>
| > | > | </div>
| > | > | <p align="center"><font size="1">Laatste wijziging:
| > | > |
| > | > | <?php
| > | > | break;
| > | > |
| > | > | default:
| > | > | ?>
| > | > | <html>
| > | > | <head>
| > | > | <title>Begin Leeuwendeel.info</title>
| > | > | </head>
| > | > | <body link="#0000FF" vlink="#800080" alink="#00FFFF"
text="#FF0000"
| > | > | bgcolor="#FFFFE1">
| > | > | <div align="center">
| > | > | <table border="1" width="100%" id="table1" style="border-width:
0px"
| > | > | height="530">
| > | > | <tr>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | **** Dutch text ****
| > | > | </td>
| > | > | <td rowspan="1" style="border-style: none; border-width: medium">
| > | > | <p align="center"><img border="0"
| src="images/underconstruction.gif"
| > | > | width="480" height="379"></p>
| > | > | </td>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | **** English text ****
| > | > | </td>
| > | > | </tr>
| > | > | <tr>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | <p align="center"><a href="/language.php?ln=NL"><img border="0"
| > | > | src="knoppen/vlagNL.jpg" width="165" height="100" alt="Klik hier,
| > | > wanneer
| > | > u
| > | > | de site in het Nederlands wilt lezen."></a>
| > | > | </td>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | </td>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | <p align="center"><a href="/language.php?ln=EN"><img border="0"
| > | > | src="knoppen/vlagEN.jpg" width="165" height="100" alt="Click here,
| > when
| > | > you
| > | > | like to read the website in English."></a>
| > | > | </td>
| > | > | </tr>
| > | > | </table>
| > | > | </div>
| > | > | <p align="center"><font size="1">Laatste wijziging / Last change:
| > | > |
| > | > | <?php
| > | > | break; // einde geen keuze
| > | > |
| > | > | }
| > | > | }
| > | > |
| > | > | else
| > | > | {
| > | > | setcookie("LeeuwendeelTaal");
| > | > | ?>
| > | > | <html>
| > | > | <head>
| > | > | <title>Begin Leeuwendeel.info</title>
| > | > | </head>
| > | > | <body link="#0000FF" vlink="#800080" alink="#00FFFF"
text="#FF0000"
| > | > | bgcolor="#FFFFE1">
| > | > | <div align="center">
| > | > | <table border="1" width="100%" id="table1" style="border-width:
0px"
| > | > | height="530">
| > | > | <tr>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | **** Dutch text ****
| > | > | </td>
| > | > | <td rowspan="1" style="border-style: none; border-width: medium">
| > | > | <p align="center"><img border="0"
| src="images/underconstruction.gif"
| > | > | width="480" height="379"></p>
| > | > | </td>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | **** English text ****
| > | > | </td>
| > | > | </tr>
| > | > | <tr>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | <p align="center"><a href="/language.php?ln=NL"><img border="0"
| > | > | src="knoppen/vlagNL.jpg" width="165" height="100" alt="Klik hier,
| > | > wanneer
| > | > u
| > | > | de site in het Nederlands wilt lezen."></a>
| > | > | </td>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | </td>
| > | > | <td style="border-style: none; border-width: medium">
| > | > | <p align="center"><a href="/language.php?ln=EN"><img border="0"
| > | > | src="knoppen/vlagEN.jpg" width="165" height="100" alt="Click here,
| > when
| > | > you
| > | > | like to read the website in English."></a>
| > | > | </td>
| > | > | </tr>
| > | > | </table>
| > | > | </div>
| > | > | <p align="center"><font size="1">Laatste wijziging / Last change:
| > | > | <?php
| > | > | }
| > | > | ?>
| > | > |
| > | > | <!--webbot bot="Timestamp" S-Type="EDITED" S-Format="%d-%m-%Y"
| > | > | startspan -->11-10-2006<!--webbot bot="Timestamp"
i-checksum="12558"
| > | > | endspan --></font></p>
| > | > | </body>
| > | > | </html>
| > | > |
| > | >
| >
|| --------------------------------------------------------------------------
| ------
| > | > | Mijn Postvak In wordt beschermd door SPAMfighter
| > | > | 4017 spam-mails zijn er tot op heden geblokkeerd.
| > | > | Download de gratis SPAMfighter vandaag nog!
| > | > |
| > | > |
| > | >
| > | >
| > |
| >
|| --------------------------------------------------------------------------
| ------
| > | Mijn Postvak In wordt beschermd door SPAMfighter
| > | 4017 spam-mails zijn er tot op heden geblokkeerd.
| > | Download de gratis SPAMfighter vandaag nog!
| > |
| > |
| >
| >
|
|
|

[Back to original message]