Title: ACF: Fields in Custom Table
Author: Eduardo Marcolino
Published: <strong>2020年11月26日</strong>
Last modified: 2021年5月26日

---

プラグインを検索

![](https://ps.w.org/acf-fields-in-custom-table/assets/banner-772x250.png?rev=2426457)

このプラグインは **WordPress の最新3回のメジャーリリースに対してテストされていま
せん**。もうメンテナンスやサポートがされていないかもしれず、最新バージョンの WordPress
で使用した場合は互換性の問題が発生する可能性があります。

![](https://ps.w.org/acf-fields-in-custom-table/assets/icon-256x256.png?rev=2426457)

# ACF: Fields in Custom Table

 作者: [Eduardo Marcolino](https://profiles.wordpress.org/eduardomarcolino/)

[ダウンロード](https://downloads.wordpress.org/plugin/acf-fields-in-custom-table.0.5.zip)

 * [詳細](https://ja.wordpress.org/plugins/acf-fields-in-custom-table/#description)
 * [レビュー](https://ja.wordpress.org/plugins/acf-fields-in-custom-table/#reviews)
 *  [インストール](https://ja.wordpress.org/plugins/acf-fields-in-custom-table/#installation)
 * [開発](https://ja.wordpress.org/plugins/acf-fields-in-custom-table/#developers)

 [サポート](https://wordpress.org/support/plugin/acf-fields-in-custom-table/)

## 説明

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_ .

## スクリーンショット

[⌊Enabling ACF: Fields in Custom Table⌉⌊Enabling ACF: Fields in Custom Table⌉[

Enabling ACF: Fields in Custom Table

## インストール

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.

## 評価

![](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/) 2022年1月18日

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/) 2021年4月21日

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 !

 [ 2件のレビューをすべて表示 ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/)

## 貢献者と開発者

ACF: Fields in Custom Table はオープンソースソフトウェアです。以下の人々がこのプラグ
インに貢献しています。

貢献者

 *   [ Eduardo Marcolino ](https://profiles.wordpress.org/eduardomarcolino/)

[“ACF: Fields in Custom Table” をあなたの言語に翻訳しましょう。](https://translate.wordpress.org/projects/wp-plugins/acf-fields-in-custom-table)

### 開発に興味がありますか ?

[コードを閲覧](https://plugins.trac.wordpress.org/browser/acf-fields-in-custom-table/)
するか、[SVN リポジトリ](https://plugins.svn.wordpress.org/acf-fields-in-custom-table/)
をチェックするか、[開発ログ](https://plugins.trac.wordpress.org/log/acf-fields-in-custom-table/)
を [RSS](https://plugins.trac.wordpress.org/log/acf-fields-in-custom-table/?limit=100&mode=stop_on_copy&format=rss)
で購読してみてください。

## 変更履歴

#### 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

## メタ

 *  バージョン **0.5**
 *  最終更新日 **5年前**
 *  有効インストール数 **80+**
 *  WordPress バージョン ** 4.9.0またはそれ以降 **
 *  検証済み最新バージョン: **5.7.20**
 *  PHP バージョン ** 7.0またはそれ以降 **
 *  言語
 * [English (US)](https://wordpress.org/plugins/acf-fields-in-custom-table/)
 * タグ
 * [acf](https://ja.wordpress.org/plugins/tags/acf/)[advanced custom fields](https://ja.wordpress.org/plugins/tags/advanced-custom-fields/)
   [custom fields](https://ja.wordpress.org/plugins/tags/custom-fields/)[fields](https://ja.wordpress.org/plugins/tags/fields/)
   [meta](https://ja.wordpress.org/plugins/tags/meta/)
 *  [詳細を表示](https://ja.wordpress.org/plugins/acf-fields-in-custom-table/advanced/)

## 評価

 5つ星中5つ星

 *  [  2 5-星レビュー     ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/?filter=5)
 *  [  0 4-星レビュー     ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/?filter=4)
 *  [  0 3-星レビュー     ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/?filter=3)
 *  [  0 2-星レビュー     ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/?filter=2)
 *  [  0 1-星レビュー     ](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/#new-post)

[すべてのレビューを見る](https://wordpress.org/support/plugin/acf-fields-in-custom-table/reviews/)

## 貢献者

 *   [ Eduardo Marcolino ](https://profiles.wordpress.org/eduardomarcolino/)

## サポート

意見や質問がありますか ?

 [サポートフォーラムを表示](https://wordpress.org/support/plugin/acf-fields-in-custom-table/)

## 寄付

このプラグインが今後も改善できるよう応援しませんか ?

 [ このプラグインに寄付 ](https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=TW8LTG6J7XVP2&item_name=Donation+for+Wordpress+Plugin&currency_code=USD)