tohobaby Posted October 9, 2014 Share Posted October 9, 2014 Hi, I wish to find out is there any possible that I can delete some data inside my php website but inside my sql database, the record will still at there? Thank you. Quote Link to comment https://forums.phpfreaks.com/topic/291525-is-it-possible-to-delete-data-from-webpage-but-do-not-delete-from-database/ Share on other sites More sharing options...
Frank_b Posted October 9, 2014 Share Posted October 9, 2014 Just add a column with a name like 'deleted' and set a 1 if a user deletes the record instead of really deleting the record. Then change yr select queries, you will need to add a WHERE deleted != 1 And ready. 1 Quote Link to comment https://forums.phpfreaks.com/topic/291525-is-it-possible-to-delete-data-from-webpage-but-do-not-delete-from-database/#findComment-1493116 Share on other sites More sharing options...
ginerjm Posted October 9, 2014 Share Posted October 9, 2014 Are you just saying that you want the user to be able to filter what data shows up on the page? For ex. you do a query and show him 10 records. Then he clicks on a couple of rows on the screen because he didn't want them and you have to re-build the page leaving those two off? Simply do as Frank said - change your query to exclude those two records by their key value and re-run the query. Quote Link to comment https://forums.phpfreaks.com/topic/291525-is-it-possible-to-delete-data-from-webpage-but-do-not-delete-from-database/#findComment-1493131 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.