How to make an input to search from database based on select option in Rails 5

Question

So I have a form where in an input (type: text) and a select option one next to each other. I want to be able when choosing an option from the select option (either "search from your food" or "search food") to search from the corresponding table in the database. For example: You choose from the select option "search from your food" so in the text input you query the "user_food" table. If you choose "search food" you query the "food" table. Oh, by the way I use Sqlite3 as a database (the standard for Rails).

This is how the input looks so far:

And this is the code for it:

Any help would be appreciated! Thanks in advance!

score 1 · Answer 1 · answered Mar 04 '18 at 03:24

1

View:

<%= select_tag :food_selection, options_for_select([['Search for food', 'foods'], ['Search your food', 'user_foods']]) %>

Controller

if params[:selection] == 'foods'
  @foods = Food.where('...')
else
  @foods = UserFood.where('...')
end

@foods = @foods.limit(20) # chain methods here they both share

answered Mar 04 '18 at 03:24

Tallboy

12,847
13
82
173

Great! Will this work only when submitting the form? Is there a way to search it without submitting the form, because there are multiple inputs like these and I need to be able to select an item before submitting the form. – Alexander Bogdanov Mar 04 '18 at 03:35
So do you mean like an AJAX request in the background? – Tallboy Mar 04 '18 at 04:25
Yeah something like that. – Alexander Bogdanov Mar 04 '18 at 16:57
Ah, that's javascript then. Look at jQuery and `$.ajax` – Tallboy Mar 04 '18 at 20:20

How to make an input to search from database based on select option in Rails 5

1 Answers1