WPForms Blog

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

How to Save Your Contact Form Data in WordPress Database

Last updated on May 10, 2017 by Shahzad Saeed

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. Thanks for reading this article – I hope you found it helpful.

    I wanted to let you know about our new WordPress survey plugin that allows you to build interactive polls and surveys within minutes. You also get best-in-class reporting, so you can make data-driven decisions.

    You can get it 100% free when you purchase WPForms Pro plan.

    Get Started with WPForms Today and see why over 1 million websites choose WPForms as their preferred online form builder.

    Syed Balkhi
    CEO of WPForms

    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! 🙂

  2. 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! 🙂

  3. 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! 🙂

  4. 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! 🙂

  5. 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 🙂

  6. 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.

  7. I would like to see more of the fields in entries page without having to click “view” on each entry. Is there an option of how many fields or which fields to show there?

  8. Hi! Is there a way to export only certain entries to a csv-file instead of all of them at once? Selecting only some of them and then exporting doesn’t seem to work. This is actually crucial to being able to use your product. We have the basic version, I think.

    1. Hi Juuli,

      We don’t currently have a way to select just a few entries for a CSV export, but I agree this would be super useful and it’s on our list of features to consider in the future. I’ve added your vote to that feature request as well. Thanks for the suggestion 🙂

      On the chance that it’s helpful, it is possible to export individual entries to CSV.

      And if you have any other questions, please feel welcome to get in touch with our support team 🙂

  9. Hello, I have WPforms in paid version, I need to use the database to show the records of a form to its user, however, in the table ENTRIES only gives the record in a format. I need to give the user his records of a form.
    Please have information on the use of the database

  10. The code {all_fields} seems only to deliver the name in the notification email.
    If the contact form doesn’t save the data, and the email only contains the name of the
    subscriber, not the rest of the contact page, of what use is WP_Forms free version?

    1. Hi Vince,

      I’m sorry for the trouble, and that’s definitely odd. The {all_fields} Smart Tag should include any field (field label and input value) that the user fills out, just as you’re expecting. This behaves the same way for both Lite and paid versions.

      When you get a chance, please drop us a line in support so we can assist. We provide limited complimentary support in the WPForms Lite WordPress.org support forum.

      Thanks 🙂

  11. Hello,
    Kindly is there anyway to make the form rtl?
    I tried to add it as css feature,but nothing is changed.
    Looking forward your response please.
    Also another question,I’ll be able to retrieve the data in the database to use it for some coding normally?
    Best Regards

  12. hello ,

    I want to try to display the data collected from the form to a table in the site.
    A have a form with a dropdown and a paragraph. In the database there are two same entries but with different entry_id and cannot connect it to wp_datatable. Any ideas?

    1. Hi Antreas,

      I apologize as we’re not able to provide support for custom code. However in case it helps, we do have a developer doc that discusses how to display form entries in a table (you can find that here).

      I hope the tutorial helps! If you have any other questions, please know that you can receive faster and more in-depth support through our private support for paid license holders. Thanks! 🙂

  13. Thanks for the info!

    I have followed the guide in full and the one you see in this course [URL removed], but the steps of the manual installation are different.

    Any advice?

    Thanks!

    1. Hi Esther,

      I apologize, but I don’t understand your question. This blog post is about database storage for WPForms, but it sounds like you’d like to know about installation. When you get a chance, could you please get in touch with our team with some extra details on what you’re looking to do? We’ll be able to assist further from there.

      Thanks! 🙂

  14. Hello! I just found out that the email for notifications was misspelled and have not received notifications for the last month! I am using wp forms light. Is there any way to recover this information??

    1. Hi Emilia,

      In our Lite version, entry details are stored only to the notification email that’s sent – so unfortunately we don’t have a way to recover these previous entries for you. Though it may be a long shot, you could try reaching out to your site’s hosting provider to find out if they keep a log of emails sent out from your site.

      I apologize that we’re not able to help further with this! For future entries/forms, I’d recommend going through our pre-launch checklist. This will help to ensure things go smoothly moving forward.

      And in case it helps, we provide limited complimentary support for all of our Lite users over in our support forum. So if you have any questions about Lite, we’d be happy to assist from there 🙂

    1. Hi Emmanuel,

      Our plugin doesn’t allow for existing form field HTML to be modified, as that would create a lot of potential concerns for functionality. However, you can add HTML within our HTML field (to add images, etc), as well as add your own custom CSS or even some JavaScript.

      Any custom code like this, though, will not be saved with the entry.

      I hope this helps! If you have any additional questions, please get in touch! 🙂

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.