Parse error: syntax error

funkymonkey

Hello,

I am receiving an error:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING on line 62

here is the code

$sql="INSERT INTO Emotional
(It_is_difficult_for_me_to_let_people_get_emotionally_close_to_me, I_sometimes_find_it_difficult_to_trust_people,
Try_not_to_dwell_on_an_issue_once_it_is_resolved,
Show_that_my_partner_needs_are_important,
The_friendship_between_me_and_my_partner,
Being_able_to_make_compromises)
VALUES ('$POST[longterm]','$POST[difficulttrust]','$POST[dwellonissue]',' $POST[partnerneeds]',
'$POST[friendshippartner]','$POST[makecompromises]')";

Line 62 is highlighted in bold.

Any help is appreciated.

THANKS!

Undrium

I think your code needs several of changes, perhaps not necessary but would make it look better.

Your $_POSTs are wrong, should look like this instead:

$_POST['difficulttrust']

Also, just skip the "`" around your table-name.

johanafm

Undrium;10983329 wrote:
Your $POSTs are wrong, should look like this instead:
$_POST['difficulttrust']
No they should not.
# correct outside of string literals
$_POST['key'];

#correct with string interpolation
"$_POST[key]";

# also correct with string interpolation
"{$_POST['key']}";
There is no parse error in the posted code, so either you're not looking at the right file, or have changed something before posting.

However, you must make user input safe. From the looks of your code, your variables can take one of two values, which can be handled by true/false, or should your db lack a boolean datatype, 0 and non-zero. Yet, you treat the input as strings.
If you do use strings,
# this is a must
$_POST['somefield'] = mysql_real_escape_string($_POST['somefield']);
But a better solution would be to give those post variables '0' and '1' values and
$sql=sprintf("INSERT INTO `Emotional`
(It_is_difficult_for_me_to_let_people_get_emotionally_close_to_me, I_sometimes_find_it_difficult_to_trust_people,
Try_not_to_dwell_on_an_issue_once_it_is_resolved,
Show_that_my_partner_needs_are_important,
The_friendship_between_me_and_my_partner,
Being_able_to_make_compromises)
VALUES (%d,%d,%d,%d,%d,%d)",
$_POST['longterm'],
$_POST['difficulttrust'],
$_POST['dwellonissue'],
$_POST['partnerneeds'],
$_POST['friendshippartner'],
$_POST['makecompromises']);

funkymonkey

Thanks for your help, I have finally looked over everything and realized the syntax errors I have made, and everything went through.

One other problem though, nothing is showing up in the mysql database. Did I miss a step?

bradgrafelman

How are you executing the query? Are you checking to see if (for example) [man]mysql_query/man is returning boolean FALSE and, if so, printing and/or logging the MySQL error message for debug purposes?

funkymonkey

I'm not sure with any of that means 🙁 however, I would like have all of the data inserted into different mysql tables. Is there a special query for that?