Hi
Sorry this got a bit long, but I have a meeting in a few weeks with a new client that has a current website that needs an overhaul.
The only difference to what we've worked on before is that they have a multiple country choice on their current website. Basically you can click a flag at the top and it does domain.com/en or /fr or /de etc and then the styling changes and the images in the template changes, but the main body is pretty much the same. I can do the colour setup and background images by faking the css in the htaccess and have a php file output it.
In actual fact only the French version of the navigation and the main body is translated, the rest come up in English which means you have the same content at different addresses which isn’t brilliant but hopefully once they get the new site they’ll make more of an effort to get it translated.
Anyway normally I setup site like this to have single pages recorded in the database so like /services/ would have a record in the db for the word services that could be pulled out. And then something like news would have the news page the same way, but an additional db of news items which would work from news/news-title/news-id/
Basically I'm trying to work out the best way of not having to create a whole new set of records every time they add another language. I want to be able to add a new section and the system be able to associate various texts with that section through the use of lookup tables.
I think I know how I'm going to do it so it doesn't end up cornering me, but I was wondering if anyone had any experience of this and had any tips?
Thanks
Sorry this got a bit long, but I have a meeting in a few weeks with a new client that has a current website that needs an overhaul.
The only difference to what we've worked on before is that they have a multiple country choice on their current website. Basically you can click a flag at the top and it does domain.com/en or /fr or /de etc and then the styling changes and the images in the template changes, but the main body is pretty much the same. I can do the colour setup and background images by faking the css in the htaccess and have a php file output it.
In actual fact only the French version of the navigation and the main body is translated, the rest come up in English which means you have the same content at different addresses which isn’t brilliant but hopefully once they get the new site they’ll make more of an effort to get it translated.
Anyway normally I setup site like this to have single pages recorded in the database so like /services/ would have a record in the db for the word services that could be pulled out. And then something like news would have the news page the same way, but an additional db of news items which would work from news/news-title/news-id/
Basically I'm trying to work out the best way of not having to create a whole new set of records every time they add another language. I want to be able to add a new section and the system be able to associate various texts with that section through the use of lookup tables.
I think I know how I'm going to do it so it doesn't end up cornering me, but I was wondering if anyone had any experience of this and had any tips?
Thanks