FNYFx3Rf

1<?php
2class Subject extends AppModel
3{
4 var $name='Subject';
5var $belongsTo = 'Subjectscat'; 
6}
7
8?>
9	
10<?php
11class Subjectscat extends AppModel
12{
13 var $name='Subjectscat';
14var $hasMany=array('Subject');
15}
16
17?>
18	
19<?php
20    	class SubjectscatsController extends AppController
21    	{
22        var $name='Subjectscats';
23        var $helpers = array('Html', 'Javascript', 'Ajax');
24        var $components = array('Auth');
25    	var $uses=array('Subject', 'User','Subjectscat');
26
27
28    	function index()
29    	{
30    	 $this->layout = 'internal';
31    	 $session_id=$this->Session->read('User.id');
32         $username = $this->User->find('all', array('conditions' => array('User.id' =>$session_id)));
33         $this->set('session_id',$username);
34    	 $this->Subjectscat->recursive =1;
35    	 $cat = $this->Subjectscat->find('all');
36    	  $this->set('subjectcategory',$cat);
37    	 }
38    	  function isAuthorized() {
39            return true;
40         }
41
42}
43
44?>
45	
46<table><tr><td colspan="3">View Feedback</tr>
47 <?php debug($subjectcategory) ?> <?php echo $html->link('Add Feedback', '/feedbacks/add', array('class'=>'button')); ?>
48<?php print_r($subjectcategory); ?>
49<?php foreach($subjectcategory as $subject_cat)
50
51{
52?>
53<tr>
54<td><?php echo $subject_cat['Subjectscat']['cat_name'];?></td>
55<?php print_r($subject_cat['Subjectscat']['Subjects']); ?>
56</tr>
57<?php }
58?>
59
60 </tr>
61</table>
62	
63-- Table structure for table `subjects`
64--
65
66CREATE TABLE IF NOT EXISTS `subjects` (
67  `id` bigint(4) NOT NULL auto_increment,
68  `subjectscats_id` bigint(4) NOT NULL,
69  `name` varchar(25) NOT NULL,
70  PRIMARY KEY  (`id`),
71  KEY `subjectscats_id` (`subjectscats_id`)
72) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
73
74--
75-- Dumping data for table `subjects`
76--
77
78INSERT INTO `subjects` (`id`, `subjectscats_id`, `name`) VALUES
79(1, 1, 'English'),
80(2, 1, 'Hindi');
81
82--
83-- Constraints for dumped tables
84--
85
86--
87-- Constraints for table `subjects`
88--
89ALTER TABLE `subjects`
90  ADD CONSTRAINT `subjects_ibfk_1` FOREIGN KEY (`subjectscats_id`) REFERENCES `subjectscats` (`id`) ON UPDATE CASCADE;
91	
92print_r($subject_cat['Subjectscat']['Subjects'])
93	
94debug($subject_cat)
95	
96foreach ($subject_cat['Subject'] as $subject)
97{
98    // output stuff you need from $subject
99}