Cakephp Find Convert to Sql Syntax

Question

Cakephp find data in controller also can with sql syntax,

example :

$this->Post->find('all');

in sql :

select * from posts

convert query to cakephp find syntax is available at http://dogmatic69.com/sql-to-cakephp-find-converter

but whether there is any link for me if I wanna convert my cakephp find to query..

Thanks in advance...

@Breeze : I'm sorry for that, I need it if the link exists but Thanks for your advice.. — Onesinus Saut, May 04 '16 at 04:08
@Onesinus check out our sister site for software recommendations, the question might be on-topic there: http://softwarerecs.stackexchange.com/ — Breeze, May 04 '16 at 04:26
Just add the following line after your find query . pr($this->Post->getDataSource()->getLog(false, false));exit ; — AnNaMaLaI, May 11 '16 at 03:39

score 1 · Answer 1 · answered May 04 '16 at 04:11

1

If I got what you are asking, here is the answer

SQL calls that you can’t or don’t want to make via other model
methods can be made using the model’s query() method (though this
should only rarely be necessary).

query() uses the table name in the query as the array key for the returned data, rather than the model name. For example:

$this->POST->query("SELECT* from posts;");

Here is the link for cakephp documentation

answered May 04 '16 at 04:11

Pradeep Singh

1,282
2
19
35

1

yes you got my question, but I search link which can convert to query from my cakephp find.. – Onesinus Saut May 04 '16 at 04:17
@OnesinusSaut This [link](http://stackoverflow.com/questions/16780482/cakephp-see-the-compiled-sql-query-before-execution) can help you out – Pradeep Singh May 04 '16 at 04:28
Wait, I will try your suggestion page, If Answer my question i will confirm and correct your answer... – Onesinus Saut May 04 '16 at 05:17

Cakephp Find Convert to Sql Syntax

1 Answers1