Hola, estoy insertando datos múltiples con for loop. y obtener esos datos de la base de datos e insertarlos en ghseet nuevamente ahora quiero que suceda a la vez.

mi para cada ciclo está aquí

 if (in_array($_POST['prodname'][$key], $checked_array)) { $prodname = $_POST['prodname'][$key]; $prod_price = $_POST['prod_price'][$key]; $prod_qty = $_POST['prod_qty'][$key]; $prodsname = $_POST['prodsname'][$key]; $app_id = $_POST['app_id'][$key]; $district = $_POST['district'][$key]; $upazilla = $_POST['upazilla'][$key]; $store_name = $_POST['StoreName'][$key]; $ward = $_POST['ward'][$key]; for ($x = 0; $x < $prod_qty; $x++) { $couponnumber = random_int(100, 100000); $sql = "INSERT INTO `retailer_sales`( `product`, `Amount`, `quantity`,`C_Number`,`Retailer_Number`,`Dtistrict`,`Upzilla`,`coupon_number`,`StoreName`,`ward`) VALUES ('$prodname','$prod_price','$prod_qty','$prodsname','$app_id','$district','$upazilla','$couponnumber','$store_name','$ward')"; $result = $db->query($sql); if ($result) { $_SESSION["status"] = true; } else { $_SESSION["server_down"] = true; echo '<script>window.location="../../pages/product_sale/main.php";</script>'; } } }

y mi código javascript para enviar a gsheet es

 <script> const scriptURL = 'https://script.google.com/macros/s/AKfycbzfMQmBwDEO8k0H8jeLlKTE_GzK0XuQ1unZd_5ib_DDBhM17b6FVahIW5f3W4FyfCNOAw/exec' const form = document.forms['submit-to-gateway'] form.addEventListener('submit', e => { e.preventDefault() fetch(scriptURL, { method: 'POST', body: new FormData(form) }) .then(response => $("#form_alerts").html("<div class='alert alert-success'>Id Sent Successfully.</div>")) .catch(error => $("#form_alerts").html("<div class='alert alert-danger'>Id Could not be Sent.</div>")) $('#myForm')[0].reset(); }) </script>

quiero insertar cada dato que se inserta en la base de datos mysql. Ayúdame con esto.