Need some idea about CMS.

Dear all,

How/ which way should i develop for the system setup (delete function) function for the CMS?

currently, i set the status for data to disabled so that the data wouldn't display to user.

the way i develop because:
we can't direct delete from database because of audit purpose & some time we can prove to user he/she had accident deleted the data.

for you all, isn't done the same way with me?? Or other way??

isn't had a standard way to developed it??

Isn't we can direct block the delete function if the data linked/used to/by other function? Or depended?

I m a new programmer with 8 month working experience.

thanks.

I might not be understanding the question, but here's my thoughts anyhow ...

I assume you're using MySQL as your database and the content is text
or something that is stored as blocks with some sort of ID (date, whatever).

Add another field in the database table for "enable". That way, you keep
the block of content, but enable or disable from view. It can stay retained
for audit purposes and simply remain invisible.

I might not be understanding the question, but here's my thoughts anyhow ...

I assume you're using MySQL as your database and the content is text
or something that is stored as blocks with some sort of ID (date, whatever).

Add another field in the database table for "enable". That way, you keep
the block of content, but enable or disable from view. It can stay retained
for audit purposes and simply remain invisible.

this what i done now.

How about if the data had link to other?
We can direct block the delete function for user?

If we not block, user delete the data, and caused the data linked may not display.

what should i done on it?? direct block it?

But if i done the method, it may cause slow of loading of the pages. Cause need a lot of checking on it.

i m using PHP and MySQL database.