Database table to make drop down select using cakephp

Question

I have one controller for invoices and another for clients.

I have made some "relationships" in the models of these controllers as below:

Client.php

<?php

  class Client extends AppModel {
      public $hasMany = array(
          'Invoice' => array(
              'className' => 'Invoice',
              'foreignKey' => 'client_id'
           )
      );
   }

?>

Invoice.php

<?php

class Invoice extends AppModel {
    public $belongsTo = array(
        'Client' => array(
            'className' => 'Client',
            'foreignKey' => 'client_id'
        )
    );
}

?>

So I thought that making a drop down with each client would be easy. Although, I can't figure out how to do this.

First off this is what I want as a result:

<select>
  <option value="1">Client Name</option>
</select>

Where value is equal to id in client table and Client Name is equal to name in client table.

I tried placing the following into the invoices controleler:

$client = $this->Client->find('all');

and then the following into my view:

echo $this->Form->select('client_name',client, array(
                'class' => 'form-control',
                'name' => 'client_id'
            ));

But I received the following error:

Call to a member function find() on a non-object

Directly on page load. What do I need to do to make this work?

More than likely, your problem is that the Client model is not automatically loaded in the Invoices controller. Since Client has a relationship with Invoice, you can call find on client like this instead: $this->Invoice->Client->find('all');. You probably also want to make use of the find type, list, book.cakephp.org/2.0/en/models/… which will return results formatted in a way that you can use to create your select options easily. — Kai
– Kai, Commented Nov 4, 2013 at 23:39
@Kai, First of all sorry for the delayed response, Finally got to try your solution and it almost worked. So can you place this in an answer. Finally, I am getting client as an undefined variable in my view. Guessing I need to define the variable in the view somehow? I currently have: $client = $this->Invoice->Client->find('list'); in my controller and then: echo $this->Form->select('client_name', $client, array( (shortened of course) in my view. — user2948950
– user2948950, Commented Nov 5, 2013 at 20:22

Kai · Accepted Answer · 2013-11-05 20:36:48Z

4

More than likely, your problem is that the Client model is not automatically loaded in the Invoices controller. Since Client has a relationship with Invoice, you can call find on Client like this instead:

$data = $this->Invoice->Client->find('list', array('fields' => array('id', 'name')));
$this->set('clients', $data);

Then in the view,

echo $this->Form->select('Invoice.client_id', $clients);

or

echo $this->Form->input('Invoice.client_id', array('type' => 'select', 'options' => $clients));

This should output a dropdown where the values are the client id's and the visible options in the drop down are the client names. You will want to go by id's rather than client names when associating invoices with the clients.

answered Nov 5, 2013 at 20:36

Kai

3,8231 gold badge20 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Database table to make drop down select using cakephp

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