Actually I am doing a matrimony website in php I have around 50+ input fields in profile page, i would like to show notifications to website admin when user update anything from his profile page
Example: If a user update his contact number from his profile page, I have to show admin that particular user is updated contact number
Actually i am running update query for all 50 field each time when user updated his profile
But I am getting confusing how can I know that user is going to update particular field ?
Please help me
You can have an audit table and a trigger, which should get triggered for any/specific table update.
So, when user make any change to their profile, table will be updated, which will trigger and insert new row.
Other, possible solution would be application level, where you execute insert statement just after any update.