Cycle through values in an Ruby Array on a HTML page

Question

I am fetching some rows from the database in my controller with this query :

@main = connection.execute("select code_ver, result from mastertest;")

Now in my html.erb, I am displaying the results in a table like this:

<% @level1.each do |row1| %>
<table id="tbl_main1" name="tbl_main1">
    <tr bgcolor="#D1D1D1">
        <td width="60%" <%= row1[0] %>></td>
        <td width="20%"><%= row1[2] %></td>
        <td width="20%"><%= row1[1] %></td> 
    </tr>
</table>

I am fetching a lot of rows here. But I want to show only say 15 results at once, and have some kind of buttons 'next' and 'previous' which would cycle through the results. How would I do that ?

javascript pagination or will_paginate would do javascript pagination would save requesting the server again and again as oppose to will_paginate — Ratatouille
– Ratatouille, Commented Oct 26, 2012 at 19:02
@user1438735 : Can you show me some sample code for this? Thanks — Pi Horse
– Pi Horse, Commented Oct 26, 2012 at 19:11

ndbroadbent · Accepted Answer · 2012-10-26 19:43:11Z

2

If you're using Rails 3, have a look at kaminari for pagination: https://github.com/amatsuda/kaminari. You are probably interested in the Paginating a generic Array object feature. However, keep in mind that this won't add offsets and limits to your SQL query.

Kaminari is widely considered better than will_paginate for Rails 3, since it takes advantage of Rails scopes and doesn't globally pollute objects.

answered Oct 26, 2012 at 19:43

ndbroadbent

13.8k3 gold badges61 silver badges89 bronze badges

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

Comments

Leo Correa · Accepted Answer · 2012-10-26 19:54:29Z

2

Take a look at this gem https://github.com/mislav/will_paginate

Will_paginate could be useful for what you are looking for.

There are other gems out there as well but I've found will_paginate to fulfill pagination needs.

Edit If you plan to paginate on an array which is what it seem you are doing, you could do:

require 'will_paginate/array'

and then your_array.paginate page: x, per_page: y

x would be the page you want to display and y is the number of items per page.

edited Oct 26, 2012 at 19:54

answered Oct 26, 2012 at 19:01

Leo Correa

20k2 gold badges56 silver badges71 bronze badges

1 Comment

Pi Horse Over a year ago

I can't find any code which shows me how to use pagination while executing a sql2 type query....can you please help me out with it?

brentmc79 · Accepted Answer · 2012-10-26 20:11:47Z

1

I'd suggest creating an Active Record model to represent your mastertest database table. Then, with the help of the will_paginate gem, you could do the following in your controller:

@mastertests = MasterTest.all.paginate(:page => params[:page], :per_page => 15)

And then in your view:

<% @mastertests.each do |mastertest| %>
  <td><%= mastertest.code_ver %></td>
  <td><%= mastertest.result %></td>
<% end %>
<%= will_paginate @mastertests %>

The will_paginate view helper will generate pagination links like [prev] [1] [2] [3] [next]. Take a look at the will_paginate gem on github for more options.

answered Oct 26, 2012 at 20:11

brentmc79

2,5413 gold badges16 silver badges14 bronze badges

Collectives™ on Stack Overflow

Cycle through values in an Ruby Array on a HTML page

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related