search

webismymind / editablegrid

EditableGrid is an open source Javascript library aimed at turning HTML tables into advanced editable components. It focuses on simplicity: only a few lines of code are required to get your first table up and running.
http://www.editablegrid.net
Other
795 stars 272 forks source link

Can it fetch 1000 records in Select Dropdown? #126

Closed coolguys5253 closed 8 years ago

coolguys5253 commented 8 years ago

We want to fetch 1000 Customer Names in Select Dropdown Like this But Whole Page is blank???

$grid->addColumn('Customer_No', 'Customer', 'string', fetch_pairs($mysqli,'SELECT No, Name FROM customers'),true ); in loaddata.php

jybeaujean commented 8 years ago

Try to call loaddata.php directly in your browser and send me the result.

coolguys5253 commented 8 years ago

Hello Jean,

It is showing Blank Page. Thanks a lot for your concern.

I have attached My folder containing all file with demo.sql of my database also

https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Virus-free. www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Wed, May 18, 2016 at 11:32 AM, Jean-Yves Beaujean < notifications@github.com> wrote:

Try to call loaddata.php directly in your browser and send me the result.

— You are receiving this because you modified the open/close state. Reply to this email directly or view it on GitHub https://github.com/webismymind/editablegrid/issues/126#issuecomment-219933014

nikolassharp commented 8 years ago

@coolguys5253 I'm not sure but probably your issue may be related to PHP's maximum limit in 1000 max_input_vars in a request. Accidently I've had the same problem few months ago and debuging with php_errors shows php's error when sending more than 1000 var in request.

Look for this also: http://stackoverflow.com/questions/8710185/new-limit-within-php-1000-fields-per-post-does-someone-know-if-the-number-can

coolguys5253 commented 8 years ago

It was char encoding as Jean suggested.

Thanks for your advice too :)

https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Virus-free. www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Wed, May 18, 2016 at 3:23 PM, nikolassharp notifications@github.com wrote:

@coolguys5253 https://github.com/coolguys5253 I'm not sure but probably your issue may be related to PHP's maximum limit in 1000 max_input_vars in a request. Accidently I've had the same problem few months ago and debuging with php_errors shows php's error when sending more than 1000 var in request.

Look for this also:

http://stackoverflow.com/questions/8710185/new-limit-within-php-1000-fields-per-post-does-someone-know-if-the-number-can

— You are receiving this because you were mentioned. Reply to this email directly or view it on GitHub https://github.com/webismymind/editablegrid/issues/126#issuecomment-219979447