Re^2: accessing values in hash

ok, i now have:
#fetch two colums (username , password)

while($hash_ref = $sth->fetchrow_hashref){

#dereference
my %values=%$hash_ref;

#print out usernames
print $values{'username'};}
[download]

I can print out all the usernames from the database but do you know how I can match one of these usernames to

$testUsername
[download]

I need to print off something like "username matched"

Comment on Re^2: accessing values in hash Select or Download Code

Replies are listed 'Best First'.
Re^3: accessing values in hash by swampyankee (Parson) on Sep 03, 2006 at 23:37 UTC
OK..let me get this straight. You're querying a database to get all usernames so you can use Perl to see if a given username is present? If that's the case -- and this isn't a rather odd homework assignment -- make the database do the work and write the query to see if the username is present. This way Perl would get a true/false answer from the database, and you wouldn't have to check 8,000,000 usernames In Perl, one way to do it would be to load all the usernames into an array and use grep `$yes = grep { /$username/ } @usernames;` [download] emc Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. Albert Einstein	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: accessing values in hash
by swampyankee (Parson) on Sep 03, 2006 at 23:37 UTC

OK..let me get this straight. You're querying a database to get all usernames so you can use Perl to see if a given username is present?

If that's the case -- and this isn't a rather odd homework assignment -- make the database do the work and write the query to see if the username is present. This way Perl would get a true/false answer from the database, and you wouldn't have to check 8,000,000 usernames

In Perl, one way to do it would be to load all the usernames into an array and use grep

$yes = grep { /$username/ } @usernames;
[download]

emc

Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.

Albert Einstein

[reply]
[d/l]