将wp_post元数据的内容移动到表中

Question

The data submitted using forms,are saved into wp_post ,what I need is whenever I receive data through this form,to move these data into a table (moving not copy:to avoid redundancy) in order to be able to use the content in this tsble easily.

How I know how the attributes that are saved,since the form is saved as post meta box,using Ninja form.

Answer 1

Roaa, the ninja forms data is already stored in a table, the table wp_postmeta, keyed by post_id. The post_id is the form id. The form id is from the wp_post table which has an entry for each submission.

See the form submissions under the submissions menu: .../wp-admin/edit.php?post_type=nf_sub This data can be accessed for other means using

1. the wpdb class https://codex.wordpress.org/Class_Reference/wpdb
2. or the wp function https://developer.wordpress.org/reference/functions/get_posts/ using post_ty[e nf_sub, or
3. mysql queries if querying outside of wordpress