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; }