mysql insert id pdo_插入数组值使用php和PDO将单个ID插入到mysql...

这个问题已经在这里有了答案：????????????>????????????Insert multiple items into one ID MySQL from checkbox input PHP form????????????????????????????????????1个

使用具有Ajax负载的数组插入将多个产品插入单个id.也许使用Explode,但需要针对此类输出的明确说明：

所有产品(问题)都将输入一个ID.这些问题列表由Ajax添加.

if(isset($_POST['Submit'])){

try {

$serviceTitle = $_POST['serviceTitle'];

$price = $_POST['price'];

$quantity = $_POST['quantity'];

$amount = $_POST['amount'];

$date = date('Y-m-d');

date_default_timezone_set('Asia/Dacca');

$time = date('h:i:s');

$createBy = $_SESSION['sess_username'];

$_SESSION['orderNo'] = $_POST['orderNo'];

$_SESSION['customerNo'] = $_POST['customerNo'];

if($_POST['Submit']==='Submit'){

for($i=0;$i

$statement = $db->prepare("INSERT INTO invoice (orderNo,customerNo,productName,price,quantity,amount,createDate,createTime,createBy) VALUES (?,?,?,?,?,?,?,?,?)");

$statement->execute(array($_POST['orderNo'],$_POST['customerNo'],$serviceTitle[$i],$price[$i],$quantity[$i],$amount[$i],$date,$time,$createBy));

}

}

header("location: order_confirm_tech_step2.php");

}

catch(Exception $e) {

$error_message = $e->getMessage();

}

}

?>

它将以相同的orderNo和customerNo插入,但是我想这样插入数据行：

提前致谢.