将数组拆分为mysql php中的单独列

Question

I am really new at php/mysql, so I hope you will bear with me! This code is part of a larger script, but I think it is the crucial parts needed to help me further.

$order_id = $_POST['order_ids'];
$order_ids = implode(",",$order_id);

<input type="text" name="order_ids[]" value="123">
<input type="text" name="order_ids[]" value="456">

$query = "INSERT INTO order_list (id,order_id) VALUES (LAST_INSERT_ID(),'$order_ids')";

I would like to get:

id|order_id
10|123
10|456

Instead of what I get now

id|order_id
10|123, 456

---

UPDATE

The code from @Ido seems to work out of the box, I have one more field input I would like to add as well to the column which in the table is called "amount" which is similar to the order_id field input.

$order_amount = $_POST['order_amounts_field'];
$order_amounts = implode(",",$order_amount);

I tried copying this and changing with the other one, but soon realized I have to execute both inputs in the same query so as to get them in the same row:

$order_ids = array();

foreach($order_id as $id)
$order_ids[] = "(LAST_INSERT_ID(), '". $id ."')";

$order_ids = implode(", ", $order_ids);

$query = "INSERT INTO order_list (id,order_id) VALUES $order_ids";

Answer 1

$order_ids = array();

foreach($order_id as $id)
    $order_ids[] = "(LAST_INSERT_ID(), '". $id ."')";

$order_ids = implode(", ", $order_ids);

$query = "INSERT INTO order_list (id,order_id) VALUES $order_ids";