How do you use PHP and MySQL to populate information in a form?

Answer 1

Working at hostmysite.com gives me a lot of experience with PHP and mysql. All you need to do is use a mysql query to grab information from a database. From there you can enter easily use the returned data to a form. Here is an example:

<?php

$query = sprintf("SELECT firstname, lastname, address, age FROM friends LIMIT 1");

$result = mysql_query($query);

if (!$result) {

$message = 'Invalid query: ' . mysql_error() . "\n";

$message .= 'Whole query: ' . $query; die($message);

}

while ($row = mysql_fetch_assoc($result)) {

$firstname = $row['firstname'];

$lastname = $row['lastname'];

$address = $row['address'];

$age = $row['age'];

}

echo ' <form method="post">

<input name="firstname" value="'.$firstname.'">

<input name="lastname" value="'.$lastname.'">

<input name="address" value="'.$address.'">

<input name="age" value="'.$age.'">

</form> ';

mysql_free_result($result);

?>