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. how to create child WordPress plugin
  44. Plugins or Tutorials for displaying data from SQL-db on WP-page? [closed]
  45. How to Loop Plugin Option Field Set?
  46. How to test a WordPress plugin through the upgrade automatically feature
  47. How to Create a Directory in a Plugin Folder?
  48. Failed to invoke other hook from the init hook
  49. Create plugin that works in background
  50. Checking for user role in a custom plugin
  51. Extend Elementor Archive Posts widget with a custom skin in order to show multiple badges
  52. HELP: Integrating WP with raw PHP code once published button is hit
  53. Custom preview_post_link not working for draft post
  54. wp_enqueue_script fails to include in footer
  55. jQuery function didn’t work in my plugin
  56. How to make Http Request to a php file present in plugin directory of wordpress
  57. Can we use a webservice with WordPress?
  58. WooCommerce get_price returning wrong price when used via ajax
  59. New User Form – Custom Menu Page
  60. Checking instances of scripts in wp_head
  61. How to access data in wordpress database externally using php
  62. How can I prevent my plugin go development trunk [closed]
  63. Best way to maintain and update 3rd-party WP plugin when developer is unresponsive?
  64. Are functions in main plugin file called before function bound to register_activation_hook runs?
  65. Best place for if/else piece of code related to custom plugin?
  66. how to do login using woocommerce rest api From android
  67. How to create a code editor for my plugin .?
  68. Manually set a custom admin sub-menu selected?
  69. How can I remove the WordPress-Version (?ver=5.x) from my plugin
  70. Settings API saved values not getting shown in the dropdownbox
  71. Why Does The `auto_update_plugin` Hook Disable Management?
  72. Is there a way to add custom endpoint to specific page only
  73. Is there a script to collect all hooks and filters provided by a plugin?
  74. Post status doesn’t update to ‘future’ every time?
  75. Unable to give correct path in wordpress
  76. Disable variations on woo commerce if out of stock
  77. How to add img into a plugin?
  78. How to hide plugin submenu title in drop down in admin panel in wordpress?
  79. Show Custom Post on Frontend
  80. WordPress Ajax request “Failed to load resource: the server responded with a status of 400 ()”
  81. Load my Inline js footer area
  82. Remove action added in plugin class from theme
  83. Using multi-dimensional array with filter
  84. WordPress Admin sub-level menu issue
  85. PHP header() not available to use in my plugin
  86. database – multiple wordpress installations using same database – can they share plugin settings?
  87. HyperDB failover Delay
  88. How to insert category name above post title in a featured pages plugin?
  89. Displaying friend’s posts only
  90. How to add submenu to WordPress plugin in the same Directory of main Plugin?
  91. How to add jquery to my custom post type wp plugin
  92. Check if user is in a group of another site within multisite network [closed]
  93. Synch Custom Post Types (and Custom Fields, Cats, etc.) Between WordPress Sites
  94. Redirect url in plugin to somewhere else?
  95. Site is setup statically – how to make it content managable?
  96. Modifying lightbox plugin to allow for quoting, Does this exist? [closed]
  97. How to escape html code?
  98. WordPress custom block: Link saved in database not retrieved when editing post
  99. Accessing Correct Database to Create REST API Endpoint
  100. Detect if user is on the specific page in WordPress