What is the user's list response when the product is removed?

want to ask a question
see what everyone does

suppose there is an item < 1
the user sets up a list after buying item A, and uses the relational database to find 1 and then go to the information table product to introduce purchased goods
suppose one day to delete item A, the user will make an error if he wants to view the product
think about how to do it
I have thought of two ways

when deleting, empty the item A data of product to a deleted item, but when the item is still
list, put the item name and product name of item An into the list

.

what do you think?

Database-design mysql mysqli php7 php
Apr.14,2021

I suggest that when creating an order, associate the product message with the order and make a snapshot , not necessarily delete. The product title pictures may all be open to merchant editors, and the order information should be unique. I can't buy a watermelon today, and tomorrow the merchant will change this link to banana . Then I went to see the historical order become that I bought a banana

yesterday.

instead of actually deleting the Product record, add a Bool field isDelete to identify whether the product was deleted.

  1. Filter deletes the deleted product data when displaying the product list
  2. products that are not deleted by Filter are not displayed when the order is displayed.

Previous: In Angluar, I need to use the data returned asynchronously to set a state to make the page display the corresponding page. What should I do?

Next: The vue, component calls the generic component, how to control the different content in different page display components?

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b34c7c-2bf32.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b34c7c-2bf32.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?