Mysql queries inside controller class

Question

I have a Usetable contains username and password fields and inserted one value to that table

username:admin password:text In view file contains text boxes for username and password and a login button as follows.

<%= form_tag(:action =>"login", :method => "post", :id=>"frm") do %>

User Name:<%= text_field_tag(:username) %>
Password:<%= text_field_tag(:password) %>
<%= button_to("login ", :class=>"btn") %>
<% end %>

if the enterd username and password is same as the data present in the usertable redirct to home page other wise login is not succesful

What i want is while clicking on the login button pass the username text and password text to controller execute a mysql query like select * from usertable where uername=** and password=**

I dont know how to write mysql query inside controller method.How it is possible? my controller class looks like

    class UsersController < ApplicationController

      def home
        @username=params[:username]
        @password=params[:password]

   # here i have to write that query.#


render :action => :home
  end
end

Iam using rails 3

As a side comment you should not be storing plain passwords in the DB but I'm sure you know that. — bennick
– bennick, Commented May 8, 2013 at 16:07

Soni Kishan · Accepted Answer · 2013-05-08 06:53:34Z

2

Try this @user = User.where(:username => params[:username], :password => params[:password])

answered May 8, 2013 at 6:53

Soni Kishan

4862 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Mysql queries inside controller class

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related