Best way to input PHP form into WP/Database?

  • thetoolman123

    (@thetoolman123)


    5 years, 5 months ago

    Hi there,

    I have some survey/questionnaire forms that are in PHP and use local storage to create results.

    What I would like to do is to have these forms inputted into a spreadsheet. I am thinking of doing this in two ways – maybe having the forms insert into a database and then output as a spreadsheet, or just have them go straight into the spreadsheet.

    However, I need the spreadsheet to be live so I can edit offline and then upload it again to have the new data.

    Can anyone tell me the best way to do this. Are there any plugins that would do this or would it have to all be custom?

    Any ideas would be great, thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    5 years, 5 months ago

    I believe Google Sheets has an API where content can be added via remote HTTPS request. (verify) To keep your API key secret, you may need to relay answers through your server.

    Alternately, keep the data in the DB and use SQL queries to do whatever it is you intended to do on a spreadsheet. While exporting/importing spreadsheet data is feasible, the extra steps involved are more opportunities for things to go wrong. You should strive to send the data to where it ultimately resides with as few intermediate steps as possible.

    Thread Starter thetoolman123

    (@thetoolman123)

    5 years, 5 months ago

    Thanks for the reply.

    I am currently creating the database so I may come back for some help with the spreadsheet side.

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

The topic ‘Best way to input PHP form into WP/Database?’ is closed to new replies.