how to Pass 3 arguments in array_combine, is that possible? [duplicate]

Question

i have three variables ($product_id, $size_id, $quantity) which get from "form" and insert into the pending_order table.So i used the array_combine function to combine three variables and than using for each loop to insert the multiple records. but it shows an error

"Warning: array_combine() expects exactly 2 parameters, 3 given".

So im totally stuck, is that any other way to pass these three variables in array and than use for each loop to insert the record.

<form method="post" action="">

<input type="hidden" name="ip_address" value="<?php echo $ip_address; ?>">   
<input type="hidden" name="product_id[]" value="<?php echo $product_id; ?>">   
<input type="hidden" name="size_id[]" value="<?php echo $size_id; ?>"> 
<input type="hidden" name="quantity[]" value="<?php echo $quantity; ?>" >
<input type="submit"  name="submit" value="Confirm Your Order"> 

</form>

<?php
if (isset($_POST['submit'])) {
$product_id = $_POST['product_id'];
$size_id = $_POST['size_id'];
$ip_address = $_POST['ip_address'];
$quantity = $_POST['quantity'];

$array = array_combine($product_id, $size_id, $quantity);

foreach ($array as $h => $v) {

$insert_pending = "INSERT INTO pending_orders 
(cus_id,product_id,size_id,quantity,ip_address) VALUES 
('$cus_id','$h','$v','$quantity','$ip_address')";

 $run2 = mysqli_query($con, $insert_pending);

 }

if($run2===true){

 echo "<script>window.open('thanku.php','_self')</script>";
  }else{
 echo "<script>alert('Sorry, Try Again')</script>";

 }


 }

Are you looking for something like this ?

Sulthan Allaudeen
– Sulthan Allaudeen

2019-05-23 00:14:54 +00:00
Commented May 23, 2019 at 0:14 — Sulthan Allaudeen
– Sulthan Allaudeen, Commented May 23, 2019 at 0:14
Thank u sir...problem solved @SulthanAllaudeen

Sibtain Raza
– Sibtain Raza

2019-05-23 16:59:35 +00:00
Commented May 23, 2019 at 16:59 — Sibtain Raza
– Sibtain Raza, Commented May 23, 2019 at 16:59
Thank u so much @miken32

Sibtain Raza
– Sibtain Raza

2019-05-23 17:00:11 +00:00
Commented May 23, 2019 at 17:00 — Sibtain Raza
– Sibtain Raza, Commented May 23, 2019 at 17:00

Nick · Accepted Answer · 2019-05-23 00:14:02Z

1

You can just loop through one of the arrays, using the index from that array to access the corresponding values from the other arrays:

foreach ($product_id as $index => $h) {
    $v = $size_id[$index];
    $q = $quantity[$index];
    $insert_pending = "INSERT INTO pending_orders 
                            (cus_id,product_id,size_id,quantity,ip_address) VALUES 
                            ('$cus_id','$h','$v','$q','$ip_address')";
    $run2 = mysqli_query($con, $insert_pending);
}

Note that $run2 will only have the status of the last INSERT query. So if they all fail but the last one you won't know. You might want to try adding this to the loop after the query:

if (!$run2) break;

and then in your error message you can indicate which insert failed e.g.

echo "<script>alert('Insert failed for id $cus_id on data $h, $v, $q')</script>";

answered May 23, 2019 at 0:14

Nick

147k23 gold badges67 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sibtain Raza Over a year ago

OMG...Problem solved.Thank u soo soo much.i mean bundle of thankz. Thank u for your time and support.

Collectives™ on Stack Overflow

how to Pass 3 arguments in array_combine, is that possible? [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related