execute function on Database using doctrine and symfony

Question

I have function on the database named getDtails(id) using CREATE FUNCTION on mysql

I can call it from mysql using SELECT getDetails(10) which return aninteger.

i want to execute it from symfony 1.4 using doctrine.

Manse · Accepted Answer · 2019-01-02 08:29:33Z

1

You could do it like this :

Doctrine_Manager::getInstance()->getCurrentConnection()
       ->fetchAssoc('SELECT getDetails(10)');

You can replace fetchAssoc with fetchArray or fetchBoth as required.

Documentation of the Doctrine_Connection class is here

answered Nov 19, 2012 at 11:51

Manse

38.1k11 gold badges88 silver badges112 bronze badges

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

1 Comment

Documentation link asking user name and password. what to do ?