php - Accessing deleted user's information -
i want keep track of user's information after have been deleted form database.
there 2 reasons want this. firstly, after user deleted, want display message reading "$name has been deleted". secondly, want write name of deleted user log file.
what have not work because when user deleted database, name becomes null (i using $_session variables). there way access information? what's cleverest way it?
you put field db signify record "deleted", , appropriate filtering wherever attempt use records 'deleted=true' records not show up, e.g. @ login:
select ... users (username = '...') , (password = '...') , (deleted = false)
this way keep entire user record in database, it's not useable because it's been flagged deleted.
Comments
Post a Comment