how to send variable number of arguments to mysql execute()

[fungazid]

Help help help please

I’m using DBD::mysql, and I want to insert a record into clients table (id, address, and phone-number of a client):

my $str= “?,?,?,,,”; 
my @args1=('Zalman','Zalmanovich',12121,'New York');
 
$q=$dbh->prepare("INSERT INTO $table VALUES($str)") 
         or die "Couldn't prepare statement: " . $dbh->errstr; 
 
$q->execute($args1[0],$args1[1],$args1[2],…) 
        or die "Couldn't execute statement: " . $q->errstr; 
 

THE PROBLEM:
If I want to change the number of arguments sent to execute(), I must change the source code inside execute() brackets.
I would like to be able to change it on run-time with something like:

$q->execute(f(@args1)) 
      or die "Couldn't execute statement: " . $q->errstr; 
 

where f() formats the input to the function, so @args1 is allowed to have a variable size.
This may add invaluable flexibility to my program, because my program works with different kinds of clients tables, but how to do it ????.


thanks for your advices

[eWish]

If I understand you correctly, you are using placeholders and you want to have more or less arguments and you want your code to adapt to it automatically which placeholder dosen't do real well. Is that correct?

--Kevin

[eWish]

You can do something like this, then fine tune it for your needs.

my @array = ();
 
my $id = $q->param('id') || undef;
my $address = $q->param('address') || undef;
my $phone = $q->param('phone') || undef;
 
   push(@array, $id,$address,$phone);
 
my $count = @array;
my $placeholders = join(',', (split//, '?' x $count));
 
my $insert_statement = $dbh->prepare(qq{INSERT INTO $table_name(id,address,phone) VALUES($placeholders)});
   $insert_statement->execute(@array);
   $insert_statement->finish();

--Kevin