Eduardo Marcolino

<p>This ACF plugin makes it possible to store ACF data in structured database tables instead of WordPress core meta tables.</p>
<p>It uses ACF’s <code>acf/update_field_group</code> hook to create/update the database and then uses <code>acf/save_post</code> hook to store the data.</p>
<p>It was heavily inspired by Austin Ginder’s post <a href="https://anchor.host/acf-custom-fields-stored-in-custom-table/" rel="nofollow ugc">https://anchor.host/acf-custom-fields-stored-in-custom-table/</a>.</p>
<p>You can contribute to this plugin by submit PR/Issue in <a href="https://github.com/eduardo-marcolino/acf-fields-in-custom-table" rel="nofollow ugc">https://github.com/eduardo-marcolino/acf-fields-in-custom-table</a>.</p>
<h4>Supported Fields</h4>
<ul>
<li>Text</li>
<li>Text Area</li>
<li>Number</li>
<li>Range</li>
<li>Email</li>
<li>URL</li>
<li>Password</li>
<li>Image</li>
<li>File</li>
<li>Wysiwyg Editor</li>
<li>oEmbed</li>
<li>Select</li>
<li>Checkbox</li>
<li>Radio Button</li>
<li>Button Group</li>
<li>True / False</li>
<li>Date Picker</li>
<li>Date Time Picker</li>
<li>Time Picker</li>
<li>Color Picker</li>
<li>Link</li>
<li>Post Object</li>
<li>Page Link</li>
<li>Relationship</li>
<li>Taxonomy</li>
<li>User</li>
</ul>
<h4>Relational Fields</h4>
<p>This plugin supports the following relational field types: Post Object, Page Link, Relationship, Taxonomy and User.</p>
<p>It can store both single and multiple values based on the <code>multiple</code> option.</p>
<ul>
<li>If it’s a single value field, then the column type will be <code>bigint(20) unsigned</code></li>
<li>If it’s a multiple value field, then the column type will be longtext and the date will be stored in json format.</li>
</ul>
<p>You can query relational fields with multiple values using using MySQL’s function <a href="https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html#function_json-contains" rel="nofollow ugc">JSON_CONTAINS</a>.<br />
Here is an example:</p>
<p>Table:</p>
<pre><code>+---------+-------------------+--------+
| post_id |       title       | stores |
+---------+-------------------+--------+
|       1 | Lord of the Flies | [1,2]  |
|       2 | The Island        | [2]    |
|       3 | 1984              | [3]    |
+---------+-------------------+--------+
</code></pre>
<p>Query:</p>
<pre><code>SELECT * FROM wp_acf_books WHERE JSON_CONTAINS(stores, 2, '$')
</code></pre>
<p>The query above will return “Lord of the Flies” and “The Island”.</p>
<h4>ACF Compatibility</h4>
<p>This plugin was tested with <em>ACF 5 FREE Version</em> .</p>


ACF: Fields in Custom Table

Stores ACF custom fields in a custom table instead of WordPress core meta tables.

Matt Gibbs

<p>Custom Field Suite (CFS) lets you add custom fields to your posts. It’s lightweight and battle-tested (there’s not much to break).</p>
<h4>Things to know</h4>
<ul>
<li>We do not provide support.</li>
<li>This is a free plugin. We’re not selling anything.</li>
<li>CFS includes 14 <a href="https://mgibbs189.github.io/custom-field-suite/field-types.html" rel="nofollow ugc">field types</a>. There are no plans to add more.</li>
<li>If you want all the bells-and-whistles, use ACF.</li>
</ul>
<h4>Field types</h4>
<ul>
<li>Text</li>
<li>Textarea</li>
<li>WYSIWYG</li>
<li>Date</li>
<li>Color</li>
<li>True / False</li>
<li>Select</li>
<li>File Upload</li>
<li>Relationship</li>
<li>Term</li>
<li>User</li>
<li>Loop (repeatable fields)</li>
<li>Hyperlink</li>
<li>Tab (group fields)</li>
</ul>
<h4>Usage</h4>
<ul>
<li>Browse to the “Field Groups” admin menu</li>
<li>Create a Field Group containing one or more custom fields</li>
<li>Choose where the Field Group should appear, using the Placement Rules box</li>
<li>Use the <a href="https://mgibbs189.github.io/custom-field-suite/api/get.html" rel="nofollow ugc">get</a> method in your template files to display custom fields</li>
</ul>
<h4>Links</h4>
<ul>
<li><a href="https://mgibbs189.github.io/custom-field-suite/" rel="nofollow ugc">Documentation <span aria-hidden="true" class="wp-exclude-emoji">→</span></a></li>
<li><a href="https://github.com/mgibbs189/custom-field-suite" rel="nofollow ugc">Github <span aria-hidden="true" class="wp-exclude-emoji">→</span></a></li>
</ul>


Custom Field Suite

CFS()->get() - не работает, возвращает пустой массив, CFS()->get() === array()
по Id работает

ACF: Fields in Custom Table vs Custom Field Suite