Data from database as value of textbox in PHP

Question

i am setting the value of a few textboxes using the data from the database as shown.

$qry="select * from branch where id=4";
$res=$con->query($qry);
$r=$res->fetch_assoc();

Actually i am printing the table with the textbox inside the echo statement as below:

echo '
<td>Incharge:</td><td><input type="text" name="incharge" size="38" value='.'$r["incharge"])'.'></td>';

But the problem is that it is only printing the first string in the textbox.for e.g.if the value of $r["incharge"] fetched is Ankur Lakhani, but it is only printing Ankur. Any solution??

you are missing the quotes : `value='=$r["incharge"]?>'` – Loïc Mar 03 '14 at 12:56 — Loïc, Mar 03 '14 at 12:56
... value="'.$r["incharge"].'" ... – Loïc Mar 03 '14 at 13:09 — Loïc, Mar 03 '14 at 13:09

score 3 · Accepted Answer · edited May 23 '17 at 11:49

Your output HTML looks like:

<input type="text" name="incharge" value=Ankur Lakhani>

as you can tell by the highlighting, it's not interpreted the way you expect.

It is interpreted as:

<input type="text" name="incharge" value="Ankur" Lakhani="Lakhani">

Add quotes to ensure the whole value is used:

<input type="text" name="incharge" value="Ankur Lakhani">

You should also add escaping incase your string contains HTML sensitive characters like " and >

<input type="text" name="incharge" value="<?php echo htmlspecialchars($r["incharge"]); ?>"/>

Relevant: htmlentities() vs. htmlspecialchars()

score 1 · Answer 2 · answered Mar 03 '14 at 12:55

1

When you output data as value of a text input you should escape it, using the htmlentites function :

<input type="text" name="incharge" value="<?php echo htmlentities($r["incharge"]); ?>"/>

Reference: http://it1.php.net/htmlentities

answered Mar 03 '14 at 12:55

piacente.cristian

757
4
10

score 0 · Answer 3 · answered Mar 03 '14 at 12:57

0

you forgot setting quotes "" for your value.

try this:

<?php
$qry="select * from branch where id=4";
$res=$con->query($qry);
$r=$res->fetch_assoc();
?>
<input type="text" name="incharge" value="<?php echo $r['incharge'];?>">

answered Mar 03 '14 at 12:57

rebyte

70
1
4

CS GO · Answer 4 · 2014-03-03T13:07:47.330

0

If the problem is in your client side then it will this one

'$r["incharge"])'

change it to

"$r['incharge'])"

edited Mar 03 '14 at 13:07

answered Mar 03 '14 at 12:57

CS GO

914
6
20

score 0 · Answer 5 · answered Mar 03 '14 at 12:58

0

try,

value = "<?php echo $r['incharge']; ?>"

answered Mar 03 '14 at 12:58

Jaykishan

1,409
1
15
26

score 0 · Answer 6 · answered Mar 03 '14 at 13:12

0

Try this

<input type="text" name="incharge" value="<?= $r['incharge'];?>">

or use like <?= htmlspecialchars($r['incharge'])?>

Must Enable your Short_open_tag on your config file

answered Mar 03 '14 at 13:12

Dileep Kumar

247
1
10

Data from database as value of textbox in PHP

6 Answers6