文本框无法正确显示

Question

I'm using PHP to retrieve the data from a database.

Every time I retrieve it from database it doesn't show the whole letters. It's being removed off after space???

I want like the first text box, show all the letters

both code doesn't work

<input type="text" class="textinput"  value=' . $r['newsletter_title'] . '>

<input type="text" class="textinput"  value=' . htmlspecialchars($r['newsletter_title']) . '>

I checked the database it's showing the whole letters "80% sale On Day"

Does anyone knows what causes this? Any solution please!!!

Answer 1

You need to quote the value (and use htmlspecialchars):

<input 
    type="text" 
    class="textinput" 
    name="newsletter_title" 
    id="newsletter_title" 
    value="' . htmlspecialchars($r['newsletter_title']) . '" 
    />

Which generates:

<input 
    type="text" 
    class="textinput" 
    name="newsletter_title" 
    id="newsletter_title" 
    value="80% sale On Day" 
    />

Otherwise you're generating invalid html/xml (which is why it isn't working)...