php text-string variables with spaces in them or quotes not working in heredoc html form

Question

I query my mySql database table and retrieve text strings that look like this:

  This is a piece of a bronze artifact from the 'Bronze Age' -- it's in outstanding shape.
  His amusing comment on the 3rd-century clay bowl:  "Wow, she's a real piece!"
  It's no secret that you 'don't mishandle old parchment artifacts, they're "very" fragile' -- yet it still happens.

THE PROBLEM -- I use php variables to hold the above strings read from the database, and use the PHP variables in my heredoc form. And I saw right away that a string got truncated when the first space in the string was encountered -- the form only showed text up to the first space.

So I put single quotes around my PHP variables in the heredoc form (see below).

Now I get truncation when the string that came from the database has single quotes.

I can put quotes around my php variables but I'm getting truncations of the text strings when single quotes, double quotes and if I don't quote the PHP variable in the heredoc -- a space in the string truncates the string from that point on.

I'm using PHP and here is the code that gets data from the mySql query result, stores the database data into PHP variables, then uses them in a heredoc:

   $row = mysql_fetch_row($result);
   //var_dump($row);  // the dump proves that the full string comes 
                      // out of the database, with spaces, single and double quotes

   $descriptionOfArtifact = $row[0];
   $commentsAboutTheDiggingSite = $row[1];
   $expertRecommendationsForRestoring = $row[2];

     // output the next row from the Artifacts table...
       echo <<< NEXT_ROW_HEREDOC
         <input type="text" id="Description"   
             name="descrip" value='$descriptionOfArtifact' readonly="readonly"></input>     
         <input type="text" id="Comments"       
             name="comments" value='$commentsAboutTheDiggingSite' readonly="readonly"></input>    
         <input type="text" id="Experts"
              name="experts" value='$expertRecommendationsForRestoring' readonly="readonly"></input>    
   NEXT_ROW_HEREDOC;

I need this form to display the full text string that is read from the database and stored in the above PHP variables. I thought the single quotes around the variable names would do it but I think the heredoc is messing that up (somehow).

So in a heredoc, how can I use PHP variables and be able to see:

single quotes
double quotes
spaces
html tags
any printable character, really

in a heredoc form?

Niet the Dark Absol · Accepted Answer · 2012-02-17 19:23:10Z

3

You have a space between the <<< and the end-of-text keyword. That's probably causing the issue.

Also, call htmlspecialchars on $row[0], $row[1] and $row[2] when you're assigning them to variables, and use double-quotes on your value="..." attribute.

answered Feb 17, 2012 at 19:23

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

wantTheBest Over a year ago

Okay htmlspecialchars did the trick, I was not aware of its existence, cool little function there. The heredoc was not the operative issue after all, although I did have the syntax error that was somehow working. Thank you for the htmlspecialchars tip. After adding that I forgot to change my single quotes in the form to double quotes and got truncation still after a single quote in a string -- must use double quotes for php variables in heredoc forms apparently.

Tallal Mansoor · Accepted Answer · 2015-07-25 11:20:54Z

0

In simple Html code you need to show your value with double quote "" and if you are using php to print some html code through ECHO you need to use single quote to show you value in input box

edited Jul 25, 2015 at 11:20

answered Jul 25, 2015 at 11:12

Tallal Mansoor

13 bronze badges

1 Comment

Tallal Mansoor Over a year ago

if you are using simple html input use this <input id="id" type='text' name="name" value="abc"/> or if you are using Php echo command to print html code use this echo "<input id='id' type='text' name='name' value='$variable' />";

Collectives™ on Stack Overflow

php text-string variables with spaces in them or quotes not working in heredoc html form

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related