I have a database with the column names as id(Auto Increament), name an

  • aniket
    Asked on June 10, 2020 at 11:42 PM

    I have a database with the column names as id(Auto Increament), name and address.

    i want the query that it can update or insert using the same button.

    it also has a search button, but i am not able to search it. could you please help me

    thank you

  • John Support Team Lead
    Replied on June 11, 2020 at 2:10 AM

    Hello Aniket - The method discussed in the guide only sends the submission data to the database. So if you want to query from the said database, I think it should be done outside Jotform.

    Now, if you mean you want to check the database for an existing data that matches the submission data, and if there is, you want to only update the record instead of adding a new one, I believe there is a custom PHP code provided for that here: How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP . Please refer to STEP 4 on what code to use.