Query updates only the last value

Question

In my project, I have a table and I have fetched data to that table using a while loop. Here's is the code for that.

            <form action="returnDoc.php" method="post">
            <div class="row">
                <div class="col-md-2">

                </div>
                <div class="col-md-8">
                    <div class="row">
                        <div class="col-md-12">
                            <h3>Return Document</h3>
                        </div>
                    </div><br><br>
                    <table class="table table-responsive-lg table-hover">
                        <tr>
                            <th>
                                No
                            </th>
                            <th>
                                Document ID
                            </th>
                            <th>
                                Put the tick for returns
                            </th>
                        </tr>
                        <?php while ($_r = mysqli_fetch_assoc($q_set)) { ?>
                            <tr>
                                <td>
                                    <?php echo $_r['number']; ?>
                                </td>
                                <td>
                                    <?php echo $_r['doc_id']; ?>
                                </td>
                                <td>
                                    <input type="checkbox" name="return" value="<?php echo $_r['doc_id']; ?>" />
                                </td>
                            </tr>
                        <?php } ?>
                    </table>
                </div>
                <div class="col-md-2">

                </div>
            </div>
            <div class="row">
                <div class="col-md-4">

                </div>
                <div class="col-md-4">

                </div>
                <div class="col-md-4">
                    <input type="submit" value="SEND TO DSO" name="submit" class="btn btn-light"/>
                </div>
            </div>
        </form>

As you can see, the table is inside a form and there's a checkbox for each row in the table.

This is a screenshot of my database table. As you can see there's a field called availability and values for them are 'locked'. When I click submit, I want to update these locked fields into 'returned' where checkbox is ticked. Others which are not ticked should not be updated.

So, here's what I did.

    if (isset($_POST['submit'])) {
        $update_query = "UPDATE req SET availability = 'returned' WHERE doc_id='$_POST[return]'";
        mysqli_query($conn, $update_query);
    }

My problem is, this query updates only the last row I ticked because it gets the value after loop is finished. It doesn't update all the rows I select. So if you have any idea how to achieve this, please help me.

can you show what is inside the `$_POST['return']` array? – A l w a y s S u n n y Mar 21 '18 at 02:45 — A l w a y s S u n n y, Mar 21 '18 at 02:45

Wils · Answer 1 · 2018-03-21T02:50:00.483

0

   if (isset($_POST['submit'])) {
    $update_query = "UPDATE req SET availability = 'returned' WHERE doc_id='{$_POST[return]}'";
    mysqli_query($conn, $update_query);
}

try this

for more information please visit When to wrap curly braces around a variable

also, the checkbox will post an array instead of a single variable.

$_POST[return][0]

edited Mar 21 '18 at 02:50

answered Mar 21 '18 at 02:42

Wils

1,178
8
24

I still get the same result – Buwaneka Sudheera Mar 22 '18 at 02:40
Can you try to echo out the query and post here? – Wils Mar 22 '18 at 02:47
I added a vaar_dump and echo it. C:\wamp64\www\Survey\returnDoc.php:29:boolean false – Buwaneka Sudheera Mar 23 '18 at 01:26

score 0 · Answer 2 · answered Mar 21 '18 at 02:52

0

First you need to make sure you are sending an array of ids of the rows that have the checkbox checked.

Then do this in your code:

if (isset($_POST['submit'])) {
    $update_query = "UPDATE req SET availability = 'returned' WHERE doc_id IN " . implode(',', $_POST[return]);
    mysqli_query($conn, $update_query);
}

implode is going to return a string of the array elements glued with the first parameter (',' in our case).

answered Mar 21 '18 at 02:52

Ali Elkhateeb

3,413
4
21
39

Hi, this brings me error saying ( ! ) Warning: implode(): Invalid arguments passed – Buwaneka Sudheera Mar 22 '18 at 02:39

Query updates only the last value

2 Answers2