sub framerightsave{
my($dbhsource,$dbhinstance,$dbhadmin,$firstfield,$ynfield,$thirdfield,$save,$op) = @_;
my(@inst,@altern,@yn,$curent,$curinst,$curalt,$curyn,$htmld,$n,$savedata);
@yn = split(/\|/,$ynfield);
@altern = split(/\|/,$thirdfield);
@inst = split(/\|/,$firstfield);
print "
";
print "| Save evaluations of instances: $instance |
";
print "| Istanza | Saved evaluation | Alternative evaluation |
";
my $mysqldbinstance=$frameinit::MYSQLDBINS;
$dsninstance = "DBI:mysql:database=$mysqldbinstance;host=$myhost";
$dbhinstance = DBI->connect($dsninstance, $mysqluser, $mysqlpwd)|| print "NON RIESCO A CONNETTERMI\n";
while(@inst){
$curent = shift @inst;
$curyn = shift @yn;
$curaltern = shift @altern;
if($curyn =~ /\w+/){
&updatemysql($curent,$curyn,$curaltern);
}
print "| $curent | $curyn | $curaltern |
";
}
print "
";
}
sub updatemysql{
my($curent,$curyn,$curaltern) = @_;
my($update,$mysqldbinstance,$dsninstance, $dbhinstance, $sthinstance,$rvinstance,$toupdt);
my $mysqldbinstance=$frameinit::MYSQLDBINS;
$dsninstance = "DBI:mysql:database=$mysqldbinstance;host=$myhost";
$dbhinstance = DBI->connect($dsninstance, $mysqluser, $mysqlpwd)|| print "NON RIESCO A CONNETTERMI\n";
if($curyn =~ /yes/){
$toupdt= $curyn;
}
else{
if ($curaltern =~/\w+/) {
$toupdt= $curyn.'_'.$curaltern;
}
else{
$toupdt= $curyn;
}
}
if($curyn =~ /\w+/){
$update = "update inst_3 set u1 = \"$toupdt\" where object = \"$curent\"";
$sthinstance = $dbhinstance->prepare($update);
$rvinstance = $sthinstance ->execute();
if ( !defined($rvinstance) ){
print "exec:$DBI::errstr, $select\n";
}
}
}