WPForms Blog

WordPress Tutorials, Tips, and Resources to Help Grow Your Business

How to Save Your Contact Form Data in WordPress Database

by Shahzad Saeed on May 29, 2017

Want to save your form submissions in your WordPress database? With WPForms, all your entries are stored in two database tables, and you can easily manage your entries from your WordPress dashboard. In this post, we’ll show you how to save your contact form data in your WordPress database, and how to manage your entries from the dashboard.

How Entries are Stored in the Database

WPForms store all form data in two tables within the native WordPress database. They are:

  • wp_wpforms_entries: In this table, the field values for entries are stored.
  • wp_wpforms_entry_meta: This table contains meta information about your entries such as IDs associated and the date that entries were submitted.

Most web hosting providers offer easy to use web applications like phpMyAdmin to manage databases. It allows users to manage their database using a web-based graphical interface.

Let’s take a look at how to view form entries in your WordPress database using phpMyAdmin.

In phpMyAdmin, select your WordPress database and then, click on the table, wp_wpforms_entries.

database table

You can find the form entries in the fields column.

fields column-wordpress database

For more reference, you can read this beginner’s guide to WordPress database management with phpMyAdmin.

How to Manage Entries in WordPress

WPForms allows you to easily access your form entries and manages them inside your WordPress dashboard.

Let’s take a look at how to manage your form entries.

Before we get started, let’s create a simple contact form with WPForms. If you need help, you can refer to this article on how to create a simple contact form with WPForms.

After publishing the form, make sure to add a form entry, so we can access the entry from your WordPress dashboard. Additionally, in your form builder, go to Settings » General and make sure that entry storing in WordPress is not disabled.

enable storing form data in wordpress database

Once an entry is added, you can navigate to WPForms » Entries in your WordPress dashboard to access it.

form entries

WPForms allows you to favorite your entries, mark them as read, and even delete the ones you don’t want.

Under the Actions column, click on the View link to view your form entry.

click view entry management

Here’s how an individual entry will look like. See the screenshot below.

individual entry

If you enjoyed this article, you might also want to read our article on how to export WordPress form entries to CSV.

What are you waiting for? Get started with the most powerful WordPress forms plugin today.

If you like this article, then please follow us on Facebook and Twitter for more free WordPress tutorials.

Comments

    1. Hi Kenneth,

      We don’t currently offer the ability to search entries, though this is on our list to consider adding down the road 🙂

      If it helps in the meantime, a quick option is to create a CSV export of entries and run a search within that (you can open the CSV in a spreadsheet program like Excel if that’s easiest).

      I hope that helps! 🙂

  1. Hi!

    For some reason form entries are not displayed in the entry management. I’ve checked that the settings are correct and data should be stored. I checked our site database through phpAdmin and it seems that the “wp_wpforms_entries” is named wp_7_wpforms_entries should the table be renamed?

    Thanks for your help!

    1. Hi Sam,

      A quick thing to try is toggling the activation of the WPForms plugin (deactivating it, then reactivating it). Though pretty rare, every once in a while when a WordPress plugin is activated something doesn’t connect quite right. If that doesn’t do the trick, please contact us in support and we’ll work to troubleshoot this as quickly as possible 🙂

      Also, the datatable name isn’t necessarily a concern, as some sites will alter the prefixes of all tables in their WordPress database as a security measure. If you’re curious, you can see how this is done in this WPBeginner article.

      I hope this helps! 🙂

  2. Hi,
    i like your plugin but one question before purchase.
    i want to store the submitted data into my own database table.
    How can i achieve this?

    1. Hi Azhar,

      It may be possible to do what you’re describing, however we aren’t able to provide support for the use of custom/alternative database tables.

      If you have any other questions, could you please let us know? Thanks! 🙂

  3. I’m ussing the Lite version of the plugin.
    I want to check the entries in my forms but I cannot find those tables in the database. Is there a reason because i don’t see them?

    1. Hi Fernando,

      I’m sorry for any confusion over that — WPForms Lite isn’t able to store entries to the database, and entry details are only stored in the notification email that’s sent out.

      If you decide to upgrade to one of our licenses down the road, the datatables mentioned here will be created and new entries will start being stored there. If you have any suggestions on how we can better clarify this from our current notice in Lite, please let us know.

      Thanks! 🙂

  4. Hi

    I love your plugin but have only used the Lite version so far for a client site.
    I would like to discuss purchasing the Basic option with them as I need to have a record in WordPress of each submission made via the Contact Form. We are having issues with form entries not coming through. I have added a SMTP option but need the records as well o make sure we capture everything.

    Can you please confirm that the above sample where entries are added to WPForms » Entries are part of this Basic package?

    Thank you.

    1. Hi Simone,

      Yes, that’s correct. While WPForms Lite entries are stored only in the notification email that’s sent, all of our paid licenses will store entries to your site’s database as described in this article.

      In case it helps, we’ve recently published a guide to entries that provides tons of details on entry storage and related features.

      I hope this helps! If you have any other questions, please let us know 🙂

  5. I love your plugin but have only used the Lite version so far.
    I have no record of each submission made via the Contact Form. I am having issues with form entries not coming through. I have added a SMTP option but need the records. Should I contact my emailer’s support system to try and retrieve them or are they gone forever

    1. Hi Maya,

      I’m sorry to hear you’re seeing issues with email delivery. Unfortunately unless these emails were sent to spam, the email provider will most likely have no record of them.

      If you need any help getting your SMTP option set up to ensure that all future entries deliver successfully, though, we’d be happy to help — please just let us know in our WPForms Lite support forum.

Add a Comment

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our privacy policy, and all links are nofollow. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.