php - Creating a lookup field in a CakePHP form -



php - Creating a lookup field in a CakePHP form -

i have view created using bake has following:

<fieldset> <legend><?php echo __('edit device'); ?></legend> <?php echo $this->form->input('deviceid'); echo $this->form->input('devicetypeid'); echo $this->form->input('userid'); echo $this->form->input('type'); echo $this->form->input('keypadid'); echo $this->form->input('version'); echo $this->form->input('description'); echo $this->form->input('updateid'); ?> </fieldset>

which saves table:

create table `device` ( `deviceid` varchar(255) not null , `devicetypeid` int(11) not null , `userid` int(10) not null , `type` varchar(10) null default null , `keypadid` int(10) null default null , `version` varchar(255) null default null , `description` tinyblob null , `updateid` int(11) null default null , primary key (`deviceid`), index `fk_user` (`userid`), index `fk_devices_updates` (`updateid`), index `fk_device_devicetype` (`devicetypeid`), constraint `fk_device_devicetype` foreign key (`devicetypeid`) references `devicetype` (`devicetypeid`), constraint `fk_devices_updates` foreign key (`updateid`) references `update` (`id`) on update cascade on delete cascade, constraint `fk_user` foreign key (`userid`) references `user` (`userid`) on update cascade on delete cascade )

my problem when form displayed, shows devicetypeid , userid updateid foreign key value instead of drop downwards caption beingness text , value beingness id column. how go setting field foreign table display field , id beingness value?

update 11-02-2013

first of suggest convert primary , foreign keys accordingly meet cakephp naming conventions.

this means that:

deviceid should id. devicetypeid should device_type_id userid should user_id

also primary keys in tables should named id. way never have worry anything, concerning models etc.

after that, tables must in plural form. means device table should devices, should rename also. assume have next tables: devices_types , users.

at point, should notice prefer have table named devicetype. avoid underscored names, because it's easy create mistakes using right form each object, class etc. don't have worry whether should utilize camelcase or not.

anyway

your device model should that:

<?php /** device.php **/ class device extends appmodel { public $name = 'device'; public $belongsto = array( 'devicetype' => array( 'classname' => 'devicetype', 'foreignkey' => 'device_type_id' /** specify other keys meet needs **/ ), 'user' => array( 'classname' => 'user', 'foreignkey' => 'user_id' ) ); }; ?>

also devicetype model should similar to

<?php /** devicetype.php **/ class devicetype extends appmodel { public $name = 'devicetype'; };

in edit() method, should query devicetype in this:

... $devicetypes = $this->device->devicetype->find('list', array('id', 'caption')); $this->set(compact('devicetypes')); ...

this way in view respective form element sets <select> menu correctly.

ps: should follow cakephp conventions model-naming etc... mine example.

php cakephp cakephp-2.1

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more