How to display a single record from database in ruby on rails

Question

I am very new to ruby on rails and am developing a catalogue application. I have set up my database and have added some entries. At the moment on my main page it is displaying all the data in my database but how do i go about just displaying one record for example. Here is my code:

<% if notice %>
    <p id="notice"><%= notice %></p>
<% end %>

<h1>Bann.com - slightly smaller than Amazon!</h1>

<% @products.each do |product| %>
  <div class="entry">

<table border="1">
    <tr>
        <th>Header 1</th>
        <th>Header 2</th>
    </tr>
    <tr>
        <td><%= image_tag(product.image_url) %></td>
        <td><%= image_tag(product.image_url) %></td>
    </tr>
    <tr>
        <td><h3><%= product.title %></h3>
            <div class="price_line">
              <span class="price"><%= number_to_currency product.price, :unit=>'&pound;' %></span>
            </div>
              </div></td>
        <td>row 2, cell 2</td>
    </tr>
</table>
<% end %>

Not related to the main question, but it looks like you've got an extra </div> in the second row of your table. — Zach
– Zach, Commented Dec 17, 2013 at 15:10

kddeisz · Accepted Answer · 2013-12-17 15:07:22Z

2

Right now you're looping over everything in products in your @products.each do |product| loop. If you wanted to display just the first of these, you could:

<% if notice %>
  <p id="notice"><%= notice %></p>
<% end %>

<h1>Bann.com - slightly smaller than Amazon!</h1>
<% product = @products.first %>
<div class="entry">
  <table border="1">
    <tr>
      <th>Header 1</th>
      <th>Header 2</th>
    </tr>
    <tr>
      <td><%= image_tag(product.image_url) %></td>
      <td><%= image_tag(product.image_url) %></td>
    </tr>
    <tr>
      <td>
        <h3><%= product.title %></h3>
        <div class="price_line">
          <span class="price"><%= number_to_currency product.price, :unit=>'&pound;' %></span>
        </div>
      </td>
      <td>row 2, cell 2</td>
    </tr>
  </table>
</div>

Also I fixed your divs. You've got a close div in the middle of your table when your start div is before it.

answered Dec 17, 2013 at 15:07

kddeisz

5,2123 gold badges24 silver badges46 bronze badges

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

2 Comments

jreid423 Over a year ago

@user Thanks, this works well however if I wanted to add multiple products can I just assign products.first to a variable and then products.second to another variable to build up a library of products or should I do this another way?

kddeisz Over a year ago

The .first and .last methods are given, but the rest you'll have to access like a normal array. For instance, the third element would be products[2] and the fifth would be products[4].

Miotsu · Accepted Answer · 2013-12-17 15:10:26Z

0

<% @products.each do |product| %>

is iterating through all the elements of the @products array, which is defined in your controller.

If you want to display just one product, you first have to decide which one, then retrieve it from the database in your controller, and use it to set a variable, eg @product, which will be then available in your view.

Good luck.

answered Dec 17, 2013 at 15:10

Miotsu

1,77618 silver badges30 bronze badges

Comments

dax · Accepted Answer · 2013-12-17 15:19:20Z

0

<% @products.each do |product| %> is looping through all the data in your Product table.

if you open your terminal and type rake routes you'll see a list of all the routes available. Probably you'll see a listing called 'product_path'. What you see is dependent upon what's in your config/routes.rb file. You can read more about that here.

In your view, if you write <% link_to "THIS PRODUCT!", product_path(id: product.id) %> inside of the each loop, you'll be directed to the show page for that specific product (so long as you have a view for it). From there you can start building your product show page. I would suggest you check this guide out and then look up the Michael Hartl tutorial. Both are very helpful :)

edited Dec 17, 2013 at 15:19

answered Dec 17, 2013 at 15:07

dax

11k8 gold badges55 silver badges87 bronze badges

Collectives™ on Stack Overflow

How to display a single record from database in ruby on rails

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related