What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How Can I Send Submissions' Data to My Database?

    Asked by mike106 on January 21, 2016 at 10:14 AM

    Below is my Config file (if there is a better way to send you this Config file let me know)

    /***SEE VERSION.TXT***/

    /***All variables need to be filled with your values except custom variables***/

     

     

    /**Number of reminders that will be sent to the subscriber**/

        $number_of_reminders = '2'; 

        

        /**Number of follow-ups that will be sent to the subscriber**/

    $number_of_followups = '1'; 

        

    /**First reminder will start this many days from date of reservation **/

        $reminder_start_days = '3'; 

     

    //Last reminder will be sent this many hours from time of reservation

        $last_reminder_hours = '1';

        

        /**Enter the Business/Advertiser name**/

    $business_name = "Twilight Inn";

        /**Enter the Business/Advertiser email address bizname@bizdomain.com**/

        $business_email = "mike@proweb-online.com"; 

     

    /**Business/Advertiser mobile phone number +15555551212**/

    $business_phone = '+13145605112'; 

     

    /**Yes value for enable No for disable**/

        $enable_business_email_notification = "yes"; 

        

    /**Yes value for enable No for disable**/

        $enable_business_sms_notification = "yes"; 

     

    /***You can use %name% for subscriber name in all messages and subjects**/

    /***You can use %res_date% for subscriber reservation date in all messages and subjects**/

    /***You can use %time% for subscriber reservation time in in all messages and subjects**/

     

    /**Your email subject for Business/Advertiser notification**/

    $business_email_subject  = "Twilight Inn Birthday New Subscriber Notification for %name% on %res_date%";

        

    /**Your email subject for the immediate email sent to subscriber**/

        $immediate_email_subject = "%name%, we received your Twilight Inn Birthday Reservation"; 

        

    /**Your email subject for all followup emails to subscriber**/

        $followup_email_subject  = "Hi %name%, How was your Twilight Inn Birthday visit?";

        

    /**Your email subject for all reminder emails to subscriber**/

        $reminder_email_subject  = "%name%, dont forget about your Twilight Inn Birthday Reservation";

        

        

        /**This text will go immediately to form submitter. Message text must not be greater than 1600 chars**/

    $immediate_text = "Thanks %name%!  This message is to confirm your Twilight Inn Birthday Reservation date is %res_date% at %time%.  We can’t wait to see you and your guest.  Any questions or updates, let us know @ 314.555.1212.  See you soon.";  

        

    /**Reminder text that will be sent to subscriber. Message text must not be greater than 1600 chars**/

    $reminder_text[0] = "Hi %name%! Quick reminder about your Twilight Inn Birthday Reservation: date is %res_date% at %time%"; 

    $reminder_text[1] = "Hi %name%! Quick reminder about your Twilight Inn Birthday Reservation: date is %res_date% at %time%, we are looking forward to seeing you and your guest!"; 

        $reminder_text[2] = "Hi %name%! Quick reminder about your Twilight Inn Birthday Reservation: date is %res_date% at %time%, we are excited to help you celebrate your Birthday!!"; 

        

    /**Follow-up text that will be sent to the subscriber. Message text must not be freater than 1600 chars**/

        $followup_text[0] = "Hi %name%! Thanks for sharing your Birthday with us! We hope you had a great Birthday visit at the Twilight Inn"; 

        $followup_text[1] = "Hi %name%! Thanks2 for visiting with us! We hope you had a great visit"; 

        $followup_text[2] = "Hi %name%! Thanks3 for visiting with us! We hope you had a great visit"; 

      

    /**Enter your twilio sid here**/

    $twilio_sid = 'PN306ac817761cf22ac5d1a53bf108820b'; 

        

    /**Enter your twilio token here**/

        $twilio_token = '94bd9ac71a2fc3fcf3cb81818570c811'; 

        

    /**Twilio number to send sms**/

        $twilio_number = '+13143258710';

        

        /**If you leave it empty than default will be 123contact form and define value for 123contact is "123" and for jotform is "jot" **/

    $form_type = "jot";

        

        $mandril_api_key = "";

     

    /**Add country code in which country the script work. For UK add +44. It will be used with the number given by subscriber to send messages. If it is empty then the default value will be USA's +1 code**/

        $custom1 = "+1"; 

     

    /**Add your desire timezone in custom2 variable. If you leave it empty then default USA central timezone is used**/

    /**

    Possible entries sorted by country include:

     

    USA Timezones:

    Eastern,Central,Mountain,Pacific,Alaska,Hawaii

     

    UK Timezones:

    London

     

    Canada Timezones:

    c_atlantic,c_central,c_eastern,c_mountain,c_pacific

    **/

        $custom2 = "Central";

    /**

    Set custom3 variable to "no" to disable email notifications. "yes" is the default.

    **/

        $custom3 = "";

        $custom4 = "";

        $custom5 = "";

        $custom6 = "";

        $custom7 = "";

        $custom8 = "";

    ?>

  • Profile Image
    JotForm Support

    Answered by Charlie on January 21, 2016 at 11:49 AM

    I presume you want to fetch the form field values on a PHP script?

    If that's the case, you can sent post data by following guides:

    To send post data on a PHP script, you can check this link: http://www.jotform.com/help/213-Send-POST-Data-From-JotForm-Using-PHP-in-Custom-Thank-You-Page

    To easily know the PHP variables, you can check how they look like here: http://www.jotform.com/help/51-How-to-Post-Submission-Data-to-Thank-You-Page 

    If your database is a MySQL, then you can check this guide on how to send post data on that database: http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

    If you want to send or run a script on the background without using the target web link as the thank you URL, then you can setup a Webhook instead: http://www.jotform.com/help/245-How-to-Setup-Webhook-with-JotForm 

     

    I hope the guides will help you on this.