I'm building a theme and I have a custom page template with a
<form> which is for the vistors to fill in and submit. I'm processing the data with help from hooks and this is all separated from the template file.
I've come to the moment where I have to save the data to the database. What are the best practises when it comes to saving custom form data for a theme developer? I'm expecting at least a thousand of form submissions and about ten different field data to be saved.
- Create a separate db table and use $wpdb to save/retrieve data
- Create a custom post and create an entry for every form submission
- Something way smarter (up to you)