search

1rosehip / jplist

jPList jQuery Data Grid Controls is a flexible jQuery plugin for sorting, pagination and filtering of any HTML structure (DIVs, UL/LI, tables, etc).
http://jplist.com
Other
436 stars 177 forks source link

PHP and MySQL Data Source #260

Closed renanarozen closed 7 years ago

renanarozen commented 7 years ago

Hi, phptest.txt

I'm using php and MySql data source. I succeeded to see the items but the pagination controller is not working

Glade for your help Renana

1rosehip commented 7 years ago

Hi, Please check you php log to see if there any errors related to jplist or pagination control. Also please follow jPList guidelines for opening issues.

Best regards

renanarozen commented 7 years ago

Hi i can't see any error in my php log Look at the file attached it looks like he start pagination but hide it jplist_p.pptx

Thanks

1rosehip commented 7 years ago

Please check you console network tab and paste response of the appropriate php file (server-html.php or server-json.php)

renanarozen commented 7 years ago

It's server-json.php data.txt

renanarozen commented 7 years ago

Maybe the preview will be more easy data_preview.txt

1rosehip commented 7 years ago

It seems that count property is missing. You can compare with response from here: http://jplist.com/datasourcesexamples/php-mysql-json-handlebars-demo

renanarozen commented 7 years ago

Hi Thanks for your help! Know i see the pagination but it does not do his work I ask for 20 in each page so he show me 2 pages but when i move to the other page the items don't change

In your link i get your demo bur where it is written to sent the count property ?

Sorry I suppose i'm missing somthing

renanarozen commented 7 years ago

Buy the way It's seem if i'm not worng that in the demo from your link when i change the page the items not changing

1rosehip commented 7 years ago

You are right, thank you for reporting this. In any case you can find the count code here https://github.com/1rosehip/jplist/blob/master/server/server-json.php in line 32

renanarozen commented 7 years ago

I't seem that when i i ask for 3 items in page the pagination vanished and when i change to 10 nothing is working

1rosehip commented 7 years ago

The issue is fixed - please download https://github.com/1rosehip/jplist/blob/master/server/domain/pagination.php and recheck

renanarozen commented 7 years ago

Hi I don't understand you fixed pagination.php file and i don't have it From your example http://jplist.com/datasources/php-mysql-data-source => Usage Example all i need is to download js files like jplist.core-ajax.min.js etc... and not php files Where i can find witch files i need and where to put them?

1rosehip commented 7 years ago

It's not possible to implement server side php version without php :)

Please have a look at the php code located here: https://github.com/1rosehip/jplist/tree/master/server Also php demo pages can be found here: https://github.com/1rosehip/jplist/tree/master/demo/php-mysql-demos

I'll update the download page accordingly so it will be more clear.