Populating HTML form from MySQL using PHP

Question

I've successfully populated a HTML form dropdown menu using this method, so I know it works, the difference this time is I'm trying to populate text boxes with content (account details), but it's just not working.

PHP:

try {
        $sql = "SELECT Firstname, Surname, Email FROM `users`;";
        $result = $pdo->query($sql);


    }
    catch (PDOException $e){
        echo "There was an error whilst fetching the users information:" .$e->getMessage();
        exit();
    }

    while($row=$result->fetch()){
        $displayinfo[] = array('UserFirstName' => $row['Firstname'],
            'UserSurname' => $row['Surname'], 
            'UserEmail' => $row['Email']);
    }

HTML SIDE:

<?php foreach($displayinfo as $info): ?>
                <?php echo "<input type="text" name="firstname" value=". $info['UserFirstName'] ."><br>"
                            ?>
                <?php endforeach; ?>

This seems to show a

Syntax error, unexpected T_String, expecting ',' or ';'

Any help would be appreciated

Quotes are not escaped, it brakes the string : "<input type="text" name="firstname" value=". $info['UserFirstName'] ."><br>". You can change the quotes of attributes to single quotes '. — Coldiary
– Coldiary, Commented May 3, 2017 at 14:05
You have a quote mismatch when outputting the html - use single quotes within the input element perhaps — Professor Abronsius
– Professor Abronsius, Commented May 3, 2017 at 14:05

Scriptman · Accepted Answer · 2017-05-03 14:06:47Z

1

The problem is in:

<?php echo "<input type="text" name="firstname" value=". $info['UserFirstName'] ."><br>"

You need to use the single '

<?php echo '<input type="text" name="firstname" value='. $info['UserFirstName'] .'><br>';

answered May 3, 2017 at 14:06

Scriptman

4322 silver badges13 bronze badges

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

Comments

Nisse Engström · Accepted Answer · 2017-05-03 22:35:07Z

1

You should escape double quotes with backslash inside of input.

Ex: echo "<input type=\"text\"/>".

Or use single quotes.

Ex: echo '<input type="text"/>'.

edited May 3, 2017 at 22:35

Nisse Engström

4,76323 gold badges29 silver badges44 bronze badges

answered May 3, 2017 at 14:06

Emanuel Oliveira

565 bronze badges

Collectives™ on Stack Overflow

Populating HTML form from MySQL using PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related