Adding an input field to primary key in CakePHP

Question

I'm new to CakePHP and still really have no thorough understanding. if I have a mysql database with only a primary key field how can I make an input field for it using cake bake option. After baking I tried adding this line to the view file generated

<fieldset>
<legend><?php echo __('Add Id'); ?></legend>
<?php
        **echo $this->Form->input('identity');**
?>
</fieldset>

It did not work ... What is the correct method to get an input field for the primary key?

The table id has only one field named identity in the data base

The table id has only one field named identity in the data base — AlphaWolf
– AlphaWolf, Commented Mar 16, 2013 at 3:52
do you want to say that textbox is not getting displayed ... ? — alwaysLearn
– alwaysLearn, Commented Mar 16, 2013 at 4:03
<div class="ids form"> <?php echo $this->Form->create('Id'); ?> <fieldset> <legend><?php echo __('Edit Id'); ?></legend> <?php echo $this->Form->input('identity'); ?> </fieldset> <?php echo $this->Form->end(__('Submit')); ?> </div> is this what you asked? I just started using cakephp — AlphaWolf
– AlphaWolf, Commented Mar 16, 2013 at 4:52

thaJeztah · Accepted Answer · 2013-03-16 10:51:30Z

3

CakePHP will, by default, output primary key fields as a hidden input. You can override it by specifying the 'type' of input to use, e.g.:

echo $this->Form->input('identity', array('type' => 'text'));

However, CakePHP supports two type of Primary Keys; autoNumber integers and GUID/UUID primary keys. Manually setting primary keys (e.g. use 'username' as primary key and trying to insert or edit the username) may cause problems, because CakePHP assumes that an update should be performed if the primary is not empty in your form.

http://book.cakephp.org/2.0/en/getting-started/cakephp-conventions.html#model-and-database-conventions

answered Mar 16, 2013 at 10:51

thaJeztah

29.3k9 gold badges77 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ajay K · Accepted Answer · 2013-03-16 14:06:03Z

1

Change your statement to this:

echo $this->Form->input('id', array ('type'=>'text'));

You should now have the id in full view.

CakePHP used the id or index, to determine, if the form entry is a new entry (ie INSERT) or an update to the existing extry (ie UPDATE).

If you make the index editable, you will have to deal with this issue, else you can end up having multiple records, one with the original record and a second record with the changes.

answered Mar 16, 2013 at 14:06

Ajay K

3541 gold badge4 silver badges14 bronze badges

Collectives™ on Stack Overflow

Adding an input field to primary key in CakePHP

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related