simple rails search form not working

debugcn Published at Dev

joey

I have a very simple, typical search form in rails. Input a string, and it checks a column for that model if any strings match it. A few weeks ago it was working just fine. I came back today, and suddenly doesn't work.

Here is my code. My search form:

<%= form_tag("/search/products", method: "get") do %>
  <%= label_tag(:q, "Search for:") %>
  <%= text_field_tag(:q) %>
  <%= submit_tag("Search") %>
<% end %>

My Controller:

def search
 term = params[:q]
 puts "the term is #{term}"
 @resultats = Product.search_products(term)
end

In my model, the search_products method:

  def self.search_products(search_term)
    if search_term == ""
        return []
    else
        where("name LIKE ?", "%#{search_term}")
    end
  end

in the controller code, the puts "the term is #{term} prints the correct term every time. So I know that is being picked up correctly. just, when i search for something, it doesn't return the correct results. Here is a screenshot from my terminal:

"Les résultats sont" in the terminal means "the results are..." and then empty, because it returns nothing. What could be wrong here?

Shadow Radiance

Your code currently searches for LIKE '%term' (string must end in term)

You probably need to have it search for LIKE '%term%' (string must contain term)

Just add a %:

where("name LIKE ?", "%#{search_term}%")

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-16

Comments

0 comments

From Dev

Related Related

Article

simple rails search form not working

simple rails search form not working

Simple search not working on rails app

Search Form In Rails Application Not Working

form search not working in rails app

Ruby on Rails - Simple Form autocomplete association search

Rails : Simple search form, with keywords jambled

Rails Simple_Form Association Not Working

rails gem Simple_form installation is not working

search form not working and gives error in rails app

Rails 4, Bootstrap 3, simple_form - form styling not working

Search function not working in footable when rendering partial form in rails 4

PHP Simple Search Form

Rails Simple Search

Rails Simple Search

Simple step form not working

Simple form not working

Rails Devise & Simple Form

Rails with Simple Form - Styling

Why won't my simple Rails form_tag search form provide results using the right method?

Rails search form with no path

Simple_form class form-horizontal with bootstrap 3 not working in rails 4

Simple_form class form-horizontal with bootstrap 3 not working in rails 4

HTML Form not working in rails

Ruby simple search form error

Ruby simple search form error

PHP/MYSQLI simple search not working

Simple search in jQuery not working properly

Simple Search with Rails - Search Results on Separate Page

Simple PHP submit form not working

Simple PHP submit form not working