PHP Delete and Edit System

[kamal213]

Hi guys,

 

I have a PHP site where logged user can book appointments.

 

I would like the system to be able to monitor which users edited and deleted an appointment or appointments (e.g 'appointment edited/last edited by...').

 

I already understand how to edit and delete appointments from the MySQL, but the problem is how do I display who deleted/edited the appointment/s.

 

Please your ideas and suggestions a more than welcome.

 

Thanks

[phppaper]

create a table in MySQL for log

[Undrium]

Another suggestion is that you do not delete the appointments but use a status flag instead. Then you can have a column named "lastEditedBy" or something similar where you put the users ID.

[kamal213]

Thanks for gettin back to me phppaper.

 

How do I code it so sends all the deleted appointments to the log table?

 

Thanks

[kamal213]

Thanks for your reply undrium

 

Soz for sounding daft but I have never designed something like that befere..how would go about doing that?

 

Thanks buddy.

[phppaper]

Every appointment has an id as primary key right? Just get that ID and insert into the log table with the username and the time before running the delete statement.

[kamal213]

yes all appointments have a primary key id. I will try it out in let you kno how I get on

 

Thanks phppaper