PHP download

Download the PHP package karelwintersky/monolog-pdo-handler without Composer

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

Table of contents
Download karelwintersky/monolog-pdo-handler
More information about karelwintersky/monolog-pdo-handler
Files in karelwintersky/monolog-pdo-handler

Vendor karelwintersky
Package monolog-pdo-handler
Short Description A handler for Monolog that stores data via PDO driver to Database
License MIT
Homepage https://github.com/KarelWintersky/monolog-pdo-handler

Keywords log logging database monolog pdo

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?

Example code of karelwintersky/monolog-pdo-handler

Informations about the package monolog-pdo-handler

monolog.KW-PDO-Handler

PDO Handler for Monolog, which allows to store log messages in a MySQL Database via PDO handler.

Handler can log text messages to a specific table and creates the table automatically if it does not exist.

Installation

karelwintersky/monolog-pdo-handler is available via composer.

Minimum PHP version is 7.1

Usage

Just use it as any other Monolog Handler, push it to the stack of your Monolog Logger instance. The Handler however needs some parameters:

$pdo - PDO Instance of your database. Pass along the PDO instantiation of your database connection with your database selected.
$table - The table name where the logs should be stored.
$additional_fields - associative array of additional database fields definitions. All additional columns are created automatically and the fields can later be used in the extra context section of a record. See examples below. Default is empty array.
$additional_indexes - associative array of additional database indexes definitions. Default is empty array
$level - The minimum logging level at which this handler will be triggered. Must be any of standard Monolog logging levels (default: Logger::DEBUG)

Default fields at logging table

id - defined as BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY;
ipv4 - defined as int(10) unsigned DEFAULT NULL, will contain client IPv4 or 127.0.0.1 for console scripts;
time - defined as TIMESTAMP, will contain current timestamp;
level - defined as SMALLINT, logging level;
channel - defined as VARCHAR(64), channel name,
message - defined as LONGTEXT, message

Examples

Given that $pdo is your database instance, you could use the class as follows:

Note: SQLite does not support 'USING method' for indexes;

ToDo

[ ] Check and override default field definitions
[ ] Update readme : how to write custom indexes
[ ] Update readme : about SQLite.
[ ] Implement default indexes for PostgreSQL

License

This tool is free software and is distributed under the MIT license. Please have a look at the LICENSE file for further information.

All versions of monolog-pdo-handler with dependencies

PHP Build Version

Package Version

Version 0.7 Release 19. Sep 2024
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of monolog-pdo-handler from vendor karelwintersky

Requires php Version >=7.1
ext-pdo Version *
monolog/monolog Version >1.4.0

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 karelwintersky/monolog-pdo-handler contains the following files

Loading the files please wait ....