Unable to save submitted data in a MySQL database using PHP

  • bltrecruiting
    Asked on December 16, 2014 at 9: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 

     

     

     

  • raul
    Replied on December 16, 2014 at 9: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.

    Unable to save submitted data in a MySQL database using PHP Image 1 Screenshot 20

    Hope this helps.

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

  • bltrecruiting
    Replied on December 18, 2014 at 7: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

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