WHEN SUBMITTING FORM USER SELECT AMOUNT OF $75.

  • Profile Image
    bishopkldavis2
    Asked on July 07, 2019 at 05:31 AM

    WHEN SUBMITTING FORM USER SELECT AMOUNT OF $75.00 WHICH PAYPAL ACCEPTS WITH NO PROBLEMS. AMOUNT IS ENTER INTO PAYPAL, BUT NOT THE DATABASE. ALL THE FIELDS ARE ENTERED INTO THE DATABASE WITH THE EXCEPTION OF (registrationFee).

    URL: https://www.jotform.com/build/90867582341161

    mysql_query("INSERT INTO `registration` (submission_id, formID, ip, studentname, birthdate24, gender, address, studentemail6, mobilenumber, phonenumber25, degreetype, dateregistration, registrationFee)

    VALUES ('" . $submissionData["submission_id"] . "',

    '" . $submissionData["formID"] . "',

    '" . $submissionData["ip"] . "',

    '" . $studentname . "',

    '" . $birthdate24 . "',

    '" . $submissionData["gender"] . "',

    '" . $submissionData["address"] . "',

    '" . $submissionData["studentemail6"] . "',

    '" . $mobilenumber . "',

    '" . $phonenumber25 . "',

    '" . $submissionData["degreetype"] . "',

    '" . $dateregistration . "',

    '" . $submissionData["registrationFee"] . "' ) ") or die(mysql_error());



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

  • Profile Image
    Nik_C
    Answered on July 07, 2019 at 06:25 AM

    Could you please do a test submission but before you do, change your thank you page to this: https://www.jotform.com/show-post-data/

    And post the screenshot of the response:

    https://www.jotform.com/help/438-How-to-Post-Screenshots-to-Our-Support-Forum

    So we can check the structure of the response and if that matches your PHP script.

    We'll wait for your response.

    Thank you!

  • Profile Image
    bishopkldavis2
    Answered on July 09, 2019 at 04:34 PM

    It's working.  Thank you.