Flamingoのデータベース確認
Contact Form 7 関連プラグイン
データ登録先
下記に登録されている。
テーブル：wp_posts
post_type：’flamingo_inbound’
確認SQL
select
id,
post_author,
post_date,
post_date_gmt,
post_content,
post_title,
post_excerpt,
post_status,
comment_status,
ping_status,
post_password,
post_name,
to_ping,
pinged,
post_modified,
post_modified_gmt,
post_content_filtered,
post_parent,
guid,
menu_order,
post_type,
post_mime_type
comment_count
from wp_posts
where post_type = 'flamingo_inbound'
#where post_name = 'test-116'
\G;
実際に登録されているか確認する。
wp_posts 確認SQL
select * from wp_posts where post_name = 'test-116' \G;
mysql> select * from wp_posts where post_name = 'test-116' \G;
*************************** 1. row ***************************
ID: 8989
post_author: 0
post_date: 2021-09-11 21:39:42
post_date_gmt: 2021-09-11 12:39:42
post_content: (★ここが登録内容)
post_title: test
post_excerpt:
post_status: publish
comment_status: closed
ping_status: closed
post_password:
post_name: test-116
to_ping:
pinged:
post_modified: 2021-09-11 21:39:42
post_modified_gmt: 2021-09-11 12:39:42
post_content_filtered:
post_parent: 0
guid: /?post_type=flamingo_inbound&p=8989
menu_order: 0
post_type: flamingo_inbound
post_mime_type:
comment_count: 0
1 row in set (0.00 sec)
ERROR:
No query specified
post_id からmeta情報を確認する。
wp_postmeta 確認SQL
select meta_id, post_id, meta_key from wp_postmeta where post_id = 8990;
mysql> select meta_id, post_id, meta_key from wp_postmeta where post_id = 8990;
+---------+---------+------------------------+
| meta_id | post_id | meta_key |
+---------+---------+------------------------+
| 79691 | 8990 | _form |
| 79692 | 8990 | _mail |
| 79693 | 8990 | _mail_2 |
| 79694 | 8990 | _messages |
| 79695 | 8990 | _additional_settings |
| 79696 | 8990 | _locale |
| 79747 | 8990 | _config_errors |
| 79748 | 8990 | _wp_cf7pdf |
| 79749 | 8990 | _wp_cf7pdf_fields |
| 79750 | 8990 | _wp_cf7pdf_fields_scan |
確認SQL
mysql -u root -p -h localhost wordpress -e "select * from wp_postmeta where post_id = 8990 and meta_key = '_form';"
★mysql -u root -p -h localhost wordpress -e "select id, post_name, post_content from wp_posts where post_type = 'flamingo_inbound';"
DBからFlamingoの登録データを取得している箇所のコード
./wp-content/plugins/flamingo/admin/admin.php
749 $post = new Flamingo_Inbound_Message( $post_id );
meta情報を確認
post_idで確認
select meta_id, post_id, meta_key from wp_postmeta where post_id = '9016';
post_idとmeta_keyで確認１
mysql> select meta_id, post_id, meta_key, meta_value from wp_postmeta where post_id = '9016' and meta_key = '_field_select1';
+---------+---------+----------------+----------------------+
| meta_id | post_id | meta_key | meta_value |
+---------+---------+----------------+----------------------+
| 79895 | 9016 | _field_select1 | a:1:{i:0;s:3:"有";} |
+---------+---------+----------------+----------------------+
1 row in set (0.00 sec)
post_idとmeta_keyで確認２
mysql> select meta_id, post_id, meta_key, meta_value from wp_postmeta where post_id = '9016' and meta_key = '_field_mail';
+---------+---------+-------------+----------------+
| meta_id | post_id | meta_key | meta_value |
+---------+---------+-------------+----------------+
| 79878 | 9016 | _field_mail | admin@test.com |
+---------+---------+-------------+----------------+
1 row in set (0.00 sec)
post_idとmeta_keyで確認３
mysql> select meta_id, post_id, meta_key, meta_value from wp_postmeta where post_id = '9016' and meta_key = '_field_corp';
+---------+---------+-------------+-------------------------+
| meta_id | post_id | meta_key | meta_value |
+---------+---------+-------------+-------------------------+
| 79879 | 9016 | _field_corp | a:1:{i:0;s:6:"個人";} |
+---------+---------+-------------+-------------------------+
1 row in set (0.00 sec)
