Request for Combining Multilingual WordPress Websites via Database Table

Job ID: 38155013

Budget: €30 – €250 EUR

I am managing a network of WordPress websites, each catering to different languages and hosted on separate domains and databases. Here are the websites:

English: www.example.com
French: www.example.fr
Spanish: www.example.es
Russian: www.example.ru
Arabic: www.example.me

Each website has around 1500 subpages. For instance:

www.example.com/about-us
www.example.fr/a-propos-de-nous
www.example.es/Sobre-nosotras
www.example.ru/о-нас
www.example.me/معلومات-عنا

I would like to integrate these websites so that a visitor can easily switch between languages and be redirected to the corresponding page in the selected language. For example:

If a user is on www.example.com/about-us and selects French, they should be redirected to www.example.fr/a-propos-de-nous.
Similarly, selecting Spanish should redirect to www.example.es/Sobre-nosotras, and so forth.

To achieve this without using a language plugin, I am considering a solution using a database table that maps URLs across different languages, like that:

id english_url french_url spanish_url russian_url arabic_url
1 /about-us /a-propos-de-nous /Sobre-nosotras /о-нас /معلومات-عنا
2 /contact /contact /Contacto /контакт /
Related categories: PHP JavaScript MySQL Database Programming