cakePHP loading data from a table into a dropdownbox

Question

hi all im trying to load information from a table into a dropdown box. I'm trying to load account_id from my accounts_users table which contains - id, accounts_id, user_id into a dropdown box.

account_id should only show when the id from the users table = user_id from the accounts_users table. at the moment the dropbox is only loading the id from the accounts_users table.

here is my add function

function add() {
    $this->set('title_for_layout', 'Please Enter Your Temaplate Details');
    $this->set('stylesheet_used', 'style');
    $this->set('image_used', 'eBOXLogo.jpg');  
    $accounts=$this->User->AccountsUser->find('list', array('conditions' => array('user_id' => $this->Auth->user('id'))));
    debug($accounts);
    if($this->request->is('post')){
      $this->Template->create();

  if ($this->Template->save($this->request->data)) {
    $this->Session->setFlash('The template has been saved');
    $this->redirect( array('controller' => 'Fields','action' => 'add'));
  } else {
    $this->Session->setFlash('The template could not be saved. Please, try again.');
  }
}

$this->set('accounts', $accounts);

}

and here is the add view

<?php
echo $this->Form->create('Template', array('action'=>'add'));
echo $this->Form->input('name',array('label'=>'Template Name: '));
echo $this->Form->input('account_id',array('label'=>'Business: ', 'type' => 'select', 'options' => $accounts));
echo $this->Form->input('description',array('label'=>'Short Description Of Template: '));
echo $this->Form->end('Click Here To Submit Template');
?>

the debug outputs

app\Controller\TemplatesController.php (line 20) array( (int) 3 => '3' )

the user in the accounts_users table only has 1 entry with id=3, account_id=10 and user_id=14

L. Sanna · Accepted Answer · 2012-08-05 14:54:26Z

3

$accounts=$this->User->AccountsUser->find('list', array('conditions' => array('user_id' => $this->Auth->user('id'))));

should be:

$accounts=$this->User->AccountsUser->find('list', array('fields'=>array('id','account_id'),'conditions' => array('user_id' => $this->Auth->user('id'))));

answered Aug 5, 2012 at 14:54

L. Sanna

6,5827 gold badges36 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

cakePHP loading data from a table into a dropdownbox

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related