Check if data already exists

[JackTheRussel]

Hi !
I cant solve this problem by my self and I'll need some help.

I have program which works followin way:
I get information and and I parse that and I get variables:

$first, $second and $third

and then I insert these variables to the database.

open(FILE, $filename);
my @lines=<FILE>;

foreach $t (@lines){

my $str = $t;
my ($first, $second, $third) = split(/\s/, $str, 3);

my $sql_string="insert into table set model='$first', stat='$second', layer='$third'";

$sth = $db_connection->prepare($sql_string);
$sth->execute();
}

And I also have table called

@ecul

where I have samekind of data like I have in $first variables

Now before insert sentence I would like to check do I have already same data in the @ecual table like I have in $first variable.

If there are already same data then do nothing and move to the next record and so on...

But if there arent that data. Then I would like to execute that insert sentence and take them to the database.

How I should do this ? I cant solve this problem?

 

[PaulTEG]

$match=0;
foreach (@ecual) {
  if ($first eq $_) {
    # got a match
    $match=1;
    last;
  }
}
if ($match != 1) {
 #insert in database
}

This would be better as a hash than an array

if (!exists $hash{$first}) {
   $hash{$first}=$first;
   &update_database;
}

HTH

Paul
------------------------------------
Spend an hour a week on CPAN, helps cure all known programming ailments ;-)

 

[JackTheRussel]

Thank you very much!

For now on I'll spend 2 hour a week on CPAN