use strict;
use DBI;

# set up variables stuff omitted

my $dbh = DBI->connect( $connection_string, $user, $pass );

my $value_q = $dbh->quote( $value );

my $sth = $dbh->prepare( "INSERT INTO my_table VALUES 
                         ( $value_q ) " );

## etc...