Stores ACF custom fields in a custom table instead of WordPress core meta tables.
This ACF plugin makes it possible to store ACF data in structured database tables instead of WordPress core meta tables.
It uses ACF’s acf/update_field_group
hook to create/update the database and then uses acf/save_post
hook to store the data.
It was heavily inspired by Austin Ginder’s post https://anchor.host/acf-custom-fields-stored-in-custom-table/.
You can contribute to this plugin by submit PR/Issue in https://github.com/eduardo-marcolino/acf-fields-in-custom-table.
This plugin supports the following relational field types: Post Object, Page Link, Relationship, Taxonomy and User.
It can store both single and multiple values based on the multiple
option.
bigint(20) unsigned
You can query relational fields with multiple values using using MySQL’s function JSON_CONTAINS.
Here is an example:
Table:
+---------+-------------------+--------+ | post_id | title | stores | +---------+-------------------+--------+ | 1 | Lord of the Flies | [1,2] | | 2 | The Island | [2] | | 3 | 1984 | [3] | +---------+-------------------+--------+
Query:
SELECT * FROM wp_acf_books WHERE JSON_CONTAINS(stores, 2, '$')
The query above will return “Lord of the Flies” and “The Island”.
This plugin was tested with ACF 5 FREE Version .
Setting up ACF: Fields in Custom Table is very simple. Follow these easy steps
/wp-content/plugins/
directory;Yes. It supports custom post types and built in types of post and page
The value will be stored in the core meta tables instead of the custom table
Yes. It supports custom post types and built in types of post and page
The plugin provides filters to allow developers to customize the plugin behavior.
Please access the documentation to get the list of it.