How do I save to the database when a "user" or "admin" edits or registers a new item?

Question

I want to know how to save the actions,type, when admin, log in and drop, change a register or create a new register??

Answer 1

I think what you’re looking for is this Triggers
You can create a new table of logs and every Insert, delete or update the Rigger created in the database automatically adds in the table logs the change made and the date for example.

-- In your case it would look something like this:

CREATE TRIGGER NOME_TRIGGER 
AFTER INSERT ON TB_CLIENTE 
FOR EACH ROW
BEGIN
INSERT INTO TB_REGISTROS SET CAMPO_DA_TABELA_REGISTROS = NEW.CLIENTE_NOME;
END;

-- After(after) above means that Trigger will be executed after insertion -- You could also use before(before) for Trigger to run before Insert,update or delete

-- "Insert on" is saying that Trigger will be triggered when an Insert occurs in tb_client -- Could also be used "update on" or "delete on"

-- "For Each Row" says that Trigger Should Execute this command for each new Index

-- The "Begin" word marks the beginning of the command and the "end" word.

-- The Reserved Word "new" Refers to the New Record That Was Inserted, in the example it will insert in the Record Table the name of the new client. Could also be used "old" to get the old value of an update.

To understand better read here

Answer 2

by what I’m seeing Voce wants to create log type I have something similar in a script of mine and this is how it creates the function :

function addlog($msg)
{
global $pdo;
$msg = strip_tags(htmlspecialchars($msg));
$pdo->exec("INSERT INTO fun_log SET msg='".$msg."', data='".time()."'");
}

then just create the table :

CREATE TABLE `fun_log` (
`id` int(255) NOT NULL auto_increment,
`msg` text NOT NULL,
`data` varchar(100) NOT NULL,
 PRIMARY KEY  (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

When you want to register, just call it like that :

$msg = "Fulano fez tal coisa";
addlog($msg);

only an observation if you will use this only for learning and testing ok but if it is for something more serious recommend improving the INSERT leave safer not to take sql example Injection if you use the Pdo passes the data to the bindparam know that it is only a log function more safety in the first place, then just create a pagination with the logs