Fetch data from database to textbox in php

In this blog we will know how to fetch data from database to textbox in php.

<?php
$con = mysql_connect( 'localhost', 'root', '' );
if( !$con )
{
die( 'Could not connect: ' . mysql_error() );
}
else
{
mysql_select_db( 'home_work', $con );
$result = mysql_query( "SELECT * FROM test" );
while( $row = mysql_fetch_array( $result ) )
{
?>
<form>
<input name="firstname" type="text" value="<?php echo( htmlspecialchars( $row['firstname'] ) ); ?>" />
<input name="lastname" type="text" value="<?php echo( htmlspecialchars( $row['lastname'] ) ); ?>" />
</form>
<?php
}
}
?>