PHP code example of jalallinux / laravel-postgres-audit

1. Go to this page and download the library: Download jalallinux/laravel-postgres-audit library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

jalallinux / laravel-postgres-audit example snippets


return [
/**
     * Target database connection
     */
    'connection' => 'pgsql',


    /**
     * Audit log table name
     */
    'table_name' => 'audit_logs',


    /**
     * Target tables for log
     * Set ['*'] to log for all tables
     * Split tables with comma
     */
    'target_tables' => '*',


    /**
     * Except tables for log
     * Except tables has more priority than target tables
     * Split tables with comma
     */
    'except_tables' => 'migrations, password_resets, personal_access_tokens, jobs, failed_jobs, notifications',


    /**
     * Ignore database user activity
     * Example: postgres, forge
     * NULL for logging all users
     * Split tables with comma
     */
    'except_users' => null,


    /**
     * Primary columns
     * Example: id, uuid, slug
     */
    'primary_columns' => 'uuid',


    /**
     * Primary columns type
     * Example: bigint, uuid, varchar
     */
    'primary_columns_type' => 'uuid',


    /**
     * Operations to log
     * Only support INSERT, DELETE, UPDATE
     */
    'operations' => 'INSERT, DELETE, UPDATE'
];

\JalalLinuX\PostgreAudit\PGAudit::where('table_name', 'users')->get()
bash
php artisan vendor:publish --provider="JalalLinuX\PostgreAudit\PGAuditServiceProviders"
shell
php artisan pg-audit:setup