不要在表中的数组

Question

My code

$insert2 = "INSERT INTO numbers(ContactID, numbers) VALUES('$insertID','" . $capture_field_vals . "')";
    mysql_query($insert2);

And I get

ContactID       numbers  
1               421312, 123123, 3434543, 123423, 98797

What I want

ContactID     numbers
1             421312
1             123123
1             3434543
1             123423
1             98797

Please help me, I don't get it how to do this

Answer 1

Split the string into an array using explode(), then loop over them and insert them into the table.

$numbers = explode(',', $capture_field_vals);
foreach ($numbers as $n) {
    $n = trim($n);
    if (strlen($n) > 0) {
        $insert2 = "INSERT INTO numbers (contactID, numbers) VALUES ('$insertID', '$n')";
        mysql_query($insert2);
    }
}