mardi 6 mars 2018

Applying Search Filter results in 0 search results?

Search form works great. The search filter which takes the search results and filters them some more works great EXCEPT when I use one specific filter which basically allows a person to find a school based on specific tuition price.

Tuition prices are inputted into the database in ranges. For example: "20,000-30,000" would be what can be found in a column cell. The column uses VARCHAR data type.

This is the code for that particular filter:

HTML

 <input name="fees" type="range" min="1" max="200000" value="" class="slider" id="myRange">

PHP

 ->where('fees', '<', '%'.$fees.'%')

If a person searches 10000, any school whose data for that field is LESS than 10000 should show up.

There are over 200 schools in the database but no matter what I search in the filter, 0 results show. Any ideas?



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2I9xeIK
via IFTTT

Aucun commentaire:

Enregistrer un commentaire