Preliminary note: ALL projects should require a CLEAR seperation of code and appearance. Now: To do what you describe, if you present your data as a HTML table, I would suggest retrieving data from the DB as an arra, and using the PEAR HTML_Table class to display them. Very easy to learn and extremely powerful. In addition you can use XSLT if the news are stored as XML strings in the DB. HTH Ignatius _________________________ ----- Original Message ----- From: "Muhammed Mamedov" <mmamedov@xxxxxxxxxxxxxxx> To: "Ignatius Reilly" <ignatius.reilly@xxxxxxx>; "phpdb" <php-db@xxxxxxxxxxxxx> Sent: Friday, January 16, 2004 13:57 Subject: Re: multi-language site > Hello Ignatius, > > I am working on a project which requires a CLEAR seperation of code and > appearance. > Think of this: There is a page which lists news from DB in a specific manner > (latest 10 added, and next,prev links on the bottom). Of course this > requires some PHP code which will retrieve data from DB and display it. > Firstly, designers design appearance of the page (in pure HTML/css) and then > coders re-code that page embedding pieces of PHP code. What I want to do is > to make this process as easy as possible for designers/coders. I am familiar > with XML and XSLT, but in "practise" never used XSL to transform XML... > > What do you suggest? > Waiting for your suggestions. > > M.Mamedov > > ----- Original Message ----- > From: "Ignatius Reilly" <ignatius.reilly@xxxxxxx> > To: "Dan Hewins" <dan@xxxxxxxxxxx>; <php-db@xxxxxxxxxxxxx> > Sent: Thursday, January 15, 2004 8:03 PM > Subject: Re: multi-language site > > > > I would not consider a DB-based design. > > > > I use two approaches (sometimes mixed): > > > > 1. Write content in XML files (one per language) and transform them with > > XSLT. This is nice for mostly content-based sites. > > > > 2. Write the complete application in English and translate it with the > > excellent PHP gettext() extension. Makes it fast, efficient and very cheap > > to maintain. A better option for web applications. > > > > In any case the user's language must be stored in a session variable. > > > > HTH > > Ignatius > > > > _________________________ > > ----- Original Message ----- > > From: "Dan Hewins" <dan@xxxxxxxxxxx> > > To: <php-db@xxxxxxxxxxxxx> > > Sent: Thursday, January 15, 2004 18:50 > > Subject: multi-language site > > > > > > > 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 > > > > > > > > > > -- > > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
