Newbie q on displaying a db field value in the view


#1

My layout calls a few links like so:

<%= link_to '| Home ', :controller => ‘search’, :action => ‘’%>
<%= link_to '| Search ', :controller => ‘search’, :action => ‘’%>

I would also like to display two values from my user table in the same
layout right after the search: the contents of the name field, and the
contents of a integer field called tokens.

Can somebody please guide me or start me off in the correct direction
please?

Thanks,
Vince


#2

Vince W. wrote:

My layout calls a few links like so:

<%= link_to '| Home ', :controller => ‘search’, :action => ‘’%>
<%= link_to '| Search ', :controller => ‘search’, :action => ‘’%>

I would also like to display two values from my user table in the same
layout right after the search: the contents of the name field, and the
contents of a integer field called tokens.

Can somebody please guide me or start me off in the correct direction
please?

Thanks,
Vince

I hihgly recommend you try some tutorials to get familiar with the rails
basics. Try some of the links here:

But in answer to your question, you retrieve database rows as
ActiveRecord object in your controller, then access the created
variables in your view.

app/controllers/users_controller.rb

class UsersController < ApplicationController
def search
@user = User.find(1) #find user with an id of “1”
end
end

app/views/users/search.rhtml

Greetings <%= @user.name %>!


#3

Vince W. wrote:

My layout calls a few links like so:

<%= link_to '| Home ', :controller => ‘search’, :action => ‘’%>
<%= link_to '| Search ', :controller => ‘search’, :action => ‘’%>

I would also like to display two values from my user table in the same
layout right after the search: the contents of the name field, and the
contents of a integer field called tokens.

Can somebody please guide me or start me off in the correct direction
please?

Thanks,
Vince

You’ll find this in those tutorials mentioned, but you’d have a method
in your controller like:

@users = User.find(:all) - an instance variable (@user), that holds all
(:all) of the rows from your User model.

then in your view:

<% for user in @users %>

  • <%=h user.name %>
  • (name is one of the columns from your database) <* end %>