Just a Zend\Log\Logger on MySQL

a_log_database.sql

CREATE DATABASE a_log_database;

USE a_log_database;

CREATE TABLE IF NOT EXISTS `log_table_name` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `priority` int(11) NOT NULL,
  `priorityName` varchar(45) NOT NULL,
  `message` varchar(255) NOT NULL,
  `extra_ip` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

t.php

<?php 

require_once __DIR__ . '/vendor/autoload.php';

$dbconfig = array(
    'driver' => 'Mysqli',
    'database' => 'a_log_database',
    'host' => 'localhost',
    'username' => 'username',
    'password' => 'password'
);
$db = new Zend\Db\Adapter\Adapter($dbconfig);

$writer = new Zend\Log\Writer\Db($db, 'log_table_name');
$logger = new Zend\Log\Logger();
$logger->addWriter($writer);

$logger->info('Informational message', array('ip' => '192.168.0.1'));