Building an email signup form. Where should the information be saved in the DB?

There are multiple storage mechanisms in WP so it can be bit tricky to pick one and sometimes there is no single right choice.

Let’s examine your criteria for storage:

  • persistent (you don’t want data just evaporating)
  • processable (you want to export it and probably navigate)
  • simple to implement (you don’t want go building something (semi)custom just for the heck of it)
  • extensible (in case you want to capture more data down the road and such)

As for me the best storage to satisfy these condition would be using custom post type. It comes with a lot of functionality out of the box (like admin interface), requires no messing with storage (custom tables or whatever) and is perfectly suited to store arbitrary information in custom fields.

Related Posts:

  1. How to Add an Index to Plugin Database table
  2. Creating two database tables via plugin
  3. How does WordPress handle MySQL row lock errors?
  4. WordPress register_activation_hook table creation not working
  5. Default Plugin Settings Not Writing to Database
  6. Plugin Options Not Saving to Database in WP 4.5
  7. How to create custom tables in WordPress using my own plugin?
  8. Is it possible to create Custom Post plug-in?
  9. Help With MySQL to WPDB Query Conversion
  10. Prevent duplicate records in plugin table
  11. WordPress Backend HA (Automatic failover)
  12. How can I change the meta_key for a particular piece of information?
  13. Can I create a table on my DB without creating a plugin?
  14. WordPress : Explain Plugins & Theme string value in database
  15. Is it necessary to auto delete my WP plugin database tables when users deactivate/delete my plugin?
  16. How to insert and call new data in wordpress website database through a plugin
  17. WPDB: Update table
  18. Issue running db create table query from static method
  19. Separate database for a wordpress plugin
  20. Best/Correct way to add an option to a category
  21. What is the WordPress approach to custom data?
  22. How to create plugin/ page that reads from database
  23. DB Query not working in Plugin
  24. Comment “like” problem – “users who like this” avatar linking to current user profile instead of “liker’s” profile
  25. WordPress plugin: efficient way to store large data
  26. Integrating Custom Database with WordPress
  27. How to display results from a data table with an encrypted user id?
  28. How to make a Product page without ordering and database
  29. I want to schedule email (date, time is in database->table) wp_schedule_event() not working
  30. How to securely controlling data without keeping it in postmeta?
  31. $wpdb->insert not working inside save_post tag
  32. Where do the section input fields values are stored in database
  33. My plugin can’t see my files
  34. how can i get records from wp_postmeta table using particular meta_key in database?
  35. Create New Admin Menu Section – Like how custom post type works, in a way
  36. Creating fields in the database
  37. How to submit the custom form data in database in WordPress without plugin?
  38. get_option returning a different value from what’s saved
  39. How can I delete the options from DB when the plugin is deleted?
  40. register_activation_hook not working
  41. On the same site, how do I send data from a plugin file to a theme file?
  42. plugin doesn’t retrieve data from database
  43. Edit plugin without hooks in functions.php
  44. How to find out if option exists but is empty?
  45. Is dynamic forms/entries possible in Widget?
  46. Trigger a custom wordpress plugin with a linux cron
  47. update_meta_user difference in i:1 and b:1, how to write b:1
  48. Add_rewrite_rule doesn’t add custom url in plugin
  49. How to add inline css/js inside a shortcode
  50. Is this plugin being loaded before file.php, subsequently not allowing me to use certain functions?
  51. Ajax with jQuery UI dialog not working
  52. How do I write into a file (css)
  53. How to periodically scrape and cache strings from remote txt files. – My First Plugin
  54. why doesn’t this update part of this plugin work? it take me to nothing here page
  55. Using a custom plugin to capture input data via Ajax and PHP
  56. Display post lists in 2nd paragraph
  57. Session destroyed on page redirect
  58. Is there a way to test that readme looks in other language before submitting translation?
  59. Create tabs in admin options page from custom post type loop
  60. ob_start() combined with wp_query
  61. How can I remove the WordPress-Version (?ver=5.x) from my plugin
  62. Settings API saved values not getting shown in the dropdownbox
  63. populating a form field with output from a custom plugin function
  64. Custom Login Page — wp_signon Headers Already Sent?
  65. Why Does The `auto_update_plugin` Hook Disable Management?
  66. Is there a way to add custom endpoint to specific page only
  67. IF condition based on wp_remote_get output
  68. Add User Role: Pre-saved in User-Meta [SOLVED]
  69. Is there a script to collect all hooks and filters provided by a plugin?
  70. How WordPress core manage the plugin installation
  71. Post status doesn’t update to ‘future’ every time?
  72. Storing The Data Collected by Ninja Forms into Another (custom) Database [closed]
  73. count the number of views of a post excluding own views
  74. How to set Google Analytics tracking code on WordPress plugin directory page?
  75. Show Custom Post on Frontend
  76. Problem with checked box on wp car manager plugin
  77. Performing CRUD operations on front end in wordpress
  78. Create a link that calls our custom function in WordPress
  79. WordPress Ajax request “Failed to load resource: the server responded with a status of 400 ()”
  80. Load my Inline js footer area
  81. Remove action added in plugin class from theme
  82. wc_get_product_terms() throws “Notice: Undefined offset: 0”
  83. Woocommerce list variations that are added already to cart in Single Product
  84. WordPress Admin sub-level menu issue
  85. How do I add a textarea (multirow) option to my WordPress plugin?
  86. Passing ajax variable to more than one wordpress plugin function
  87. HyperDB failover Delay
  88. Why isn’t my plugin seeing other classes?
  89. How to add jquery to my custom post type wp plugin
  90. Update post meta not working on wp_postmeta
  91. Check if user is in a group of another site within multisite network [closed]
  92. Redirect url in plugin to somewhere else?
  93. wp_insert_post_data filter to set category
  94. is there a way I can add or remove some plugin options?
  95. What can I do to customize a widget provided with this plugin? from where have I to start?
  96. add_meta_box showing blank screen in my page
  97. Use inline callable for hooks and filters
  98. Error in using ‘admin_enqueue_scripts’ action through a class
  99. Edit a page/post DB data?
  100. How do i fix this error?