jQWidgets Forums
jQuery UI Widgets › Forums › Grid › grid filter and localization
Tagged: datagrid, php datagrid, php datagridview, php gridview
This topic contains 7 replies, has 3 voices, and was last updated by Peter Stoev 12 years, 6 months ago.
-
Author
-
We have a huge dataset about 10000 records. We don’t want to bring all data to front end.
We need to do backed pagination of data, so we need the filter condition on a column as well as the criteria so that we can send it to backend via web service and a Stored Proc will execute on the data.
Eg/-
If user does a filtering on a column called firstname with contains and value =ac”, then we need to send that value to the backend and return rows with only “ac” in the firstname.
Second, we want to limit the filter options to only “contains”.
Third, we need to know how to localize “contains” for various languages such as German, etc.
Hi akansha,
See this help topic: php-server-side-grid-paging-and-filtering.htm.
Best Wishes,
Peter StoevjQWidgets Team
http://www.jqwidgets.comwhen i try it for my database table it cant work
who i do it pls tell me any one
Hi Mahabub Rahman,
The sample in the help topic demonstrates how to implement server paging and filtering with the northwind database. You can use the same approach for your own database, but you will need to modify the sample to fit to your data source. In addition, the phpdemos folder in the download package contains samples with php server sorting, filtering, paging and editing. I think they should be helpful.
Best Wishes,
Peter StoevjQWidgets Team
http://www.jqwidgets.comi can try but when i filter records it show no record found.
i can try it and show all records but when i filter records it show no record found.
Hi Mahabub Rahman,
The Grid displays the records returned by the server. If the MySQL query returns 0 records, the Grid will display “No Data to Display” message. For server filtering, take a look at this help topic: php-server-side-grid-filtering.htm.
Best Wishes,
Peter StoevjQWidgets Team
http://www.jqwidgets.com -
AuthorPosts
You must be logged in to reply to this topic.