CGI/Perl Guide | Learning Center | Forums | Advertise | Login Site Search: in Perl Guide PerlGuru Forums Learning Ctr

	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

Home: Perl Programming Help: Intermediate: comparing users password to one stored in a database

yim11 Novice Sep 18, 2000, 8:42 AM Post #1 of 2 (252 views) comparing users password to one stored in a database Can't Post Hello, I am [trying] to write a script that will allow employees to clock in and out for work, and calculate the work hours for the week. I plan to use a pipe-delimited text file for the database. In the database, I plan to have fields such as username, password, timein, timeout, totaltime, etc. What I am looking for help on is how to compare and match user input to input already in the database, specifially for login purposes. In other words, I would like to have all users and passwords in the database so that a user can pull up the script/page and type in their username/password and upon clicking submit the script would search the database file, match the username, then compare the passwords (one entered vs one in database) if they match -return page A, if they dont return page B. Any suggestions/help/references are greatly appreciated!!! TIA, Jim

fashimpaur User / Moderator Sep 22, 2000, 7:39 AM Post #2 of 2 (252 views) Re: comparing users password to one stored in a database [In reply to] Can't Post Dont save the password to the delimited file as clear text. Do you realize how vulnerable that leaves your application to someone hacking? Use crypt and a dual character random seed at least to encrypt the password into the data file. To test the encrypted password for a match, find the encrypted password for the userID, parse of the first two characters, use it as the seed for the crypt function with the password entered and see if the result of this crypt matches the crypted password in the database. Much safer. Also, depending on the number of employees, you might rather use an SQL compatable database like Sybase, SQL Server, MSAccess, etc. Hope these ideas help. Dennis

Announcements     PerlGuru Announcements Perl Programming Help     Frequently Asked Questions     Beginner     Intermediate     Advanced     Regular Expressions     mod_perl     DBI     Win32 Programming Help Fun With Perl     Perl Quizzes - Learn Perl the Fun Way     Perl Golf     Perl Poetry Need a Custom or Prewritten Perl Program?     I need a program that...     I Need a Programmer for Freelance Work     Throw Down The Gauntlet General Discussions     General Questions     Feedback     Tutorial/Article Suggestions for The Learning Cent     Internet Security Other Programming Languages     Javascript     PHP

Search this forum this category all forums for All words Any words Whole Phrase (options)

Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives