Call to MySQL user defined function in CakePHP 3

Question

I'm working on cakePHP 3. I have a user defined function(UDF or Routine) in mysql database. That function takes two parameters and returns an integer value. I have to match that returned value in MySQL where clause.

I know mysql query to use that function. i.e,

SELECT customer_id FROM table_name WHERE routine_name(param1, param2)=1;    //param1 is 'customer_id' which I have written after SELECT

But I don't know that how to build this query in cakePHP 3. If anyone knows the solution, answer will be appreciate.

Here is my cakePHP 3 code.

$purchasesTable = TableRegistry::get("Purchases");
$query = $purchasesTable->find();

$fields = ['customer_id'];
$query->select($fields);
$query->where(
    //    Routine/Function call should be here as per MySQL query.
    //    So, I think here I have to do something.
);

Akshay Vaghasiya · Accepted Answer · 2016-01-04 12:13:03Z

1

I got solution.. Here it is.

$abc = $query->func()->function_name(['param1' => 'literal']);
$query->where(function ($exp) use ($abc) {
        return $exp->gt($abc, 14);
    });

answered Jan 4, 2016 at 12:13

Akshay Vaghasiya

1,65710 gold badges39 silver badges61 bronze badges

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

Collectives™ on Stack Overflow

Call to MySQL user defined function in CakePHP 3

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related