Populate HTML Form from Database

Question

So I have searched for how to insert items from a MySQL database into a form. From what I understand, for each field, I need to add value="<?php echo htmlentities($Variable); ?>" is there a way to insert the fields all at once? Like in a PHP script? Each field already has a name identifier, that's how the insert.php insert the values into the database, like this:

    //SQL Query to insert data
$sql="INSERT INTO case_info (Volunteer,CaseShortTitle,CaseNumber,HearingDate...)
VALUES ('$_POST[Volunteer]','$_POST[CaseShortTitle]','$_POST[CaseNumber]','$_POST[HearingDate]'...)

and the form fields look like this:

<div><input type="text" id="p1f5c" name="CaseShortTitle" class="fieldcontent"><div class="fielderror"></div></div>

Then the Submit button goes to this insert.php file

Is there a way to use GET to populate the fields in this manner?

Thank you!

Jake Evans · Accepted Answer · 2013-12-15 00:23:50Z

1

It's generally bad practice to input data into your database directly from the $_POST variables, you should consider sanitizing them first.

If I understand what you are asking, you can do something like this;

<form action="" id="myForm" title="myForm">

        <?php
        $query = "SELECT * FROM case_info LIMIT 1";
        $result = myqsl_query($query) or die(mysql_error());
        while($row = mysql_fetch_array($result)){
        ?>
        <input type="text" id="volunteer" value="<?php echo $row['Volunteer']; ?>"
        <input type="text" id="CaseShortTitle" value="<?php echo $row['CaseShortTitle']; ?>"
        <?php
        } //Close while{} loop
        ?>

</form>

answered Dec 15, 2013 at 0:23

Jake Evans

1,0586 gold badges14 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Populate HTML Form from Database

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