Save duplicate arrays to an Insert

Question

Tenhos arrays duplicados

produto[] valor[] qtd[] total[]
produto[] valor[] qtd[] total[]

I need to save these arrays in an Insert, like this:

INSERT 'tabela' (produto, valor, qtd, total) VALUES (produto[],valor[],qtd[],total[]) ;

INSERT 'tabela' (produto, valor, qtd, total) VALUES (produto[],valor[],qtd[],total[]) ;

//OBS: I know this doesn’t work in VALUES but that’s what I need...

I HAVE DONE SO:

    foreach ( $produto as $key => $v) {
    $array[$key][] = $v;
}

    foreach ( $valor as $key => $v) {
    $array[$key][] = $v;
}

    foreach ( $qtd as $key => $v) {
    $array[$key][] = $v;
}

    foreach ( $total as $key => $v) {
    $array[$key][] = $v;
}

    foreach ( $modalidade as $key => $v) {
    $array[$key][] = $v;
}

    foreach( $array as $value){ 

echo "INSERT INTO `table` ( `produto`, `valor`,`qtd`,`total`,`modalidade`) VALUES (".$value[0].",".$value[1].",".$value[2].",".$value[3].",".$value[4].")

}

OBS: It’s working, the fact is that not always in value[0] is the product, and value[1] is the value and so on....

Answer 1

You can do something like this:

$i=0;
$sql= "INSERT 'tabela' (produto, valor, qtd, total) VALUES ";
while(!empty(produto[$i]){
 $sql=$sql."($produto[$i],$valor[$i],$qtd[$i],$total[$i]),";
$i++;
 }
 $sqlFinal = substr($sql, 0, strlen($sql)-1);

Or another way would be this:

$i=0;
$sql= "INSERT 'tabela' (produto, valor, qtd, total) VALUES ";
foreach($produto as $p){
$sql=$sql."($p,$valor[$i],$qtd[$i],$total[$i]),";
$i++;
}
 $sqlFinal = substr($sql, 0, strlen($sql)-1);

Then you will have sql mounted on the $sql variable