Stack Overflow
Stack Overflow

Questions tagged [knppaginatorbundle]

SEO friendly Symfony2 paginator to sort and paginate.

32 questions
10
votes
3 answers

How to use KNPPaginatorBundle to paginate results using Doctrine Repository?

I'm working on a Symfony2 project and I decided to use KNPPaginatorBundle to build an easy pagination system. So I created a Product entity and I want to add the paginator to indexAction action (generated by CRUD command). // Retrieving…
K4timini
  • 711
  • 2
  • 14
  • 34
4
votes
1 answer

Knp paginator get all rows total

As I noticed in SQL query logger Knp paginator at first counts all records available and then in second query retrieves records that are needed in requested page. I wonder if there is some way to update first query to retrieve additional counts/sums…
dMedia
  • 809
  • 1
  • 10
  • 18
2
votes
1 answer

knp paginator bundle filtration settings

I use this bundle in symfony 4, my filtering code looks like this {{ knp_pagination_filter(paginator, { 't.code': 'Code' }) }} as well as my settings file in the /conf/ directory knp_paginator: page_range: …
Evgeny Melentev
  • 63
  • 9
2
votes
0 answers

Symfony 3 - [KNP Pagination and sorting] Sorting for native query issue

In my application I am using two databases, One is application database and another one is used to fetch data for the application [Using normal sql statements to fetch data] I want to display 2nd database's data in my application, everything is…
Harshul Routhu
  • 125
  • 1
  • 15
2
votes
1 answer

Symfony2 KnpPaginator bundle Get Data from multiple entities and render in one Grid/Pagination

I have a scenario where a role called MIS_Data_Entry. The Job of role is to input data in muliple entites. but it's key field `verified is set to false'. The MIS_Manager recieves these data and either accept it or reject. Now for MIS_Data_Entry. I…
Muhammad Taqi
  • 5,356
  • 7
  • 36
  • 61
1
vote
1 answer

how can i append an anchor to the url using knp_paginator

I am using symfony 4.4 to develop an e-commerce website. I have a section with an id="projects" at the centre of the page so you have to scroll down to reach it. This section is built with knp paginator inside my ProductRepository to make it work…
zwayten
  • 21
  • 4
1
vote
1 answer

FormCollection and KnpPaginator Symfony 4

Privet all! I'm new to Symfony 4 and generally to PHP and OOP in general. I was helped to make the form using FormCollection the code looks so AbilityContoller.php /** * @Route("/edit", name="ability_edit_all") */ public function…
Evgeny Melentev
  • 63
  • 9
1
vote
1 answer

How do I get total count for a search query in the controller in Symfony

Use case: I want to store the search query and the total number of results to the db so I can see what people are searching for that doesn't exist in my application. What is working: I'm able to get and store the query, but I can't figure out how to…
coreyg
  • 428
  • 8
  • 18
1
vote
1 answer

Ordered pagination with MySQL

UPDATE: In the following question, I thought when you select rows, MySQL create a kind of row index, and then the LIMIT and OFFSET clause cuts off this list by its numbers. The problem is I'm using wrong values or field combination to sort the rows…
Victor Salvans Montesó
  • 390
  • 3
  • 15
1
vote
1 answer

Twig extension method argument which is not specified in twig filter

This code is from the symfony Knp-paginator-bundle and lives in a Twig Extension class (PaginationExtension.php). I'm wondering (just curiosity) where the second argument: SlidingPagination $pagination in the render() method comes from, since this…
John Doe
  • 259
  • 1
  • 6
  • 18
1
vote
1 answer

how to functional test sites with knp_pagination_sortable()?

How to functional test sites with knp_pagination_sortable() ? {{ knp_pagination_sortable(foo) }} In browser same url got different content than in functional test. $crawler = $client->request('GET',…
user6827096
  • 1,186
  • 1
  • 11
  • 26
1
vote
1 answer

Override KNP Paginator entity

I am currently working with KNP Paginator to paginate results. I get serialize paginator object and get response in following form: "current_page_number": 1 "num_items_per_page": 5 "items": [5] "total_count": 35 "paginator_options": { …
blahblah
  • 1,010
  • 15
  • 40
1
vote
1 answer

Paginate results whit KipPaginatorBundle fail

I'm create form search like this : when I run the search , it shows me the first page with 10 elements, but when I click on page 2 , it shows me all the elements of my database without considering my criteria search. I do not understand class…
Darkness007
  • 93
  • 2
  • 12
1
vote
0 answers

The definition for "knp_paginator" has no class

hi i installed the KnpPaginatorBundle in py project and i flow all the steps in the documentation, the problem is when i open the page i got this exception : RuntimeException in CheckDefinitionValidityPass.php line 63: The definition for…
Amine Harbaoui
  • 1,247
  • 2
  • 17
  • 34
0
votes
0 answers

KnpPaginatorBundle, how to set fixed direction for sortable link

SLOVED: Solved by adding an extra empty array {} as mentioned here https://github.com/KnpLabs/KnpPaginatorBundle/blob/master/docs/templates.md#choose-the-sorting-direction {{ knp_pagination_sortable(properties, 'Price Low To High', 'p.price',…
hous
  • 2,577
  • 2
  • 27
  • 66
1
2 3