from database

[Anon]

Hello

I have a php form where there are some form fields(text boxes) displyed in it.Now, i want those boxes to be filled with values from my database.How should i proceed?

thank you

[Anon]

are you using MySQL? if so you should read up in the manual about mysql_connect(), mysql_select_db() and mysql_query(). Basically you need to pull the data out of the db, loop thru the result set and echo the contents to the value tags of your form fields.

[Anon]

hi devin
could you pls be more specific.
I am using interbase as my database.i am able to display the records from my table on a plain form but, i am not able to display within the form fields.How should i echo the contents to the valuetags?for example, one of my form field is: address.

thanks for your tips

[Anon]

loop thru your result set and assign the "address" field to a variable $address, then:

<input type="text" name="address" value="<?= $address ?>">

[Anon]

hmm...i'm confused.
well, let me try to explain you further.I have a test1.php and i included this in main.php.Test 1.php has all my form fields.

This is the code which i used to connect to my db and querying the records.It's working fine and now how should i fix this code and loop it to my form fields.

$username = "SYSDBA";
$password = "masterkey";
$connection = @ibase_connect('localhost:C:\newfolder\database.GDB', $username, $password);
if (!$connection)
{
exit ("Unable to connect to database: $connection");
}
$db = 'Select * from TBL_MYTABLE';
$abc = ibase_query($connection, $db);
while ($row = ibase_fetch_row($abc)) {

echo $row[1];

}

ibase_free_result($abc);
ibase_close($connection);

---

Thanks for your suggestions

[Anon]

is $row[1] your address field? if so:

while ($row = ibase_fetch_row ($abc)) {
echo '
<input type="text" name="address" value="' . $row[1] . '">
';
}

you can fill in here as many <input> tags as you wish and just change the $row[] index to map to your db fields ($row[2], $row[3], etc...)