Cakephp - Convert numerical DB value into string for display

Question

I have a Classroom model, which has an INT field called level. The values for this field can range from 1-7. What I would like to do is translate the integer in that field into a String for display, according to a predetermined legend, such as this:

1 - Basic I
2 - Basic II
3 - Basic III
4 - Intermediate I

etc... What would be the best way of achieving this? Using afterFind()?

Thanks

Can I create associations to an ArraySource model? It doesn't seem to work :S — AlexBrand
– AlexBrand, Commented Oct 10, 2011 at 15:34

Tom Dezentje · Accepted Answer · 2011-10-10 13:47:58Z

2

Why not make an extra table containing strings matching the ID of the INT field called level. Get the string from that table using the matching ID and your good to go.

answered Oct 10, 2011 at 13:47

Tom Dezentje

6313 silver badges16 bronze badges

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

1 Comment

AlexBrand Over a year ago

yeap I could definitely do that.

mark · Accepted Answer · 2011-10-10 15:59:47Z

0

the quickest way (if the strings do not change much!):

http://www.dereuromark.de/2010/06/24/static-enums-or-semihardcoded-attributes/

echo Classroom::levels($classroom['Classroom']['level']);

in the view - whereever you need it

it also uses less resources than any other approach (therefor is the fastest).

answered Oct 10, 2011 at 15:59

mark

21.8k3 gold badges54 silver badges75 bronze badges

Collectives™ on Stack Overflow

Cakephp - Convert numerical DB value into string for display

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related