Database querying through Http in rails?

Question

I am working on rails app , In which I have created a table Product Name:string and Number: integer.

The application should give user a form where he can search a product by his number if product exists it should give product name from database.

My search.html.erb is this.

    <%= form_for @products, :url => { :action => "create" }, :html => {:class =>   "nifty_form"} do |f| %>
    <%= f.text_area :number, :size => "60x12" %>
    <%= f.submit "Search" %>
    <% end

What will be the definition of search Method in ProductController and routes i need to add in routes.rb?

kiddorails · Accepted Answer · 2013-05-12 13:31:26Z

1

Irrespective of nifty forms, this is how I would have done this:
In config/routes.rb replace resources :products' with

resources :products do 
  post 'search', :on => :collection
end

This will give me a search_products_path

In your view:

<%= form_for(:search, :url => search_products_path) do |f| %>
  <%= f.text_field :number, :placeholder => "Enter number to search" %>
  <%= f.submit "Search" %>
<% end %>

In your products_controller.rb

def search
  number = params[:search][:number]
  @result = Product.find_by_number(number)
  @not_found = true unless @result
end

In your views/products/search.html.erb, use @result to show the product information; take care while checking whether or not the desired product is actually found or not. I have set the boolean @not_found in case it doesn't exist.

edited May 12, 2013 at 13:31

answered May 12, 2013 at 12:57

kiddorails

13k2 gold badges34 silver badges42 bronze badges

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

6 Comments

Deepender Singla Over a year ago

i am getting this error on search page .Couldn't find Product with id=search

kiddorails Over a year ago

After passing through controller action to search.html.erb ?

Deepender Singla Over a year ago

I am getting this error after updating all the files suggested by you then navigating to products/search.

Deepender Singla Over a year ago

I have change routes post path to get as through post path it was referring to show method but now i am getting error "undefined method `[]' for nil:NilClass"

kiddorails Over a year ago

@DeependerSingla, Please check that you do not have resources :products anywhere else in your routes.rb. If it is there, please remove that single line.

|

Collectives™ on Stack Overflow

Database querying through Http in rails?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related