Hi all,
I am new to cake within the last couple of months but I am a
experienced PHP programmer. I've made a few basic applications in
practice to building my own time and event management system.
I have a question regarding how to pull data from multiple tables...
I have a user profile table and a 'duties' table, a user can have many
duties and each record in duties counts as one duty.
In the duties_controller i create a function that requires input from
the user: (first name, last name, month and year). I take the first
name and last name and pass it to the user_profile model to find a
valid user id.
I then use this user id to display all duties for that user within the
last month, but the duties tables relys on relations as well as
specific values.
In my displayDuty() in the duties_controller i set a variable which is
then used in the display_duty.ctp view to loop over all the user
duties and echo them to a table.
duties_controller display method:
$conditions = array("month(Duty.duty_date)" => $monthNo);
$this->set('duties', $this->Duty->findByuser_id($user), array
('conditions' => $conditions));
My question... (and sorry for the long build up :p):
Is there an easy way to pull out data from relationship tables from
duties using the value given in the view, so I do a foreach loop in
the view and could do:
$duty['Duty']['station_id'];
But what i really want is the station name from the Station table,
similary how would I pull out data not in the duty table but related
to the user id, such as user_role from Usr_roles table..
I might be making this too complicated but would appreciate any
advice :-) could i just do a simple sql lookup? i wasnt sure if its
right to do this within a view and not the controller.
Many thanks for any info,
Bailey
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 [email protected]
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
