How to make modification records in a Mysql Table (without using triggers )?

Question

I wonder if there is another technique to make records of modifications in the tables without going through triggers ?

Answer 1

André, good morning

If it is via some language, like PHP for example, you can create a log for example:

<?php


function gravaLog($text){

$data = date("d-m-y");
$hora = date("H:i:s");

$arquivo = $data.".txt";     

$texto = "[$hora] - $msg \n";

$arr = fopen("$arquivo", "a+b");
fwrite($aar, $texto);
fclose($aar);

}

?>

Then to each function that manipulates the bank you would call, example:

function insereBanco($reg){
     //sua funcao
     gravaLog("O registro " . $reg . " foi inserido no banco")
}

function alteraBanco($reg){
     //sua funcao
     gravaLog("O registro " . $reg . " foi alterado no banco")
}
function deletaBanco($reg){
     //sua funcao
     gravaLog("O registro " . $reg . " foi excluido no banco")
}