This topic is locked
[SOLVED]

DB:: insert only works once

1/12/2024 3:41:33 PM
PHPRunner General questions
francesco author

why second DB::Insert doesn't work? Where is the mistake?

if ($contaTotale > 1) {
foreach ($splitCom as $com) {
foreach ($splitCod as $cod) {
$data10 = array();
$data10['codice'] = $cod;
$data10['durata'] = $dur1 / $contaTotale;
$durataOre = floor($data10['durata']);
$durataMinutiDecimali = ($data10['durata'] - $durataOre) * 60;
$data10['ore'] = $durataOre;
$data10['minuti'] = round($durataMinutiDecimali);
$data10['dipendente'] = $op1;
$data10['operazione'] = $operz1;
$data10['commessa'] = $com;
$data10['tipologia'] = $tip1;
$data10['data'] = $dat1;
$data10['rev'] = $rev1;
$data10['numero pezzi'] = $pc1 / $contaTotale;
$data10['audio'] = $aud1;

// first successful INSERT
DB::Insert("orario", $data10);

// second UNSUCCESSFULL INSERT
$data10_dip2 = array();
$data10_dip2['ore'] = $durataOre;
$data10_dip2['minuti'] = round($durataMinutiDecimali);
$data10_dip2['codice'] = $cod;
$data10_dip2['durata'] = $dur1 / $contaTotale;
$data10_dip2['dipendente'] = $op2;
$data10_dip2['operazione'] = $operz1;
$data10_dip2['commessa'] = $com;
$data10_dip2['tipologia'] = $tip1;
$data10_dip2['data'] = $dat1;
$data10_dip2['rev'] = $rev1;
$data10_dip2['numero pezzi'] = $pc1 / $contaTotale;
$data10_dip2['audio'] = $aud1;

DB::Insert("orario", $data10_dip2);

}
}
admin 1/13/2024

You need to perform the basic troubleshooting posts first.

Are the any error messages?
Does the second Insert gets executed at all?
What happens when you comment out the first insert and only leave there the second one?

francesco author 1/13/2024

thanks I was able to find the error after enabling only the second insert