PHP对数组键值执行foreach

Question

I have the an array (below) which I need to perform multiple MySQL inserts from.

The KEY is the value that needs to be inserted, and the VALUE is the number of times it needs to be inserted.

For example, on the first iteration, I hope to insert "1" twelve times. In the second iteration, I hope to insert "2" twenty-eight times.

Array ( [1] => 12 [2] => 28 [3] => 21 [4] => 9 [5] => 0 )

Now, I'm aware it's best to use one query to insert multiple rows, rather than individual INSERT queries, so I hope my code below reflects this.

My question is: how can I iterate through the key VALUE, instead of the individual keys (although I need to iterate through the keys as well)?

$insert = array(); 
foreach ($ret AS $key => $item)                 // $ret is the array above
{
    $insert[] = "('". mysql_real_escape_string($item) . "'," . $key . "')";
     // This insert query should repeat only as many times as each array value
}

echo "INSERT INTO table (id, key) VALUES " . implode(',', $insert);

Answer 1

You need to run second loop inside the foreach

foreach ($ret as $key => $item) {
    for($i=1; $i<=$item; $i++) {
        $insert[] = "('". mysql_real_escape_string($item) . "'," . $key . "')";
    }
}

and make sure you id is not Primary unique in the table.