PHP - big datalist option

Question

I have function which show 70.000 option values in webpage, is there any option to do "autosuggestion"? Now there is the problem with performance, the browswere are crashed after 2 - 3 searches

while($row_ICAO = $airports_ICAO->fetch_assoc()) {

echo "<option value='{$row_ICAO['ICAO']}'></option>";
}

Maybe there is another option to do this and browsers won't crash?

Here is example you can use for multiple option search... jsfiddle.net/jgf5fkfL/105 — BhAvik Gajjar
– BhAvik Gajjar, Commented Jan 27, 2023 at 9:13

Piyush Sapariya · Accepted Answer · 2023-01-27 09:04:28Z

-1

@Dayek,

I will prefer this. First don't fetch any data when form load. when user click on select2 input provide search functionality, when user start typing for search at that time you need to implement ajax call for fetch related data ( user type in select2 search input ) from database table. Please refer this link

answered Jan 27, 2023 at 9:04

Piyush Sapariya

6245 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dayek Over a year ago

I solved this problem using "Autocomplete Search Box in PHP MySQL using jQuery UI and Ajax"

Piyush Sapariya Over a year ago

Happy to hear that, you solved issue. :)

Rick James Over a year ago

@Dayek - You can self-answer the question and take the answer-points. But be sure to give an overview of how that package works, plus a link to it.

Collectives™ on Stack Overflow

PHP - big datalist option

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related