mysql api 多条写,从API将多个值插入mysql数据库

I am connected to an API that keeps track of customer orders. Some orders have one product but some orders have multiple products in one order. When I try and INSERT into my database I only get the first product. I would like to have all the products inserted in the cases where their are more than one. The API's XML to the productName is ->orderItems->orderItem->productName and I am trying to loop through all of them but I still only get the first product.

foreach ($customer_orders as $customer_order) {

$chOrder = curl_init('https://' . $customer_order->reference);

curl_setopt($chOrder, CURLOPT_USERPWD, "username" . ":" . "password");

curl_setopt($chOrder, CURLOPT_HTTPHEADER, array('Content-Type: application/xml'));

curl_setopt($chOrder, CURLOPT_RETURNTRANSFER, true);

$orderResult = curl_exec($chOrder);

curl_close($chOrder);

$shouldContinue = true;

try {

$singleXML = new SimpleXMLElement($orderResult);

} catch (Exception $e) {

$shouldContinue = false;

error_log($e);

error_log('Failed to get history for ' . wp_get_current_user()->user_email . ' using refernece: ' . $customer_order->reference);

}

if ($shouldContinue) {

++$orderCount;

foreach ($singleXML->orderItems->orderItem as $item) {

$product = htmlentities($item->productName, ENT_QUOTES, 'UTF-8');

}

$con = mysqli_connect('localhost', 'root', 'password', 'database');

$query = "INSERT IGNORE INTO customer_product_list(`product`)VALUES('$product')";

mysqli_query($con, $query);

mysqli_close($con);

}

}

解决方案

try put insert query inside foreach loop

$con = mysqli_connect('localhost','root','password','database');

foreach ( $singleXML->orderItems->orderItem as $item ) {

$product = htmlentities($item->productName, ENT_QUOTES, 'UTF-8');

$query = "INSERT IGNORE INTO customer_product_list(`product`) VALUES('$product')";

mysqli_query($con,$query);

}

mysqli_close($con);