使用db类进行Prestashop数据库更新

Question

I am a newbie in Prestashop. I am doing a small module. In that module I want to update a table. But my condition is like this it will update those rows whose id is not 3. So for me my table is like this

id      name        active
1       test1       0
2       test4       0
3       test5       1
4       test9       0
5       test12      0
6       test25      0

So as per DB classes I made my query like this

$id = 3;
Db::getInstance()->update('table', array('active'=>'1'), 'id != '.$id );

also I have tried

Db::getInstance()->update('table', array('active'=>'1'), 'id <> '.$id );

But its not working. So can someone kindly tell me how to fix this. Any help and suggestions will be really appreciable.

Answer 1

The solution, as gskema states, is to cast the ID to int:

Db::getInstance()->update('table', array('active'=>'1'), 'id != '.(int)$id );

PrestaShop needs you to pass the appropriate type of value for each column. For the "decimal" type, nevertheless, you can pass in a string, if the value is in the correct format.