Noby

<p>The “Meta Functions Shortcode” Plugin installs the Shortcode ‘meta’. With it you can access the custom fields of your articles by a simple shortcode.</p>
<p>Shortcode Syntax: <code>[meta func="" name="" alt=""]</code></p>
<p>The shortcode has three functions yet:</p>
<ol>
<li>func=”url”<br />
  Displays a link using your custom field in “name” as the link target and “alt” as the caption. If “alt” is empty the link target is used as the caption.</li>
<li>func=”plain”<br />
  Simply displays the custom field in “name” as plain text. If the field is empty it displays the text in “alt”.</li>
<li>func=”img”<br />
  Inserts the image at the url in your custom field “name” into the article. The “alt” argument is used as the images alternative text attribute.</li>
<li>More functions in later versions of the plugin… Or extend the plugin on your own. See Extending the Plugin (under Other Notes) for details.</li>
</ol>
<h4>Example</h4>
<pre><code>[meta func="url" name="download_url" alt="Download here"]
</code></pre>
<p>This little code in your article displays a link using your custom field “download_url” as the link target and “Download here” as the caption. If you leave the “alt” argument empty then it uses the link target as the caption.</p>
<p>The resulting html code is:</p>
<pre><code><a href='{download_url}'>{alt}</a>
</code></pre>
<h3>Extending the Shortcode</h3>
<h4>Method 1: Hardcoded</h4>
<p>You can extend the plugin by adding the PHP function</p>
<pre><code>function meta_functions_shortcode_{func}($meta, $alt="") {
       return "your desired text or generated html content";
}
</code></pre>
<p>by writing your own plugin file with the function in it. Be sure to replace {func} with your desired function name (will result in the parameter “func” in the shortcode). $meta will be the value of the custom field and $alt the “alt” parameter.</p>
<p>The function should return the text by which the shortcode will be replaced. For example the “_plain” function simply returns $meta or $alt if $meta is empty.</p>
<h4>Method 2: In the admin panel</h4>
<p>This method is more convenient. You can add new functions in the admin panel. For this go to the options page called “Meta Functions Shortcode”.<br />
Here you can enter a new function name, specify parameter names and set the output html code with the parameters.</p>
<p>Example:</p>
<ul>
<li>Function Name: link</li>
<li>Function Parameter Names: link_url, link_caption</li>
<li>Function Result Code: <code><a href='{link_url}'>{link_caption}</a></code> </li>
</ul>
<p>If you now enter the shortcode [meta func=”link” link_url=”download_url” link_caption=”download_caption”] then in the article/page<br />
it will be replaced by <code><a href='contents of custom field download_url'><i>contents of custom field download_caption</i></a></code>.</p>


Meta Functions Shortcode

The “Meta Functions Shortcode” Plugin installs the Shortcode ‘meta’. With it you can access the custom fields of your articles by a shortcode.

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.

Meta Functions Shortcode vs ACF: Fields in Custom Table