PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Data Storage and manipulation.

  1. WordpressDeveloper
    Member

    Hi,

    I was curious about how Gravity forms Stores data. I was actually lucky enough to be able to view a wordpress site which uses the plugin. However when looking at the MySQL databases in the backend I struggled to find user inputted data. I could see this on the wordpress dashboard and I know a requirement of Gravity forms installation is a MySQL database. However as I am not the original developer of the site I am not sure on the specifics. I assume the tables with the wp_rg_prefix store the meta data of the forms?

    If I created a form named x with a field for email address, which table would store that data specifically? I believe Gravitys backend tables store the data in a more 'meta' fashion and dont create a new table for each new form, rather they do something where all similar types of data are grouped into tables? If I used Gravity forms on a site I created, would I be able to change this?

    I wouldnt be able to do more than just view what the other developer did so I cant test but I thought I would ask here. Eventually I may want to write php code to manipulate the data gathered in through forms, but if the data is stored in such a meta fashion this would be difficult. As you can probably tell im new to wordpress but I am more comfortable with PHP development. My first hurdle is figuring out how Gravity forms store specific bits of data which are user inputted?

    Posted 13 years ago on Thursday October 20, 2011 | Permalink
  2. Yes, the prefix_rg_* tables in the database store all the information about individual forms and entries.

    There is not a new table for each form. Information about each form is stored in _rg_form and _rg_form_meta. There is one record per form in each of those tables. The information stored in the _rg_form_meta table is stored in a serialized array. There's no reason to change this.

    Gravity Forms has a ton of hooks, filters and functions available for getting the data about leads (the entries) and forms out of the database. There's normally no reason to manipulate the database directly.

    Posted 13 years ago on Thursday October 20, 2011 | Permalink