|
|
Posted by IchBin on 08/09/06 17:49
IchBin wrote:
>
> I am new to PHP. I am trying to create a QuickForm Select element and
> load it from a database with 'HTML_QuickForm::LoadQuery'.
>
> I figured it would be a lot easier than build all of that code by hand.
> The only thing is I can not find much info on using these objects. I can
> not read the manual for this as I can for Java API's. I am able to
> display the Select object with label but no data.
>
> Can some one point me in the right direction? I am missing something
> stupid..
>
> This is the code sniplet:
>
> $form = new HTML_QuickForm();
> $s =& $form->createElement('select','name','Catagory:' );
> $s->loadQuery($conn, 'select id, name from catagory order by name',
> 'name', 'id');
> $form->addElement($s);
> $form->display();
>
>
> Thanks in Advance...
> IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
> __________________________________________________________________________
>
> 'If there is one, Knowledge is the "Fountain of Youth"'
> -William E. Taylor, Regular Guy (1952-)
For some reason I can get the 'HTML_QuickForm::loadDbResult' to work but
not the 'HTML_QuickForm::loadQuery'. I rather use the loadQuery because
it takes less code on my part. Beats me!
//
// This works for HTML_QuickForm::loadDbResult()
$db =& DB::connect($dsn, $options);
if (PEAR::isError($db)) {
die($db->getMessage());
}
$result =& $db->query($catagory_dropdown_select);
if (PEAR::isError($result)) {
die($res->getMessage());
}
$form = new HTML_QuickForm();
$s =& $form->createElement('select','name','Catagory:' );
$s->loadDbResult($result, 'name', 'id');
$form->addElement($s);
$form->display();
I love HSQLDB and use in my Java code. I guess I'll use MySQL for PHP. I
am not a big fan of MySQL but it easy to use and 95% of Hosting sites
seem to run it..
Problem example: I noticed that when I do an 'ORDER BY' on my 'SELECT'
statement this is the screwed-up ORDER that it comes back for 'Catagory':
ApacheTomcat
.Net
AJAX
Buddhist
C and C++
C Sharp
Cisco
CSS
DataBase
Design Patterns
Navigation:
[Reply to this message]
|