Ruby on Rails

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsWeb Design & DevelopmentRuby on Rails

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old November 18th, 2011, 03:45 PM
mutago mutago is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Nov 2011
Posts: 2 mutago User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 m 29 sec
Reputation Power: 0
Database login problem

hi guys am having problem in accessing my account from a web page below is the code
Code:

#!C:/Ruby095/bin/ruby 
require 'cgi'

cgi = CGI.new
puts cgi.header

require "mysql"



begin
    con = Mysql.new 'localhost', 'root', 'root33', 'db'

    rs = con.query("SELECT * FROM account where username=%s %(username) and password = %s %(password)")
    
    rs.each do |row|
       


 if username == row[0] and password == row[1]:

puts 'login'
else
puts 'no'
end

    end
         
rescue Mysql::Error => e
    puts e.errno
    puts e.error
    
ensure
    con.close if con
end


okay, in the database, i have
username = mutago and password = mutanx22.
when i used sql query by referencing the username and password in this code below,
Code:
 rs = con.query("SELECT * FROM account where username='mutago' and password ='mutax22'")

the applications runs perfectly and only the write user are authenticated
okay now i want to authenticate the users access from web page and i have to look for a parameter symbol
that will be used to repalce username and password variables so that the right user will be authenticate so i set this

Code:
 rs = con.query("SELECT * FROM account where username=%s %(username) and password = %s %(password)")


This query authenticates both the wrong and right users. I think my problems lines in using wrong parameter symbols in the SQL where CLAUSE statement
Code:
  where username=%s %(username) and password = %s %(password)")
[/code}

In php,  it works this way
[code] ("SELECT * FROM account where username=$username and password = $password")
 

and php parameter symbol is $

any help please

Reply With Quote
Reply

Viewing: Tutorialized ForumsWeb Design & DevelopmentRuby on Rails > Database login problem


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap