How Can I Send Submissions' Data to My Database?

  • mike106
    Asked 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 = "";

    ?>

  • Charlie
    Replied 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.