CODE EXAMPLE FOR PHP

how to check history of database in phpmyadmin

To view the past queries simply run this query in phpMyAdmin.

SELECT * FROM `general_log`
if it is not enabled, run the following two queries before running it.

SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';