I am making a web application where every interaction that the user makes in the system saves it in a table of the database, including before and after the update.
I have a code where I consult the data before the update first and store it in an array, then store the new data in a second array.
Later I go through the arrangements and compare each one of the elements of the arrangement and I create the mysql query as soon as they go straight.
I know that the mysqli_affected_rows statement exists but it returns the number of records or rows that were affected by the query.
My question is if there is a sentence that returns the fields that have been modified to save me the cycle I do when traversing the arrays.