There are multiple ways to do this:
1. Add multiple columns to the table with the strings you have to localize. E.g. one column for German, one for English, and so on. And then get the string from the appropriate column. This is perfect if the number of languages stays more or less constant (you have to change the DB for every new language).
2. Add a translation table, with language, lockup and translation columns. So for every string you’ll have multiple rows (one for each translation). This is good if the amount of languages changes/should be configurable.
3. Instead of the table solution, you could also lookup your string in a .po file.
But all of those need a little work and you have to have the option to change the way your db strings are read.
Related Posts:
- What is the difference between an ORM and an ODM?
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- Checking if Database Table exists
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- Is it possible to define two databases for one installation?
- Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
- Connect forms in WP to external database
- Hook into $wpdb
- Syncing local content with development / staging sites
- Export WP database for import using WP-CLI on Vagrant Box
- Is it wise to delete post revisions and autosaves from database?
- Improve or optimize a very slow query
- What is the advantage of separating wp_users and wp_usermeta table?
- “MySQL server has gone away” since update to 3.8
- WordPress page title repeated in SOME pages
- Why is $wpdb->get_results failing on certain tables but not others (which have data)?
- Usage of Direct Database Call Without Caching Error
- How to correctly add a table to the WordPress MySQL database
- MySQL Syntax Error upon restoring database from backup [closed]
- Help running a MySQL query to update all wp_#_options tables in a Multisite install
- Merge two databases: OLD SITE -> NEW SITE
- Is it safe to convert tables from MyISAM to InnoDB?
- Backup another database with BackUpWordPress plugin [closed]
- Easiest Way to Authenticate WP Users Using an External DB?
- Use one WordPress database with multiple instances of one site
- Who is responsible for data sanitization in WordPress development?
- How do I properly update the WordPress database password?
- How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
- $wpdb->insert is not working
- WordPress Install and Database on separate hosting?
- Moving a site from a temporary domain to the live domain [duplicate]
- How do I find out the full path of a page’s template?
- I need to get an array from the wordpress database
- Moving minor updates between local and live sites – just database?
- what is the best way to store user created data?
- WP get stuck with a query on MySQL when the site is resumed
- Using GROUP CONCAT in my-sql query with wp_usermeta table
- “The link you followed has expired” & “Error while saving” messages when adding new post
- input data and output table [closed]
- How to move the WordPress site Layout from test site to Production site?
- Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- Retrieve data from the database to table such as comments in the admin control panel
- Need to store custom user information (many-many relationsips), preferably not as user meta
- charset problem with new custom table
- WordPress and user security
- How to share plugin created database tables between two WordPress sites
- How to connect to a remote database in WordPress?
- Migrating from PDO using SQLite to clean new install using MySQL
- Change WordPress URL in sql file via Terminal
- $wpdb->insert Giving duplicates
- Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
- Where is phpMyAdmin inside WordPress?
- What can I do when an outside party hacks into my weblog and changes my display name?
- How to properly check if a table exists in WordPress Database using Show Tables Query
- How to delete database without using any plugin?
- Cannot restore wordpress database from sql dump [closed]
- WooCommerce: remove sample & dummy data
- Is database deleted on clicking “reinstall” button in WordPress updates?
- WordPress localization – gettext and git
- Fill custom select field with pages/post titles
- Is my way to change WordPress server is correct?
- Recovering the table wp_usermeta from users
- WordPress database products structure
- I cannot find the difference between these wp_capabilities values in wp_usermeta
- Files on Localhost, Database on Server
- Is there any way to monitor a MySQL db and check what has changed?
- DB prefix not updating
- Any other way of storing plugin admin data setting
- Will memcached improve performance with WP Super Cache already running?
- Error establishing a database connection – WordPress setup, everything else is working
- Restore of database doesn’t show content
- Why theme settings lost when I installed https
- WordPress site migration – locked out of admin area
- WordPress users table missing indexes
- unable to use my wordpress site after moving
- How to add download link from database on custom page template?
- WordPress URL error for links
- Search and Replace in Windows XAMPP site
- How to get the id of recently registered user from database?
- How can i syn wordpress user table with a stand-alone php script?
- insert data from a form:: Warning Empty query mysqli::query()
- Db connection problem on Azure Since database moved on CLEARDB
- Cloned site not connecting to database – MAMP
- How can we speed up wp_get_nav_menu_items()?
- Mysql Queries per Visit – Crazy High
- Send data to database after redirect (and popping out of iframe)
- Simple email input store in database
- Pulling values from a sepcific row in table
- import (migration) user database to wp-users
- Create hundreds of users with just ID in phpMyAdmin
- What is best for saving lot of extra detail of user?
- Insert Extra fields added in the front end registration form to DB
- $wpdb->insert not working for last select option
- How to create a table [closed]
- Upload wordpress from localhost to 000webhost
- SQL query to rewrite all media URLs to end with .webp
- Many images in wp-content/uploads folder that are not in Media Library
- Order of search results based off of a backend custom field and also in alpha order
- How to find fresh (last modified) and sql backup?