multiple post array loop doesn't working

Question

<?php
    $sql = "SELECT * FROM product ORDER BY product_id DESC";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {

            echo "" . $row["product"] . "\n\n<input type='checkbox' name='product[]' value=" .$row["product"] . ">\n         
     Quantity\n\n<select name='quantity[]'>
        <option value='1'>1</option>
        <option value='2'>2</option>
        <option value='3'>3</option>
    </select><br />";
        }

    ?>
    <button name="submit" type="submit">submit</button><br />

    <?php

        if (isset($_POST['submit'])) {
            if (is_array($_POST['product'])) {
                foreach ($_POST['product'] as $key => $product_name) {
                    $quantity = $_POST['quantity'][$key];
                    echo $product_name . "\n";
                    echo $quantity . "<br>";

                }
            }
        }
    }

    ?>

i would want to select multiple product and quantity but it doesn't giving me quantity value what i select.

on example picture1 you could see i selected 2 products

Asus 2
Acer 3

But if click on submit i get result like
example picture2

Asus 1
Acer 1

The first and second dropdown have value 1 so the results are correct. All quantity values are always submitted. — Maarten van Middelaar
– Maarten van Middelaar, Commented Nov 25, 2016 at 22:55
Your issue is that only checked checkboxes are posted, but all selects are posted. So you need to need to link the 2 together so that they keys match. You can add a simple counter var, ie. $i=0, name='product[$i]'/name='quantity[$i]' — Sean
– Sean, Commented Nov 25, 2016 at 22:56
i appreciate your help but im just a learner, not expert on php. Would you please correct my script and post it here? @Sean — romeo
– romeo, Commented Nov 25, 2016 at 23:06
@MaartenvanMiddelaar posted an answer that is equivalent to what I mentioned. My example was to use a simple counter var, where he used $row['product_id'] (or whatever your row id column name is). — Sean
– Sean, Commented Nov 25, 2016 at 23:09

Maarten van Middelaar · Accepted Answer · 2016-11-25 23:04:21Z

1

Try using the product ID to link the checkboxed to the select boxes.:

$sql = "SELECT * FROM product ORDER BY product_id DESC";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {

            echo "" . $row["product"] . "\n\n<input type='checkbox' name='product[".$row['product_id']."]' value=" .$row["product"] . ">\n         
     Quantity\n\n<select name='quantity[".$row['product_id']."]'>
        <option value='1'>1</option>
        <option value='2'>2</option>
        <option value='3'>3</option>
    </select><br />";
        }

answered Nov 25, 2016 at 23:04

Maarten van Middelaar

1,72110 silver badges15 bronze badges

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

1 Comment

romeo Over a year ago

Perfect... You are amazing. Thank you.

Collectives™ on Stack Overflow

multiple post array loop doesn't working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related