Download the PHP package vcian/php-db-auditor without Composer

On this page you can find all versions of the php package vcian/php-db-auditor. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Informations about the package php-db-auditor

Logo PHP DB Auditor

Packagist License Total Downloads

Introduction

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

**Requires PHP 8.1+

As a standalone project under linux

# create directory (feel free to give your own)
mkdir dbauditor
cd dbauditor

# install package
composer require vcian/php-db-auditor

# create symbolic links
ln -s vendor/vcian/php-db-auditor/dbauditor dbauditor
ln -s vendor/vcian/php-db-auditor/src/config.php config.php

# edit config.php to configure the database settings

As a standalone project under windows

# create directory (feel free to give your own)
mkdir dbauditor
cd dbauditor

# install package
composer require vcian/php-db-auditor

# create symbolic links
mklink vendor/vcian/php-db-auditor/dbauditor dbauditor
mklink vendor/vcian/php-db-auditor/src/config.php config.php

# edit config.php to configure the database settings

Usage:

See database information

php dbauditor db:summary

PHP DB Auditor Standard UI

See a list of table with standard follow indication

php dbauditor db:standard

PHP DB Auditor Standard UI

PHP DB Auditor Standard UI

PHP DB Auditor Standard UI

See a list of tables with fields, primary, foreign, unique, index constraint.

php dbauditor db:constraint

PHP DB Auditor Constraint UI

PHP DB Auditor Constraint UI

You can add more constraint to a table.

PHP DB Auditor Constraint UI

PHP DB Auditor Constraint UI

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

License

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

All versions of php-db-auditor with dependencies

PHP Build Version
Package Version
Requires symfony/console Version ^6.3
php Version ^8.1
doctrine/dbal Version ^3.6
nunomaduro/termwind Version ^1.15
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package vcian/php-db-auditor contains the following files

Loading the files please wait ....