unexpected T ENCAPSED AND WHITESPACE expecting T STRING or T VARIABLE or T NUM STRING error

Question

i ve been staringly blanky at this error and can t seem to know what the problem is When i run the query i get this error      unexpected T ENCAPSED AND WHITESPACE  expecting T STRING or T VARIABLE or T NUM STRING   at this line     sqlupdate1    UPDATE table SET commodity quantity  qty WHERE user  rows  user

User · Accepted Answer

try this  echo  sqlupdate1    UPDATE table SET commodity quantity  qty WHERE user     rows  user

User · Answer

My issue was also within the heredoc  I had it within an if then statement and the closing bracket directly after the semicolon  So I moved the closing bracket to its own line and issue was fixed  I changed          to

User · Answer

Use   before   sign  And also add addslashes function to escape special characters    sqlupdate1    UPDATE table SET commodity quantity    qty  WHERE user   addslashes  rows  user

User · Answer

In my case  heredoc caused the issue  There is no problem with PHP version 7 3 up  Howerver  it error with PHP 7 0 33 if you use heredoc with space    My example code   rexpenditure    lt  lt  lt Expenditure                    lt tr gt                         lt td gt  row- gt payment referencenumber lt  td gt                         lt td gt  row- gt payment requestdate lt  td gt                         lt td gt  row- gt payment description lt  td gt                         lt td gt  row- gt payment fundingsource lt  td gt                         lt td gt  row- gt payment agencyulo lt  td gt                         lt td gt  row- gt payment agencyproject lt  td gt                         lt td gt   row- gt payment disbustment lt  td gt                         lt td gt  row- gt payment payeename lt  td gt                         lt td gt  row- gt payment processpayment lt  td gt                     lt  tr gt  Expenditure    It will error if there is a space on PHP 7 0 33

User · Answer

Try   sqlupdate1    UPDATE table SET commodity quantity  qty WHERE user   rows  user         You need curly brackets for array access in double quoted strings

User · Answer

Change your code to    lt  php  sqlupdate1    UPDATE table SET commodity quantity    qty  WHERE user    rows  user      gt    There was syntax error in your query

[php] unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error

Examples related to php

Examples related to mysql

Examples related to select