Update statement not working with single quotes and with double quotes gives error as use single quo

[Edge_jr]

Hi,

 

I have problem in writing update statement in single quote with php variable having data.

 

If I use single quote then statement do not work,if I use double code then I get error using code sniffer as per PS standards "String " UPDATE `" does not require double quotes; use single quotes instead"

 

if (!Db::getInstance()->Execute(" UPDATE `"._DB_PREFIX_."table` SET column ='$value'  ")); /** Working */



if (!Db::getInstance()->Execute(' UPDATE `"._DB_PREFIX_."table` SET column = "'.$value.'" ')) /** Not working */

How to make update statement working with single quote.

 

Please help and advise.

 

-Thanks

Edited May 21, 2015 by edge82 (see edit history)

[presta.show]

Hi try this:

 

if (!Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'table` SET column =\''.$value.'\'  '));