Prestashop SQL Query (Select, Update, Delete and Get Single Row)

[Deep Kumar]

Select Query-

$select_data = Db::getInstance()->ExecuteS('SELECT * FROM '._DB_PREFIX_.'tablename WHERE id  = '.(int)$id);
dump($select_data);  // Check Result

Get Single Row- 

$get = Db::getInstance()->getRow('SELECT * FROM '._DB_PREFIX_.'tablename WHERE id= "'.pSQL($id_data).'"');
dump($get);  // Check Result

Update Query-

$update_data ='UPDATE '._DB_PREFIX_.'tablename SET fieldname = 1 WHERE id_product = '.$id_product;
Db::getInstance()->execute($update_data);

Delete Query-

Db::getInstance()->executeS('DELETE FROM '._DB_PREFIX_.'tablename WHERE id = '.(int)$id);