You don’t need database tables for that. Form plugins take care of that for you. However, I’m not sure what you mean exactly. Could you describe the example with age in more detail?
Yup, you’re best off using a forms plugin.
However, you may need to write a custom query to handle fetching records with specific criteria like that. Using the wpdb global class can help if you can write it yourself.
I don’t know if there are plugins that allow you to easily add custom database queries, and I suspect there aren’t many options. Being able to filter records this way may be one of the features you need to prioritize when selecting a form plugin though
hi threadi,
My design is that a Form has a few blanks. For example, name, email and age. These three fields will create a table. Members need to fill it.
In the other page, my design is that the table will display the table which contains about merely age >=50 .
which plug-in is suitable for me??
That is entirely feasible. First, you need a custom post type. This is where the data from the form is collected. You can add post types in the following ways:
Now you need a form plugin that can save data from the form in this post type. In principle, this can be done with any plugin, at the latest with individual programming. There are some form plugins for which something like this already exists. Examples:
https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#post-data-field
https://wpforms.com/docs/how-to-install-and-use-the-post-submissions-addon-in-wpforms/
https://wordpress.org/plugins/post-my-contact-form-7/
Here are instructions for custom programming with CF7: https://stackoverflow.com/questions/42076829/contact-form-7-to-custom-post-type
Once you have that, all you need to do is set up the output of your post type data on the website. This depends on which theme and page builder you are working with. Block themes and Elementor offer widgets such as the “query loop” where you can set this up. However, it may also make sense to write a custom shortcode that queries the data records and outputs them as a table. You can find the basics of working with post types (as well as their queries) here: https://developer.wordpress.org/plugins/post-types/working-with-custom-post-types/
If you need personal assistance with this, you can find it here: https://jobs.wordpress.net/