I want to use a sql function or perform calculations in a statement I'm generating with zend_db_select. How can I do this?
- 1 Answers
- 286 Views
- I also Faced
- E-Mail Answers
Answer Posted / Gaurav Kumar Agarwal
Zend Framework provides a way to include SQL functions and calculations in your statements using the `ZendDbSqlExpression` class. Here's an example:
1. Create an instance of Expression: `$expression = new ZendDbSqlExpression('SUM(column_name)');`
2. Add the expression to your Select object: `$select->columns(['total' => $expression]);`
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
