StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POChange Client id to Client Name with CakePHP
primarykey
Id
19774916
data
AcceptedAnswerId
19774969
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-11-04T18:53:02.613
FavoriteCount
0
LastActivityDate
2013-11-05T05:30:30.877
LastEditDate
2013-11-04T20:02:46.583
LastEditorUserId
2948950
OwnerUserId
2948950
ParentId
0
PostTypeId
1
Score
0
ViewCount
564
LastEditorDisplayName
text
Body
Okay, so I have a form in CakePHP that submits to a database. In this form it submits a field called <code>client_id</code> and it is stored in the database as such as well. Then I have a view to allow me to view all of the invoices that have ever been created. To view the client responsible for the invoice, I can currently only see the id entered in the form by placing: <code><?php echo $invoice['Invoice']['client_id']; ?></code> in the view. The invoices go to one database called: invoices The clients name is not stored in the invoices table, just the id The clients information is stored in one database called: clients I want to be able to actually display out the clients real name in the invoices view rather than the client id. I tried adding the following query to my index controller, But i'm not sure what to do after this or if this is even right. <code>$this->set('clients', $this->Invoice->query("SELECT * FROM clients WHERE id='89545'"));</code> In order to keep this question short in the first place, Please request specific code by commenting. i.e. Controller code, view code, etc... Thank you in advance. Additional Thoughts If I wasn't using CakePHP I could use something like the following, So I guess I just don't know how to put this into cakephp "language". <pre><code><?php query($con, "SELECT name FROM clients WHERE id='$client_id'"); echo $row['name']; ?> </code></pre> roughly! Update Here are my models First one being the <code>Client.php</code> <pre><code><?php class Client extends AppModel { public $hasMany = array( 'Invoice' => array( 'className' => 'Invoice', 'foreignKey' => 'client_id' ) ); } ?> </code></pre> Second one being the <code>Invoice.php</code> <pre><code><?php class Invoice extends AppModel { public $belongsTo = array( 'Client' => array( 'className' => 'Client', 'foreignKey' => 'client_id' ) ); } ?> </code></pre> And finally, to get my invoices from the database, I am using the following inside: <code>InvoicesController.php</code> <pre><code>public function index() { $this->set('invoices', $this->Invoice->find('all')); } </code></pre>
Tags
<php><mysql><sql><cakephp>
Title
Change Client id to Client Name with CakePHP
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USuser2948950
UserOwnerUserId
1. USuser2948950
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.