StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODatabase table to make drop down select using cakephp
text
Body
copied!<p>I have one controller for invoices and another for clients. </p> <p>I have made some "relationships" in the models of these controllers as below: </p> <p><strong>Client.php</strong></p> <pre><code><?php class Client extends AppModel { public $hasMany = array( 'Invoice' => array( 'className' => 'Invoice', 'foreignKey' => 'client_id' ) ); } ?> </code></pre> <p><strong>Invoice.php</strong></p> <pre><code><?php class Invoice extends AppModel { public $belongsTo = array( 'Client' => array( 'className' => 'Client', 'foreignKey' => 'client_id' ) ); } ?> </code></pre> <p>So I thought that making a drop down with each client would be easy. Although, I can't figure out how to do this. </p> <p>First off this is what I want as a result: </p> <pre><code><select> <option value="1">Client Name</option> </select> </code></pre> <p>Where value is equal to id in client table and Client Name is equal to name in client table.</p> <p>I tried placing the following into the invoices controleler: </p> <pre><code>$client = $this->Client->find('all'); </code></pre> <p>and then the following into my view: </p> <pre><code>echo $this->Form->select('client_name',client, array( 'class' => 'form-control', 'name' => 'client_id' )); </code></pre> <p>But I received the following error: </p> <pre><code>Call to a member function find() on a non-object </code></pre> <p>Directly on page load. What do I need to do to make this work?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload