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

    Unable to save submitted data in a MySQL database using PHP

    Asked by bltrecruiting on December 16, 2014 at 09:01 PM

    Hello

     

    Please may I ask for some assistance on this as I have been trying to fix for 2 days now,.

     

    Here is my code

     

    http://pastie.org/9785328

     

    I have sorted out a lot of the syntax and keep getting errors - the one showing at the moment is Parse error: syntax error, unexpected '}' in /home/a8748341/public_html/thankyou.php on line 77

    Please see link to my error report which is being pulled straight out of my thankyou.php file. 

    I have tried many things now and cannot find a solution.

    Is it because I am trying to send only some field values to the mysql database if the submission from the form is a new entry? Do I need to send all of the field data is been posted? If so can anyone help me write the code for that part as I am having issues with the address part as it is an array with 5 variables. 

     

    Any help on this would be SO appreciated

     

    I am going to have to move my businesses form from jotform if I can't get this sorted, I have looked through all the forums I have literally tried everything

     

    Any help would be kindly appreciated.

     

    thanks

     

    Kate 

     

     

     

    Page URL:
    http://recruitingblt.comli.com/add-new-sales-record.html

    PHP code JotForm style size font php database mysql
  • Profile Image

    Answered by raul on December 16, 2014 at 09:23 PM

    I've checked your code and it seems that there's a missing if condition since you're receiving the error on line 77 that has an else statement, but I don't see the if condition.

    From what I understand of your code, it looks like you're going to execute the query from lines 65-75 or from 80-81 based on a condition. If this is correct, then you need to include this condition using an if statement above line 65.

    Hope this helps.

    Let us know if you need further assistance.
    Thank you.

  • Profile Image

    Answered by bltrecruiting on December 18, 2014 at 07:12 AM

    Hello, thank you so much that worked!!!! I am at the final stage of my project and a little stuck, it's the very last part so very frustrating? Can you please help with your super skills? Thanks question in new thread below; 

     

    http://www.jotform.com/answers/478206-Trying-to-autopopulate-form-using-mysql-connection#1

  • Profile Image
    JotForm Support

    Answered by Charlie on December 18, 2014 at 10:14 AM

    Hi,

    I'm glad that it is now working fine in your end. In behalf of my colleague, you're welcome. Regarding your other concern, we will respond to it accordingly to this thread link.

    Thank you.