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

  • Profile Image
    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



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

  • Profile Image
    John
    Answered on June 11, 2020 at 02: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.