StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCakePHP declaring variables
primarykey
Id
11821909
data
AcceptedAnswerId
11822582
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-08-06T02:31:24.213
FavoriteCount
0
LastActivityDate
2012-08-06T06:55:11.817
LastEditDate
LastEditorUserId
0
OwnerUserId
1402677
ParentId
0
PostTypeId
1
Score
1
ViewCount
1173
LastEditorDisplayName
text
Body
Hey guys trying to declare a variable in CakePHP in the Fields Controller. This variable will display the template id from the template table, but the view is saying the variable is undefined even though we delared it in the controller. Temaplates has many fields and fields belongs to templates. Here is the Fields Controller: <pre><code><?php class FieldsController extends AppController{ public $uses = array('Template'); function add(){ $this->set('title_for_layout', 'Please Enter Your Invoice Headings'); $this->set('stylesheet_used', 'style'); $this->set('image_used', 'eBOXLogo.jpg'); $this->Session->setFlash("Please create your required fields."); $templates = $this->Template->find('list'); //$current_template = $this->request->data['Field']['template_id']; // right way to do it, but Template is undefined, and says undefined var //$template = $this->request->data['Field']['template_id']; // makes sense with the find, no errors, but still doesnt print in form, says undefined var //$current_template = $this->request->data($template['Field']['template_id']); if($this->request->is('post')) { $this->Field->create(); if ($this->Field->save($this->request->data)) { if($this->request->data['submit'] == "type_1") { $this->Session->setFlash('The field has been saved'); $this->redirect( array('controller' => 'fields','action' => 'add')); } if($this->request->data['submit'] == "type_2") { $this->Session->setFlash('The template has been saved'); $this->redirect( array('controller' => 'templates','action' => 'index')); } } else { $this->Session->setFlash('The field could not be saved. Please, try again.'); } } } } </code></pre> And here is our add view which adds fields: <pre><code><?php echo $this->Form->create('Field', array('action'=>'add')); echo $this->Form->create('Field', array('action'=>'add')); echo $this->Form->input('name', array('label'=>'Name: ')); echo $this->Form->input('description', array('label'=>'Description: ')); //echo $this->Form->input('template_id',array('label'=>'Template ID: ', 'type' => 'select', 'options' => $templates)); echo $this->Form->input('template_id',array('label'=>'Template ID: ', 'type' => 'text', 'default'=> $templates)); //echo $this->Form->input('templates_id', array('label'=>'Template ID: ', 'type' => 'text', 'default' => $current_template['templates_id']));//this would be the conventional fk fieldname echo $this->Form->button('Continue adding fields', array('name' => 'submit', 'value' => 'type_1')); echo $this->Form->button('Finish adding fields', array('name' => 'submit', 'value' => 'type_2')); echo $this->Form->end(); ?> </code></pre>
Tags
<forms><cakephp><variables><views>
Title
CakePHP declaring variables
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USuser1402677
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. VO
 singulars
 PostPostId
 POCakePHP declaring variables
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.