Title: ACF: Fields in Custom Table Author: Eduardo Marcolino Published: 26 Novembre 2020 Last modified: 26 Maggio 2021 --- Ricerca i plugin ![](https://ps.w.org/acf-fields-in-custom-table/assets/banner-772x250.png?rev=2426457) Questo plugin **non è stato testato con le ultime 3 versioni principali (major releases) di WordPress**. Potrebbe non essere più mantenuto, o supportato, e potrebbe presentare problemi di compatibilità se utilizzato con versioni più recenti di WordPress. ![](https://ps.w.org/acf-fields-in-custom-table/assets/icon-256x256.png?rev=2426457) # ACF: Fields in Custom Table Di [Eduardo Marcolino](https://profiles.wordpress.org/eduardomarcolino/) [Scarica](https://downloads.wordpress.org/plugin/acf-fields-in-custom-table.0.5.zip) * [Dettagli](https://it.wordpress.org/plugins/acf-fields-in-custom-table/#description) * [Recensioni](https://it.wordpress.org/plugins/acf-fields-in-custom-table/#reviews) * [Installazione](https://it.wordpress.org/plugins/acf-fields-in-custom-table/#installation) * [Sviluppo](https://it.wordpress.org/plugins/acf-fields-in-custom-table/#developers) [Supporto](https://wordpress.org/support/plugin/acf-fields-in-custom-table/) ## Descrizione 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/](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](https://github.com/eduardo-marcolino/acf-fields-in-custom-table). #### Supported Fields * Text * Text Area * Number * Range * Email * URL * Password * Image * File * Wysiwyg Editor * oEmbed * Select * Checkbox * Radio Button * Button Group * True / False * Date Picker * Date Time Picker * Time Picker * Color Picker * Link * Post Object * Page Link * Relationship * Taxonomy * User #### Relational Fields 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. * If it’s a single value field, then the column type will be `bigint(20) unsigned` * If it’s a multiple value field, then the column type will be longtext and the date will be stored in json format. You can query relational fields with multiple values using using MySQL’s function [JSON_CONTAINS](https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html#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”. #### ACF Compatibility This plugin was tested with _ACF 5 FREE Version_ . ## Screenshot [⌊Enabling ACF: Fields in Custom Table⌉⌊Enabling ACF: Fields in Custom Table⌉[ Enabling ACF: Fields in Custom Table ## Installazione Setting up ACF: Fields in Custom Table is very simple. Follow these easy steps 1. Upload the plugin to your `/wp-content/plugins/` directory; 2. Activate the plugin in your WordPress admin; 3. Go to the Custom Fields > Field Groups menu, edit or create a field group and enable ACF: Fields in Custom Table option; ## FAQ ### This plugin supports custom post types? Yes. It supports custom post types and built in types of post and page ### What happens if I use unsupported field? 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 ### What are the plugin filters and actions ? The plugin provides filters to allow developers to customize the plugin behavior. Please [access the documentation](https://github.com/eduardo-marcolino/acf-fields-in-custom-table#filters) to get the list of it. ## Recensioni ![](https://secure.gravatar.com/avatar/8d8f1ddfd3304bdfbbf417c5ce90bd336f79c268672ae83156914a554f4010bb? s=60&d=retro&r=g) ### 󠀁[You Save my Life](https://wordpress.org/support/topic/you-save-my-life-2/)󠁿 [erluckhy](https://profiles.wordpress.org/erluckhy/) 18 Gennaio 2022 Thank You for this awesome Plugin. ![](https://secure.gravatar.com/avatar/0b9b83b25e16a089082824c706cd674681ef9068c04f465fc1733f60907827cc? s=60&d=retro&r=g) ### 󠀁[One free solution that work for store acf to custom tables!](https://wordpress.org/support/topic/one-free-solution-that-work-for-store-acf-to-custom-tables/)󠁿 [bijakas](https://profiles.wordpress.org/bijakas/) 21 Aprile 2021 This is amazing plugin with the features that some people is looking for creating custom table for acf storage. Thanks for your effort and giving it for free ! [ Leggi tutte le recensioni di 2 ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/) ## Contributi e sviluppo “ACF: Fields in Custom Table” è un software open source. Le persone che hanno contribuito allo sviluppo di questo plugin sono indicate di seguito. Collaboratori * [ Eduardo Marcolino ](https://profiles.wordpress.org/eduardomarcolino/) [Traduci “ACF: Fields in Custom Table” nella tua lingua.](https://translate.wordpress.org/projects/wp-plugins/acf-fields-in-custom-table) ### Ti interessa lo sviluppo? [Esplora il codice](https://plugins.trac.wordpress.org/browser/acf-fields-in-custom-table/) segui il [repository SVN](https://plugins.svn.wordpress.org/acf-fields-in-custom-table/), segui il [log delle modifiche](https://plugins.trac.wordpress.org/log/acf-fields-in-custom-table/) tramite [RSS](https://plugins.trac.wordpress.org/log/acf-fields-in-custom-table/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 0.5 * Added filter acfict_table_prefix to customize table prefix * Added setting for allow user to disable table prefix usage * Testing on WordPress 5.7 #### 0.4 * Small performance improvement and testing on WordPress 5.6 #### 0.3 * Added support for the following field types: Link, Post Object, Page Link, Relationship, Taxonomy and User #### 0.2 * Added support for the following field types: Range, Image, File, oEmbed, Checkbox, Radio Button, Date Time Picker, Time Picker * Using dbDelta function to modify table #### 0.1 * First version of the plugin released ## Meta * Versione **0.5** * Ultimo aggiornamento **5 anni fa** * Installazioni attive **80+** * Versione WordPress ** 4.9.0 o superiore ** * Testato fino alla versione **5.7.19** * Versione PHP ** 7.0 o superiore ** * Lingua * [English (US)](https://wordpress.org/plugins/acf-fields-in-custom-table/) * Tag * [acf](https://it.wordpress.org/plugins/tags/acf/)[advanced custom fields](https://it.wordpress.org/plugins/tags/advanced-custom-fields/) [custom fields](https://it.wordpress.org/plugins/tags/custom-fields/)[fields](https://it.wordpress.org/plugins/tags/fields/) [meta](https://it.wordpress.org/plugins/tags/meta/) * [Visualizzazione avanzata](https://it.wordpress.org/plugins/acf-fields-in-custom-table/advanced/) ## Valutazioni 5 su 5 stelle. * [ 2 recensioni a 5-stelle ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/?filter=5) * [ 0 recensioni a 4-stelle ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/?filter=4) * [ 0 recensioni a 3-stelle ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/?filter=3) * [ 0 recensioni a 2-stelle ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/?filter=2) * [ 0 recensioni a 1-stelle ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/?filter=1) [La tua recensione](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/#new-post) [Vedi tutte le recensioni](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/) ## Collaboratori * [ Eduardo Marcolino ](https://profiles.wordpress.org/eduardomarcolino/) ## Supporto Hai qualcosa da dire? Ti serve aiuto? [Chiedi nel forum di supporto](https://wordpress.org/support/plugin/acf-fields-in-custom-table/) ## Dona Vuoi supportare lo sviluppo di questo plugin? [ Fai una donazione per questo plugin ](https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=TW8LTG6J7XVP2&item_name=Donation+for+Wordpress+Plugin¤cy_code=USD)