|
|
Posted by Leonie on 10/01/23 11:10
Just as a follow up.
Marek sent me a reply, but for some mysterious reason it didn't appear
on the list:
>Use either HTML_QuickForm::setDefaults() to set defaults for all
>elements or HTML_QuickForm_element::setValue() to set value for
>individual elements. Former is simpler, and if you name the forms
>elements after the table columns, you can directly pass in array
>fetched from sql query.
I've been able to fill out all the form data as follows, using PEAR DB:
//get the form data if it is an edit form
if ($_GET['id']) {
$sql = 'SELECT * FROM '.TBL_BOOK.' WHERE ID='.$_GET['id'];
$res = $db->query($sql);
$data = $res->fetchRow(DB_FETCHMODE_ASSOC);
$form->setDefaults($data);
}
As long as the fields are named the same as the table columns, this
works well.
Thank you to everyone who helped me with this.
Leonie
Navigation:
[Reply to this message]
|