How to get the field names of the table in CakePHP

Question

I am a complete newbie in CakePHP. I want to read the field names of the table in the controller.

I want the controller to list all the field names in the table. How do I do that?

Could you give us more context? Why do you want to do this? – JohnP Apr 30 '11 at 06:59 — JohnP, Apr 30 '11 at 06:59
@JohnP, for debugging purposes. – danilo Aug 16 '18 at 19:08 — danilo, Aug 16 '18 at 19:08

score 26 · Answer 1 · answered Apr 30 '11 at 09:27

26

Use the following snippet to get an array of the field names (replace "YourModel" with the name of your model):

array_keys($this->YourModel->getColumnTypes());

answered Apr 30 '11 at 09:27

dhofstet

score 16 · Answer 2 · answered Apr 30 '11 at 17:07

16

as simple as $this->Model->schema()

answered Apr 30 '11 at 17:07

mark

score 6 · Answer 3 · answered Jan 19 '18 at 22:38

6

For CakePHP 3.x

$this->Model->schema() - Returns the Schema object.

$this->Model->schema()->columns() - Returns all of the columns in the table in an array.

answered Jan 19 '18 at 22:38

Dooltaz

3 Answers3