Re: On select of option dynamicaly fetch data from DB and populate in a dropdown

First off, you can save yourself the foreach loop by using
find('list'), which will give you an array you can pass directly to
the select() method.

Anyway, this depends on how you're using javascript. If you happen to
be using jQuery, have a look at the $.ajax() function. Figure out what
the generated ID of the select list is and do something like this:

$('#theSelectID').change(function()
{
$.ajax({
url: '/controller/action/'+$(this).val(),
cache: false,
success:
function(html)
{
$('#theSelectID').after(html);
}
});
});

Create an action in your controller that accepts a Supplier.id and
fetches a list. Use RequestHandler to test that it's an AJAX request.
Populate the new select list in your view. That will be passed back to
the $.ajax() function.

The way you place the returned html into the document will vary
according to your layout, of course.

On Apr 2, 3:35 am, Ambika Kulkarni <ambikakulkarn...@gmail.com> wrote:
> Hi there,
>
> I'm pretty new to CakePHP. I have a drop down menu, in which the data
> comes from DB. Following is the code for that.
> In Controller file
> function step_one(){
>                 $suppliers = $this->Supplier->find('all', array('fields' =>
> 'Supplier.name'));
>                 $this->set('suppliers',$suppliers);
>
> }
>
> View file
>
>                         $a = array();
>                         $i=1;
>                         foreach( $suppliers as $supplier ):
>                             $a[$i] = $supplier['Supplier']['name'];
>                             $i++;
>                         endforeach;
>                         echo $form->input('Supplier ', array('options' => $a));
>
> This creates a drop down menu. On change I want to have another drop
> down in which the data is fetched from DB.
>
> Thanks In advance
> :)

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en

To unsubscribe, reply using "remove me" as the subject.