read table wpforms_db

  • Resolved kirilb

    (@kirilb)


    1 year, 4 months ago

    I have WPforms lite and wpforms db to store data form the form entries. It is stored in a weird format. Do you have ready sql to dissolve the column prefix_wpforms_db.form_value and to store it in separate columns?

    It looks like this:

    a:5:{s:16:”WPFormsDB_status”;s:4:”read”;s:9:”Your Name”;s:14:”My Name”;s:5:”Email”;s:15:”[email protected]”;s:33:”Column 1″;s:49:”Content of Column 1″;s:8:”Column 2″;s:4:”Content of Column 2″;}

    • This topic was modified 1 year, 4 months ago by kirilb.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Ralden Souza

    (@rsouzaam)

    Hi @kirilb,

    Thanks for reaching out!

    WPForms Lite does not store form submissions in WordPress, though you can certainly set up form notification emails to send form submission details to your preferred email address(es).

    So, when you mention that you have “wpforms db”, I’m assuming that you’re using a third-party plugin to save entries using WPForms Lite. In this case, you could contact the plugin’s author/support team to share the details of the issue, as we’re not able to provide support for third-party plugins.

    Please also note that we have the Lite Connect option available which allows you to backup all the entries after enabling this option while using the Lite version and restore then if you ever decide to upgrade to the paid version.

    I hope this helps!

    Thread Starter kirilb

    (@kirilb)

    I found the answer: https://coderwall.com/p/edl9ha/how-to-unserialize-data-using-mysql-without-using-php

    • This reply was modified 1 year, 4 months ago by kirilb.
    Plugin Support Ralden Souza

    (@rsouzaam)

    Hi @kirilb,

    Great to hear that you found a solution, and thanks for sharing it here!

    It looks like you’ve marked this post as resolved. If you’d like more help with using WPForms Lite, please feel free to reach out.

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘read table wpforms_db’ is closed to new replies.