Table column count in cakephp

Question

I am uploading csv file to mysql database.

Need to check manually check eg.number of row is match with database table column.

1.how to get table's column count in cakephp? 2.No table data ,i want only column count in table.

Any help? Thanks in advance!

Use the solution provided in the most upvoted answer in the duplicate topic as a raw query. — Shadow, Oct 20 '16 at 10:56

score 1 · Answer 1 · answered Oct 20 '16 at 11:21

1

You can access protected objects value _schema

$columnCount = count($this->Site->_schema);

Site is model that You are interested in

answered Oct 20 '16 at 11:21

Bogdan Kuštan

Now , I tried like that – Linn Oct 21 '16 at 02:57
$columnCount = count($this->Ticket->_schema); echo $columnCount; – Linn Oct 21 '16 at 02:58
but return 0 in view – Linn Oct 21 '16 at 02:58
Now I found answer, $columnCount = $this->Ticket->query("SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = 'schema_name' AND table_name = 'table_name'"); debug($columnCount); Thank you form your reply. – Linn Oct 21 '16 at 03:22

1 Answers1