How to solve direct object instantiation warning

Question

I used following code

->order(new \Zend_Db_Expr('FIELD(option_id,' . implode(',', $totalPro).')'));

That give following warning.

Direct object instantiation (object of \Zend_Db_Expr) is discouraged in Magento 2.

How to remove this warning?

Have you tested: ->order(\Zend_Db_Expr('FIELD(option_id,' . implode(',', $totalPro).')')); Magento doesn't use new \Class\Name instead of that they have implemented an object manager. — DavidVR, Apr 12 '18 at 16:00
@DavidVR already tried Fatal error: Uncaught Error: Call to undefined function Zend_Db_Expr() — Qaisar Satti, Apr 12 '18 at 16:05
@QaisarSatti try first store value in a variable and then use a variable in query. Check this core file: vendor/magento/module-review/Model/ResourceModel/Rating.php — Prince Patel, Apr 12 '18 at 16:54
@PrincePatel magento 2 is using Zend_Db_Expr but got the same error on core file not allowed. — Qaisar Satti, Apr 12 '18 at 17:09

Rohan Hapani · Accepted Answer · 2018-04-13 01:15:54Z

5

Please use this :

\Magento\Framework\DB\Sql\Expression

Rohan Hapani

16.3k6 gold badges46 silver badges90 bronze badges

answered Apr 12 '18 at 18:48

KAndy

19.9k3 gold badges44 silver badges58 bronze badges

Add a comment |

1 Answer 1