[Resolved] Funny Characters When Displaying from MqSQL

rcoursey

I have a form to display text from a textfield.

This form is activated from another page where several records are browsed at a time. THe information on the browse page is just like it is entered in the DB.

When the single record is displayed in a form for editing the display changes. Prior to the content 3 empty square boxes appear (same size as text).

I can use phpadmin to browse the table and the info does not have the squares.

Here is display code from browse:

Here is the code for the single record display form:

<?php echo htmlentities(stripslashes($row['content']));?></textarea></td>

Why do the little squares appear?

bad76

🙂 Hi,
the different is the TEXTAREA.
The little square are code 0x0A and 0x0D, the line feed and
carriage return. To avoid this check TEXTAREA options, there is some like "wrap=hard|soft|no". Test different case.

see you

rcoursey

The squares are not representing \r\n.

They seem to represent \t (tabs).

I can delete the squares and the first word appears over to the right exactly 3 tabs (I'm guessing one for each square).

The problem is they alwas occur before the first word and even if I edit the record to remove them and update it successfully the effects are still there with one exception... the squares do NOT appear but the word is over to the right 3 tabs.

Wierd!!!

There has to be a logical explanation for this

bad76

but you've tried with wrap tag of textarea ?

Else you can try with trim()...

rcoursey

I searched W3C and could not find a reference to wrap inside the TEXTAREA element.

I am trimming and adding slashes before the first record insert and before the record updates.

Tis a mystery!

rcoursey

Just a thought.

Could addslashes() be the problem if magic_quotes are on?

rcoursey

The answer did not relate to add or strip slashes.

bad76

may be
<textarea wrap="no"></textarea>

rcoursey

I tried wrap = "no" and wrap = "False" neither worked.

When I edit, update, and then go thru edit to view the record I have a textarea where the first word is preceded by 3 tabs.

I've tried htmlspecialchars & htmlentities, neither affect the display.

stolzyboy

the wrap attributes for a textarea are

wrap="hard"

wrap="soft"

wrap="off"