This project is an example on how to use ZF2 Paginator and Doctrine 2 together.

• Clone this project by typing https://github.com/rosantoz/zf2-paginator-doctrine on your terminal;
• Enter the project directory: cd zf2-paginator-doctrine
• Update composer (optional): php composer.phar self-update
• Run composer: php composer.phar install
• Create a local.php file on config/autoload folder and insert your database credentials

<?php
return array(
    'doctrine' => array(
        'connection' => array(
            'orm_default' => array(
                'driverClass' => 'Doctrine\DBAL\Driver\PDOMySql\Driver',
                'params'      => array(
                    'host'     => 'localhost',
                    'port'     => '3306',
                    'user'     => 'root',
                    'password' => '1234',
                    'dbname'   => 'zf2_doc_paginator',
                    'encoding' => 'utf8',
                )
            )
        )
    )
);

• Use doctrine command line tool to create the database table php public/index.php orm:schema-tool:create
• Use doctrine command line tool to create data fixtures php public/index.php data-fixture:import

For a more detailed explanation go to http://blog.dossantos.com.au/using-zf2-paginator-plus-doctrine-2