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
– Loïc

2014-03-03 12:56:25 +00:00
Commented Mar 3, 2014 at 12:56 — Loïc
– Loïc, Commented Mar 3, 2014 at 12:56
... value="'.$r["incharge"].'" ...

Loïc
– Loïc

2014-03-03 13:09:19 +00:00
Commented Mar 3, 2014 at 13:09 — Loïc
– Loïc, Commented Mar 3, 2014 at 13:09

Community · Accepted Answer · 2017-05-23 11:49:45Z

3

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()

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Mar 3, 2014 at 12:58

Halcyon

57.7k10 gold badges93 silver badges131 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-17 19:58:40Z

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: https://www.php.net/htmlentities

edited Nov 17, 2023 at 19:58

CommunityBot

11 silver badge

answered Mar 3, 2014 at 12:55

piacente.cristian

7774 silver badges11 bronze badges

Comments

rebyte · Accepted Answer · 2014-03-03 12:57:43Z

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 3, 2014 at 12:57

rebyte

801 silver badge6 bronze badges

Comments

Jaykishan · Accepted Answer · 2014-03-03 12:58:09Z

0

try,

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

answered Mar 3, 2014 at 12:58

Jaykishan

1,5191 gold badge17 silver badges27 bronze badges

Comments

CS GO · Accepted Answer · 2014-03-03 13:07:47Z

0

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

'$r["incharge"])'

change it to

"$r['incharge'])"

edited Mar 3, 2014 at 13:07

answered Mar 3, 2014 at 12:57

CS GO

9026 silver badges20 bronze badges

Comments

Dileep Kumar · Accepted Answer · 2014-03-03 13:12:12Z

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 3, 2014 at 13:12

Dileep Kumar

3471 silver badge10 bronze badges

Collectives™ on Stack Overflow

Data from database as value of textbox in PHP

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related