use mysql inbuilt functions with cakePHP find()

Question

can any one help me to use the mysql inbuilt function in cakePHP?????

Which ones, the ones built into PHP or those built into Cake? — Pekka
– Pekka, Commented Jul 15, 2010 at 9:06
i mentioned about the inbuilt mysql database functions such as DATE_FORMAT(),CONCAT(string1,string2,...),REPLACE(whole_string,to_be_replaced,replacement)............ keithjbrown.co.uk/vworks/mysql/mysql_p9.php — RSK
– RSK, Commented Jul 15, 2010 at 9:12
You can always sidestep the framework and use $this->Model->query() — David Yell
– David Yell, Commented Jul 15, 2010 at 9:24

Young · Accepted Answer · 2010-07-15 10:04:56Z

3

If you don't want to use

$this->Model->query($yoursql);

Then there's still another way for some mysql functions such as concat,date_format

$this->Model->find($findtype,array('fields'=>array('concat (column1,column2,...) as con','date_format(...) as mydate'),'conditions'=>...));

answered Jul 15, 2010 at 10:04

Young

8,4627 gold badges46 silver badges65 bronze badges

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

2 Comments

RSK Over a year ago

why this statement $competition = $this->Competition->find('first', 'fields' => array('(fee1+fee2) AS total','id','title' ))); results $competition=array(0=>array('total' => 8),'Competition' => array('id' => 1,'title' => 'Competition1'));

Young Over a year ago

@RSK,that's right.If you don't like this style,see nuts-and-bolts-of-cakephp.com/2008/09/29/…

Leo · Accepted Answer · 2010-07-15 09:19:28Z

0

There is an example of how to use CONCAT in the book. I imagine you would be able to extend the syntax to use the other MySql functions as required.

answered Jul 15, 2010 at 9:19

Leo

6,5712 gold badges32 silver badges49 bronze badges

1 Comment

Leo Over a year ago

The use of virtual fields is documented in the manual: book.cakephp.org/view/1608/Virtual-fields. They only appeared with version 1.3, however. I would probably opt for the $this->Model->query($yoursql); construct in this case - that's what it's there for.

Collectives™ on Stack Overflow

use mysql inbuilt functions with cakePHP find()

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related