How to work with pagination in Symfony using Doctrine?

To work with pagination in Symfony using Doctrine, you can follow these steps:

Install the KnpPaginatorBundle: Run the following command to install the KnpPaginatorBundle:

composer require knplabs/knp-paginator-bundle

Enable the KnpPaginatorBundle: Enable the KnpPaginatorBundle in your config/bundles.php file:

Knp\Bundle\PaginatorBundle\KnpPaginatorBundle::class => ['all' => true],

Create a custom repository method: In your entity repository class, create a custom method to fetch paginated results using Doctrine's createQueryBuilder() method. For example, you can create a method like this:

public function findAllPaginated($page, $limit) {
    $query = $this->createQueryBuilder('e')
        ->setMaxResults($limit)
        ->setFirstResult(($page - 1) * $limit)
        ->getQuery();

    return $query->getResult();
}

Create a controller action: In your controller, create an action method that fetches paginated results using the custom repository method created in the previous step. For example:

use Symfony\Component\HttpFoundation\Request;
use Knp\Component\Pager\PaginatorInterface;

public function index(Request $request, PaginatorInterface $paginator) {
    $repository = $this->getDoctrine()->getRepository(Entity::class);

    $page = $request->query->getInt('page', 1);
    $limit = 10;

    $entities = $paginator->paginate(
        $repository->findAllPaginated($page, $limit),
        $page,
        $limit
    );

    return $this->render('index.html.twig', [
        'entities' => $entities
    ]);
}

Update your Twig template: Update your Twig template to display the paginated results using the knp_pagination_render() function. For example:

{% for entity in entities %}
    {{ entity.name }}
{% endfor %}

{{ knp_pagination_render(entities) }}

With these steps, you should now have pagination working in your Symfony project using Doctrine and the KnpPaginatorBundle.