think I need a multi array insert???

[keitai]

Hi all,

I am stuck here.

I have made a frontpage with 2 set of checkboxes, each set of checkboxes can have multiple values.

Now for each combination I want an update query.

So this is what I have so far

//$checkA[] and $checkB[]

$countA = count($checkA);
for ($i=0;$i<$countA;$i++)  {
$check1 = $checkA[$i];
}


$countB = count($checkB);
for ($i=0;$i<$countB;$i++)  {
$check2 = $checkB[$i];
}

$sql = "INSERT INTO tbl VALUES ('$check1','$check2')"

But I don't know how to get the loop for the $sql query?

Any suggestions

[Matth_S]

Do you want to insert the values of check1 and check2 in the same table ? But, I assume $checkA[] and $checkB[] can contain a different number of elements ? So , in that case, how do you want to insert those values ?

[keitai]

Yes, yes and that was my question, I don't see it

$checkA = ['I','II','III']

$checkB = ['A','B']

$sql = "INSERT INTO tbl VALUES ('I,'A' )"
$sql = "INSERT INTO tbl VALUES ('I,'B' )"
$sql = "INSERT INTO tbl VALUES ('II,'A')"
$sql = "INSERT INTO tbl VALUES ('II,'A')"

etc

[Matth_S]

So, regarding your example, you want to insert the following couples of values :
I,A
I,B
II,A
II,B
III,A
III,B

You'll get a lot of duplicated datas, but, anyway, if you want to insert the datas as previously described ; you can manage that by emebeding the 2 loops. For example :

$countA = count($checkA);
$countB = count($checkB);

for ($i=0;$i<$countA;$i++)  {
  for($j=0;$j<$countB;$j++){
     $sql = "INSERT INTO tbl VALUES ('$checkA[$i]','$checkB[$j]')";
  }
}

[inerte]

You could loop and issue a query for each combination, but that's not very elegant 🙂

Try a multiple insert sql:

$multiple_sql = '';
foreach ($checkA as $key => $value_A) {
    foreach ($checkB as $key => $value_B) {
         $multiple_sql .= "('$value_A', '$value_B'), ";
    }
}
$multiple_sql = substr($multiple_sql, 0, -2);

$sql = 'INSERT INTO tbl '
      . 'VALUES ' . $multiple_sql;

See if that helps... anyway the trick is to construct a single SQL instruction that can insert many rows, like the syntax: INSERT INTO table VALUES (1), (2), (3);

[keitai]

tx, guys

I have used a multiple insert before, gonna check that one out again.

duplicate entries would do