public static function Update($ShopObject)
{
$DataBaseHelper = new DataAccessHelper();
$sql = "UPDATE `shop` SET shop_name='" . $ShopObject->getShopName() . "', shop_address='" . $ShopObject->getSAddress() . "',shop_description = '" . $ShopObject->getSDesc() . "', shop_type_id = '" . $ShopObject->getSTid() . "',date_time = '" . $ShopObject->getDate() . "',user_id = '" . $ShopObject->getUserID() . "' WHERE shop_id = '" . $ShopObject->getShopID() . "'";
// Write your Query here
return $DataBaseHelper->ExecuteQuery($sql);
}
public static function Update($UserObject)
{
$DataBaseHelper = new DataAccessHelper();
$sql = "UPDATE `user` SET user_name='" . $UserObject->getUserName() . "', user_pass='******',user_email = '" . $UserObject->getEmail() . "', date_time = '" . $UserObject->getDate() . "' WHERE user_id = '" . $UserObject->getUserID() . "'";
// Write your Query here
return $DataBaseHelper->ExecuteQuery($sql);
}
public static function UpdateIsCompleted($table, $id)
{
$updateSQL = 'update ' . $table . ' set iscompleted=1 where product_id=' . $id . '';
$DataBaseHelper = new DataAccessHelper();
$DataBaseHelper->ExecuteQuery($updateSQL);
//echo $updateSQL;
}
