my Select list shows the ID's not the values,CakePHP

How can i get categories names to the select list not their ID's !! , I'm using CakePHP

the 'categories' table has only two columns (id, name)

the view part :

echo $this->Form->input('category',array(

                                             'type' => 'select', 

                                             'options' => $categories,   

                                             'empty' => 'select category'        

                                        ));

the association :

class Job extends AppModel{

public $name = 'Job';

public $belongsTo = array('Category');

}

and the controller :

$categories= $this->Job->Category->find('list');

$this->set('categories',$categories);

the result is a select list with 1,2,3,4,5,6 values

edited Oct 6 '14 at 5:36

tereško

52.5k2078136

asked Oct 6 '14 at 1:39

Exchanger13

1021111

1

stackoverflow.com/a/5659501/689579 possible help

– Sean
Oct 6 '14 at 2:01

possible duplicate of CakePHP - populating select form

– Abhishek
Oct 6 '14 at 4:45

add a comment |

How can i get categories names to the select list not their ID's !! , I'm using CakePHP

the 'categories' table has only two columns (id, name)

the view part :

echo $this->Form->input('category',array(

                                             'type' => 'select', 

                                             'options' => $categories,   

                                             'empty' => 'select category'        

                                        ));

the association :

class Job extends AppModel{

public $name = 'Job';

public $belongsTo = array('Category');

}

and the controller :

$categories= $this->Job->Category->find('list');

$this->set('categories',$categories);

the result is a select list with 1,2,3,4,5,6 values

edited Oct 6 '14 at 5:36

tereško

52.5k2078136

asked Oct 6 '14 at 1:39

Exchanger13

1021111

1

stackoverflow.com/a/5659501/689579 possible help

– Sean
Oct 6 '14 at 2:01

possible duplicate of CakePHP - populating select form

– Abhishek
Oct 6 '14 at 4:45

add a comment |

How can i get categories names to the select list not their ID's !! , I'm using CakePHP

the 'categories' table has only two columns (id, name)

the view part :

echo $this->Form->input('category',array(

                                             'type' => 'select', 

                                             'options' => $categories,   

                                             'empty' => 'select category'        

                                        ));

the association :

class Job extends AppModel{

public $name = 'Job';

public $belongsTo = array('Category');

}

and the controller :

$categories= $this->Job->Category->find('list');

$this->set('categories',$categories);

the result is a select list with 1,2,3,4,5,6 values

edited Oct 6 '14 at 5:36

tereško

52.5k2078136

asked Oct 6 '14 at 1:39

Exchanger13

1021111

How can i get categories names to the select list not their ID's !! , I'm using CakePHP

the 'categories' table has only two columns (id, name)

the view part :

echo $this->Form->input('category',array(

                                             'type' => 'select', 

                                             'options' => $categories,   

                                             'empty' => 'select category'        

                                        ));

the association :

class Job extends AppModel{

public $name = 'Job';

public $belongsTo = array('Category');

}

and the controller :

$categories= $this->Job->Category->find('list');

$this->set('categories',$categories);

the result is a select list with 1,2,3,4,5,6 values

php cakephp cakephp-model

edited Oct 6 '14 at 5:36

tereško

52.5k2078136

asked Oct 6 '14 at 1:39

Exchanger13

1021111

edited Oct 6 '14 at 5:36

tereško

52.5k2078136

asked Oct 6 '14 at 1:39

Exchanger13

1021111

edited Oct 6 '14 at 5:36

tereško

52.5k2078136

edited Oct 6 '14 at 5:36

tereško

52.5k2078136

edited Oct 6 '14 at 5:36

tereško

52.5k2078136

asked Oct 6 '14 at 1:39

Exchanger13

1021111

asked Oct 6 '14 at 1:39

Exchanger13

1021111

asked Oct 6 '14 at 1:39

Exchanger13

1021111

1

stackoverflow.com/a/5659501/689579 possible help

– Sean
Oct 6 '14 at 2:01

possible duplicate of CakePHP - populating select form

– Abhishek
Oct 6 '14 at 4:45

add a comment |

1

stackoverflow.com/a/5659501/689579 possible help

– Sean
Oct 6 '14 at 2:01

possible duplicate of CakePHP - populating select form

– Abhishek
Oct 6 '14 at 4:45

stackoverflow.com/a/5659501/689579 possible help

– Sean
Oct 6 '14 at 2:01

possible duplicate of CakePHP - populating select form

– Abhishek
Oct 6 '14 at 4:45

add a comment |

3 Answers
3

active

oldest

votes

You needs to edit your controller code as following :

$categories= $this->Job->Category->find('list',array('fields'=>array('Category.id','Category.name')));

answered Oct 6 '14 at 5:23

Prakash Saini

465311

add a comment |

you need to use virtual field in cakephp.

http://book.cakephp.org/2.0/en/models/virtual-fields.html

also Line main in ctp file

foreach($times as $key => $value ){ $timesList[$value] = $value; } $times = $timesList

use as per your model-controller. for mor info. plz follow this link .here i face same problem and i got solution.

virtual field are not working in cakephp

edited May 23 '17 at 12:08

Community♦

answered Nov 5 '14 at 12:29

newsurt

2119

add a comment |

In cakephp 3.X

// Common Usage:

$users = [

    ['id' => 1, 'name' => 'mark'],

    ['id' => 2, 'name' => 'jane'],

    ['id' => 3, 'name' => 'sally'],

    ['id' => 4, 'name' => 'jose'],

];

$results = Hash::extract($users, '{n}.id');

// $results equals:

// [1,2,3,4];

https://book.cakephp.org/3.0/en/core-libraries/hash.html

answered Jan 1 at 6:23

Fury

3,00433154

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f26209024%2fmy-select-list-shows-the-ids-not-the-values-cakephp%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

3 Answers
3

active

oldest

votes

3 Answers
3

active

oldest

votes

You needs to edit your controller code as following :

$categories= $this->Job->Category->find('list',array('fields'=>array('Category.id','Category.name')));

answered Oct 6 '14 at 5:23

Prakash Saini

465311

add a comment |

You needs to edit your controller code as following :

$categories= $this->Job->Category->find('list',array('fields'=>array('Category.id','Category.name')));

answered Oct 6 '14 at 5:23

Prakash Saini

465311

add a comment |

You needs to edit your controller code as following :

$categories= $this->Job->Category->find('list',array('fields'=>array('Category.id','Category.name')));

answered Oct 6 '14 at 5:23

Prakash Saini

465311

You needs to edit your controller code as following :

$categories= $this->Job->Category->find('list',array('fields'=>array('Category.id','Category.name')));

answered Oct 6 '14 at 5:23

Prakash Saini

465311

answered Oct 6 '14 at 5:23

Prakash Saini

465311

answered Oct 6 '14 at 5:23

Prakash Saini

465311

answered Oct 6 '14 at 5:23

Prakash Saini

465311

add a comment |

you need to use virtual field in cakephp.

http://book.cakephp.org/2.0/en/models/virtual-fields.html

also Line main in ctp file

foreach($times as $key => $value ){ $timesList[$value] = $value; } $times = $timesList

use as per your model-controller. for mor info. plz follow this link .here i face same problem and i got solution.

virtual field are not working in cakephp

edited May 23 '17 at 12:08

Community♦

answered Nov 5 '14 at 12:29

newsurt

2119

add a comment |

you need to use virtual field in cakephp.

http://book.cakephp.org/2.0/en/models/virtual-fields.html

also Line main in ctp file

foreach($times as $key => $value ){ $timesList[$value] = $value; } $times = $timesList

use as per your model-controller. for mor info. plz follow this link .here i face same problem and i got solution.

virtual field are not working in cakephp

edited May 23 '17 at 12:08

Community♦

answered Nov 5 '14 at 12:29

newsurt

2119

add a comment |

you need to use virtual field in cakephp.

http://book.cakephp.org/2.0/en/models/virtual-fields.html

also Line main in ctp file

foreach($times as $key => $value ){ $timesList[$value] = $value; } $times = $timesList

use as per your model-controller. for mor info. plz follow this link .here i face same problem and i got solution.

virtual field are not working in cakephp

edited May 23 '17 at 12:08

Community♦

answered Nov 5 '14 at 12:29

newsurt

2119

you need to use virtual field in cakephp.

http://book.cakephp.org/2.0/en/models/virtual-fields.html

also Line main in ctp file

foreach($times as $key => $value ){ $timesList[$value] = $value; } $times = $timesList

use as per your model-controller. for mor info. plz follow this link .here i face same problem and i got solution.

virtual field are not working in cakephp

edited May 23 '17 at 12:08

Community♦

answered Nov 5 '14 at 12:29

newsurt

2119

edited May 23 '17 at 12:08

Community♦

edited May 23 '17 at 12:08

Community♦

edited May 23 '17 at 12:08

Community♦

answered Nov 5 '14 at 12:29

newsurt

2119

answered Nov 5 '14 at 12:29

newsurt

2119

answered Nov 5 '14 at 12:29

newsurt

2119

add a comment |

In cakephp 3.X

// Common Usage:

$users = [

    ['id' => 1, 'name' => 'mark'],

    ['id' => 2, 'name' => 'jane'],

    ['id' => 3, 'name' => 'sally'],

    ['id' => 4, 'name' => 'jose'],

];

$results = Hash::extract($users, '{n}.id');

// $results equals:

// [1,2,3,4];

https://book.cakephp.org/3.0/en/core-libraries/hash.html

answered Jan 1 at 6:23

Fury

3,00433154

add a comment |

In cakephp 3.X

// Common Usage:

$users = [

    ['id' => 1, 'name' => 'mark'],

    ['id' => 2, 'name' => 'jane'],

    ['id' => 3, 'name' => 'sally'],

    ['id' => 4, 'name' => 'jose'],

];

$results = Hash::extract($users, '{n}.id');

// $results equals:

// [1,2,3,4];

https://book.cakephp.org/3.0/en/core-libraries/hash.html

answered Jan 1 at 6:23

Fury

3,00433154

add a comment |

In cakephp 3.X

// Common Usage:

$users = [

    ['id' => 1, 'name' => 'mark'],

    ['id' => 2, 'name' => 'jane'],

    ['id' => 3, 'name' => 'sally'],

    ['id' => 4, 'name' => 'jose'],

];

$results = Hash::extract($users, '{n}.id');

// $results equals:

// [1,2,3,4];

https://book.cakephp.org/3.0/en/core-libraries/hash.html

answered Jan 1 at 6:23

Fury

3,00433154

In cakephp 3.X

// Common Usage:

$users = [

    ['id' => 1, 'name' => 'mark'],

    ['id' => 2, 'name' => 'jane'],

    ['id' => 3, 'name' => 'sally'],

    ['id' => 4, 'name' => 'jose'],

];

$results = Hash::extract($users, '{n}.id');

// $results equals:

// [1,2,3,4];

https://book.cakephp.org/3.0/en/core-libraries/hash.html

answered Jan 1 at 6:23

Fury

3,00433154

answered Jan 1 at 6:23

Fury

3,00433154

answered Jan 1 at 6:23

Fury

3,00433154

answered Jan 1 at 6:23

Fury

3,00433154

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Bdtjtk