Scott Reilly

This plugin provides a powerful widget, shortcode (with shortcode builder tool), and template tags for easily retrieving and displaying custom field values for posts or pages.
The power of custom fields gives this plugin the potential to be dozens of plugins all rolled into one.
This plugin allows you to harness the power of custom fields/meta data. Use the “Get Custom Field” widget, the <code>[custom_field]</code> shortcode (which has a post editor sidebar widget to help you build the shortcode), or one of six template tags to retrieve and display custom fields. Find a custom field for the current post, a specified post, a recent post, or randomly. And for the custom field values found by the plugin, you may optionally specify text or HTML to appear before and after the results. If nothing is found, then nothing is display (unless you define text to appear when no results are found). If multiple results are found, only the first will be displayed unless you specify a string to be used to join the results together (such as “,”), in which case all will be returned. Visit the Examples section to see how this plugin can be cast in dozens of different ways.
There are six template tags provided by this plugin. Here they are, with an explanation of when they are appropriate for use:
<ul>
<li><code>c2c_get_custom()</code> : Use this inside “the loop” to retrieve a custom field value for a post</li>
<li><code>c2c_get_current_custom()</code> : This is only available on the permalink post template (single.php) and page template (page.php). Can be used inside or outside “the loop”. Useful for using custom field to define text you want to include on a post or page’s header, footer, or sidebar.</li>
<li><code>c2c_get_post_custom()</code> : Useful when you know the ID of the post whose custom field value you want.</li>
<li><code>c2c_get_random_custom()</code> : Retrieve the value of a random instance of the specified custom field key, as long as the field is associated with a published posted, non-passworded post (you can modify a setting in the plugin file to search passworded posts as well).</li>
<li><code>c2c_get_random_post_custom()</code> : Retrieves the value of random custom field(s) from a post when you know the ID of the post you’re interested in.</li>
<li><code>c2c_get_recent_custom()</code> : Retrieves the most recent (according to the associated post’s publish date) value of the specified custom field.</li>
</ul>
You can filter the custom field values that the plugin would display. Add filters for ‘<code>the_meta</code>‘ to filter custom field data (see the end of the code file for commented out samples you may wish to include). You can also add per-meta filters by hooking ‘<code>the_meta_$sanitized_field</code>‘. <code>$sanitized_field</code> is a clean version of the value of <code>$field</code> where everything but alphanumeric and underscore characters have been removed. So to filter the value of the “Related Posts” custom field, you would need to add a filter for ‘<code>the_meta_RelatedPosts</code>‘.
Links: <a href="https://coffee2code.com/wp-plugins/get-custom-field-values/" rel="nofollow ugc">Plugin Homepage</a> | <a href="https://wordpress.org/plugins/get-custom-field-values/" rel="ugc">Plugin Directory Page</a> | <a href="https://github.com/coffee2code/get-custom-field-values/" rel="nofollow ugc">GitHub</a> | <a href="https://coffee2code.com" rel="nofollow ugc">Author Homepage</a>
<h3>Developer Documentation</h3>
Developer documentation can be found in <a href="https://github.com/coffee2code/get-custom-field-values/blob/master/DEVELOPER-DOCS.md" rel="nofollow ugc">DEVELOPER-DOCS.md</a>. That documentation covers the numerous template tags, hooks, and shortcode provided by the plugin.
As an overview, these are the template tags provided the plugin:
<ul>
<li><code>c2c_get_custom()</code> : Template tag for use inside “the loop” and applies to the currently listed post.</li>
<li><code>c2c_get_current_custom()</code> : Template tag for use on permalink (aka single) page templates for posts and pages.</li>
<li><code>c2c_get_post_custom()</code> : Template tag for use when you know the ID of the post you’re interested in.</li>
<li><code>c2c_get_random_custom()</code> : Template tag for use to retrieve a random custom field value.</li>
<li><code>c2c_get_random_post_custom()</code> : Template tag for use to retrieve random custom field value(s) from a post when you know the ID of the post you’re interested in.</li>
<li><code>c2c_get_recent_custom()</code> : Template tag for use outside “the loop” and applies for custom fields regardless of post.</li>
</ul>
These are the hooks provided by the plugin:
<ul>
<li><code>c2c_get_custom_field_values_shortcode</code> : Filter to customize the name of the plugin’s shortcode.</li>
<li><code>c2c_get_custom_field_values_post_types</code> : Filter to customize the post types that should support the shortcode builder metabox.</li>
<li><code>get_custom_field_values/can_author_use_shortcodes</code> : Filter to customize if post author can make use of the ‘custom_field’ shortcode.</li>
<li><code>get_custom_field_values/show_metabox</code> : Filter to customize if the shortcode builder metabox is shown.</li>
</ul>
The shortcode provided is <code>[custom-field]</code>, which has a number of attributes to customize its behavior and output.

Get Custom Field Values

Use widgets, shortcodes, and/or template tags to easily retrieve and display custom field values for posts or pages.

Eduardo Marcolino

This ACF plugin makes it possible to store ACF data in structured database tables instead of WordPress core meta tables.
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.
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>.
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>.
<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>
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 <code>multiple</code> option.
<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>
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>. 
Here is an example:
Table:
<pre><code>+---------+-------------------+--------+
| post_id | title | stores |
+---------+-------------------+--------+
| 1 | Lord of the Flies | [1,2] |
| 2 | The Island | [2] |
| 3 | 1984 | [3] |
+---------+-------------------+--------+
</code></pre>
Query:
<pre><code>SELECT * FROM wp_acf_books WHERE JSON_CONTAINS(stores, 2, '$')
</code></pre>
The query above will return “Lord of the Flies” and “The Island”.
<h4>ACF Compatibility</h4>
This plugin was tested with ACF 5 FREE Version .

ACF: Fields in Custom Table

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

Get Custom Field Values vs ACF: Fields in Custom Table