database

How to save EXIF metadata in WordPress database?

I’ve got the help from a guru on other forum. The following code add fields ‘City’ and ‘Location name’ to attachment edit page. Their values gets from IPTC metadata (Tag: 90, Key: Iptc.Application2.City / Tag: 27, Key: Iptc.Application2.LocationName) and automatically save it in db on image upload (Custom fields: ‘city‘ and ‘locationname‘). The values can … Read more

optimal taxonomy or custom post types

You can create custom taxonomies and attach them with woo-commerce products. (https://developer.wordpress.org/reference/functions/register_taxonomy/) you can use the following plugin to create custom taxonomies if you are not familiar with coding: https://wordpress.org/plugins/custom-post-type-ui/ later use plugin like this to import taxonomy terms https://wordpress.org/plugins/bulkpress/

Storing user’s data on external database on other server

You can connect to multiple databases using the wpdb class, see https://developer.wordpress.org/reference/classes/wpdb/. From there you can do something like this: $mydb = new wpdb(‘username’,’password’,’database’,’localhost’); $rows = $mydb->get_results(“select field from my_table”); I’m not sure about changing the structure off storing the users to a different database. You may want to copy the users tables to a … Read more

Native timestamp on wp_options option

There’s no “updated” column in the wp_options table. mysql> describe wp_options; +————–+—————–+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +————–+—————–+——+—–+———+—————-+ | option_id | bigint unsigned | NO | PRI | NULL | auto_increment | | option_name | varchar(191) | NO | UNI | | | | option_value | longtext … Read more

+ More