table configuration

  • Resolved massimo86massimo

    (@massimo86massimo)


    10 years, 6 months ago

    Hello,
    I have a problem with the table structure (cf7dbplugin_submits in database).

    I need to load fields in Contact Form 7 with the values of fields already insert (if they exist), and I would take them directly from the database in the table used to storage them via phpMyAdmin (cf7dbplugin_submits).

    My problem is here. There is one row for field, instead I would have one row for all the fields of the specific Form.

    I need to have each fields in the columns of table, and I wouldn’t have a column named “name_field” with the name of the specific field, and an other column named “value_field” with the value of that field.

    I hope to have been clear. This because I have to catch all the fields with some specific value in a key field..

    Thank you so much..

    https://www.ads-software.com/plugins/contact-form-7-to-database-extension/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    I don’t clearly understand what you are asking. You can create a MySQL “VIEW” that makes the data appear as one row per submission. (The same as it appears in the administration page).

    – In the CFDB Options page, set “Show the query used to display results” to “true”
    – Navigate to your form results in the administration page
    – Copy the query that appears there
    – In MySQL execute: “CREATE VIEW your_form_name ” followed by the query.
    – Then you can query your_form_name as a table. (But you can’t load data).

    I don’t know if that answers your question.

    Thread Starter massimo86massimo

    (@massimo86massimo)

    Perfect! Thank you so much

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

Tags