SQL database format

  • tpaul25

    (@tpaul25)


    11 years ago

    Love this plugin. However, while I can see the data listed by Field name in Columns in the Contact Form to DB area on WordPress, when I go into SQL database into the Submit table, the field names are all listed under the “Field_Name” Column. I would Like the individual Field Names to be their own columns and the data listed underneath the individual Field Names. How can I get this to happen?

    ex: I have First Name, Last Name and Age. In the Contact Form DB area in the Admin, I see
    First Name Last Name Age
    John Smith 50

    This is what I want.

    In the SQL database, under the submit table, it’s listed like this:

    FieldName Value
    First Name John
    Last Name Smith
    Age 50

    How can I make this change?

    Thanks,

    Tracy

    https://wordpress.org/plugins/contact-form-7-to-database-extension/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter tpaul25

    (@tpaul25)

    11 years ago

    Just to add to this: I know I could do a pivot query but that won’t due as it will slow processes down. I want a way for the form submissions to feed directly to the database structured above without having to do that query. Any way to do that other than revamping the plugin? (which I am not talented enough to do)

    Thanks!

    Plugin Author Michael Simpson

    (@msimpson)

    11 years ago

    If you want to save the data into your own table structure then you would have to write code for that.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘SQL database format’ is closed to new replies.