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 ""; print ""; 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 ""; } print "
Save evaluations of instances: $instance
IstanzaSaved evaluationAlternative evaluation
$curent$curyn$curaltern
"; } 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"; } } }