Insert/Update Submissions to MySQL Database Question

  • Profile Image
    Xavier
    Asked on April 12, 2013 at 09:50 AM

    Hello,

    I do have a concern as sometime jotform add some figures after the field I created.

    Let say I add an input field name. On the Post I get on my page, the field that correspond to name is [name17]. Which of course cannot be inserted in my Database.

    Of course in my landing page, I could make a script in order to recover the corresponding field but that would not always work

    Do we have a possibility to put another tag for the input field (i want my label = name and the post id will be 'username')



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

  • Profile Image
    Welvin
    Answered on April 12, 2013 at 12:28 PM

    Hi Xavier,

    As far as I know, the names that correspond to each field are not inserted to the database. The tables on the database are manually created. The field names are only used and inserted to the PHP file that you will have to created to match with the database tables.

    Let say;

    Your table name from database is; name

    Your field name is; [name17]

    The codes to PHP file is; $name = $_POST['name17'];


    I hope that I explain this well.

    Thanks

  • Profile Image
    khrisell
    Answered on July 04, 2013 at 11:25 PM
    Greetings!

    We are happy to announce that we have released Jotform Webhooks,  this feature would replace Send Post Data + Custom URL Thank You Page workaround in order to help you transfer forms data to your own database using your own script codes.

    To know more about Jotform Webhooks, please click here.

     

    Thank you for using JotForm. :)

  • Profile Image
     
    Answered on June 09, 2017 at 02:24 AM

    this is cool.