Getting a database output to show up in an input field

Question

I'm looking to be able to get my outputted data from my database to appear into an input box, so that I have the ability to update the data later on. I am trying to echo the output into the input field, but it just displays under my input field. How could I do this?

<?php
$con = mysqli_connect("localhost", "root", "", "db");
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
$stmt = mysqli_query($con,"SELECT * FROM user_players");
while($row = mysqli_fetch_array($stmt)) {
    $player1 = $row['player1'];
    $player2 = $row['player2'];
    $player3 = $row['player3'];
    $player4 = $row['player4'];
    $player5 = $row['player5'];
    $player6 = $row['player6'];
?>
    <div class="draftResultsWrap">
        <div class="inline">
        <?php echo "<div>" . $row['firstname'] . " " . $row['lastname'] . "</div>"; ?>
        </div>
        <input class="draftBorder"><?php echo $player1; ?></input>

<input value="<?=$player1?>"

ɹɐqʞɐ zoɹǝɟ
– ɹɐqʞɐ zoɹǝɟ

2015-07-18 05:34:21 +00:00
Commented Jul 18, 2015 at 5:34 — ɹɐqʞɐ zoɹǝɟ
– ɹɐqʞɐ zoɹǝɟ, Commented Jul 18, 2015 at 5:34

Unni Babu · Accepted Answer · 2015-07-18 05:36:37Z

4

Echo php value inside html input value

<input class="draftBorder" value='<?php echo $player1; ?>'/>

answered Jul 18, 2015 at 5:36

Unni Babu

1,81412 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Getting a database output to show up in an input field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related