Help for this page

Select Code to Download


  1. or download this
    # 1.  Download text-only data. Comma delimited and quoted strings for 
    +?easy? upload.
    my $table = $q->param('dbtable'); # Can be any table in the database
    ...
        my $sql = "INSERT INTO $table VALUES ($record)";
        my $rows = $dbh->do($sql);
    }
    
  2. or download this
    my $sql = "INSERT INTO tablename VALUES(?,?,?,?)";
    my $sth = $dbh->prepare($sql);
    foreach my $record (@filedata) {
        $sth->execute($fa,$fb,$fc,$fd);
    }