Introduction

• Introducing "PHP DB Auditor" – your go-to solution for meticulous MySQL database system auditing. This powerful PHP package is your key to ensuring the utmost integrity and compliance with MySQL standards and constraints in your database. Dive into the world of database auditing with ease, thanks to its user-friendly command-line interface (CLI).

Key Points

1. Comprehensive Auditing: PHP DB Auditor is a specialized PHP package designed to perform comprehensive audits on MySQL database systems.

2. Thorough Evaluation: It conducts a thorough and detailed evaluation of the entire MySQL database structure.

3. Standards Compliance: The package employs advanced scanning techniques to assess the database's adherence to MySQL standards and constraints.

4. Command-Line Interface (CLI): Users can effortlessly interact with PHP DB Auditor through its intuitive command-line interface, making the auditing process seamless.

5. Constraint Management: PHP DB Auditor empowers you to add essential constraints directly to your MySQL database via the CLI.

6. Detailed Audit Report: Upon completion of the auditing process, the package generates a detailed report.

7. Identifying Non-Compliance: The audit report provides a comprehensive list of tables and columns that fall short of meeting established MySQL standards and constraints.

8. Database Integrity: With PHP DB Auditor, you can proactively maintain the integrity of your database and ensure it aligns with the necessary standards.

Installation & Usage

**Requires PHP 8.1+

Package install

composer require vcian/php-db-auditor

Usage:

**Command configuration

Create a symbolic link in the Ubuntu system using the following command:

ln -s vendor/vcian/php-db-auditor/dbauditor dbauditor

Create a symbolic link in the Windows system using the following command:

mklink dbauditor vendor\vcian\php-db-auditor\dbauditor

Database configuration

The first thing you need to do is configure the database settings in the config.php file.

You can see DB Auditor commands using below command.

php dbauditor

This command provides a list of available commands for database selection, such as checking database standards or verifying constraints.

Note:

If you want to check standalone feature then you can execute below php command one by one.

php dbauditor db:standard

This command give you result with list of table with standard follow indication.

php dbauditor db:constraint

This command gives you result with list of tables with primary,foreign,unique,index constraint.

You can add more constraint to the table by seeing existing constraint with table.

php dbauditor db:summary

This command provides you with information about the database, including its name, size, table count, and character set.

Changelog

Please see CHANGELOG for more information what has changed recently.

Contributing

Please see CONTRIBUTING for details.

   We believe in
        👇
      ACT NOW
  PERFECT IT LATER
CORRECT IT ON THE WAY.

Security

If you discover any security-related issues, please email [email protected] instead of using the issue tracker.

Credits

• All Contributors

License

The MIT License (MIT). Please see License File for more information.