setbased/php-audit

A tool for creating audit tables and triggers for logging data changes in a MySQL database.

1.10.0 2024-09-21 10:51 UTC

Requires

• php: >=8.1
• ext-json: *
• setbased/error-handler: ^1.3.0
• setbased/exception: ^2.3.0
• setbased/helper-code-store-mysql: ^2.2.0
• setbased/php-stratum-middle: ^5.12.0
• setbased/php-stratum-mysql: ^7.0.0
• setbased/typed-config: ^2.0.0
• symfony/console: ^6.4.12

Requires (Dev)

• ext-pcntl: *
• ext-posix: *
• phing/phing: ^3.0.0
• phpunit/phpunit: ^10.5.35
• setbased/phing-extensions: ^3.1.0

MIT

• mysql
• Audit
• triggers

README

PhpAudit is a tool for creating and maintaining audit tables and triggers for creating audit trails of data changes in MySQL databases.

Features

PhpAudit has the following features:

• Creates audit tables for tables in your database for which auditing is required.
• Creates triggers on tables for recording inserts, updates, and deletes of rows.
• Helps you to maintain audit tables and triggers when you modify your application's tables.
• Reports differences in table structure between your application's tables and audit tables.
• Disabling triggers under certain conditions.
• Flexible configuration. You can define additional columns to audit tables, for example: logging user and session IDs.

Using the audit trail you track changes made to the data of your application by the users of the application. Even of data that has been deleted or changed back to its original state. Also, you can track how your application manipulates data and find bugs if your application.

Manual

The manual of PhpAudit is available at Read the Docs.

Contributing

We are looking for contributors. We can use your help for:

• Fixing bugs and solving issues.
• Writing documentation.
• Developing new features.
• Code review.
• Implementing PhpAudit for other database systems.

You can contribute to this project in many ways:

• Fork this project on GitHub and create a pull request.
• Create an issue on GitHub.
• Asking critical questions.
• Contacting us at Gitter.

Support

If you are having issues, please let us know. Contact us at Gitter or create an issue on GitHub.

For commercial support, please contact us at [e-mail].

License

The project is licensed under the MIT license.