Thread nur übergebene Parameter in db eintragen (16 answers)
Opened by wiel at 2006-09-25 22:27

esskar
 2006-09-26 10:57
#34693 #34693
User since
2003-08-04
7321 Artikel
ModeratorIn

user image
Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
12
my @all_fields = qw(ort mv_id mol_id);

my @def_fields = ();
foreach (@all_fields) {
  push @def_fields, $_ if defined $params{$_};
}

if (@def_fields) {
  my $sql = "INSERT INTO recherche (" . join(',', @def_fields) . ") VALUES (" . join(',', '?' x scalar @def_fields) . ")";
  my $sth = $dbh->prepare($sql) or die $dbh->errstr();
  $sth->execute(@params{@def_fields}) or die $dbh->errstr();
}  
\n\n

<!--EDIT|esskar|1159253922-->

View full thread nur übergebene Parameter in db eintragen