Help for this page

Select Code to Download


  1. or download this
    my $statement = "Insert into TABLE (name, date, type, federal, active)
    + values( ?, ?, ?, ?, ? );
    
    ...
      $sth->bind_param( $i++, $holidays->{$name}->{$_} ) foreach keys %{$h
    +olidays->{$name}};
      $sth->execute(); # check errors here too
    }
    
  2. or download this
    my $statement = "Insert into TABLE (name, date, type, federal, active)
    + values( :name, :date, :type, :federal, :active );
    
    ...
      $sth->bind_param( ':'.$_, $holidays->{$name}->{$_} ) foreach keys %{
    +$holidays->{$name}};
      $sth->execute(); # check errors here too
    }