how do you retrieve a form with the information in it and updating the

  • Profile Image
    Nyameko Yabo
    Asked on October 15, 2012 at 10:18 AM

    how do you retrieve a form with the information in it and updating the information on the database using php



    This is a re-post of a comment on How to send Submissions to Your MySQL Database Using PHP

  • Profile Image
    Deygus
    Answered on October 15, 2012 at 10:53 AM

    I apologize but I'm not quite sure what you are asking since your question seems to match the guide which pretty much explains it already.

    What are you having trouble with in this that needs clarification?

  • Profile Image
    liyam
    Answered on October 15, 2012 at 11:20 AM

    Hello.  The post data submission going to your database is designed to somehow mirror the submissions you have received via JotForm.

    You will need to find the edit link of your form (which you can normally include on your email alert) to be able to make edits and push the updates going to your database. 

    If in case you don't have the edit link and you wish to get to edit old submissions:

    1. Get your form ID. The form ID is a long string of numbers that's usually at the end of your form's URL. To get your form's URL, click the Preview button while editing the form.

    2. Get the submission ID that you want to edit by going to your submissions page and get the submission ID from the grid list.  The column name is ID

    3. Once you have the Submission ID, and also the Form ID, you can now create your edit link.  Here is an example:

    https://www.jotform.com/form.php?formID=123456&sid=12345678&mode=edit

    Where as you should replace the form ID with your actual form ID, as well as the sid (submission ID) with your actual submission id.  Do not forget to add the &mode=edit at the end

    Please let us know if you need further assistance.