Php update checkbox states in db

Question

I am new in php, i have a question. How can I update checkbox states in db? checkboxes have same name. when click on update button it will update all row checkboxes stat in db. and checkboxes in db get true or false

html part

<div class='blocks-output'>
    <form action='/admin/blocks' method='post'>
        <input type='hidden' name='updated_block_index' value=''/>
        <input type='hidden' name='updated_block_name' value=''/>
        <table class='table table-hover table-striped table-bordered'>
            <thead>
                <tr class='text-uppercase'>
                    <td>#</td>
                    <td>selected</td>
                    <td>block index</td>
                    <td>block name</td>
                    <td>edit</td>
                    <td>delete</td>
                </tr>
            </thead>
            <tbody>
                <?php foreach ($blocksInfo as $row) { ?>
                    <tr>
                        <td>
                            <?php echo $row['id']; ?>
                        </td>
                        <td>
                            <input type="checkbox" name='id' value='<?php echo $row['id']; ?>' <?php if($row['selected'] == 1) echo 'checked'; ?> />
                        </td>
                        <td>
                            <p><?php echo $row['block_index']; ?></p>

                            <div class='form-group hidea'>
                                <input type='number' class='form-control' name='block_index' placeholder='Block index' value='<?php echo $row['block_index']; ?>'>
                            </div>
                        </td>
                        <td>
                            <p><?php echo $row['block_name']; ?></p>

                            <div class='form-group hidea'>
                                <input type='text' class='form-control' name='block_name' placeholder='Block name' value='<?php echo $row['block_name']; ?>'>
                            </div>
                        </td>
                        <td>
                            <a href='' class='edit-row btn btn-primary' role='button'>edit</a>
                            <button class='update-row btn btn-primary' name='update_row' value='<?php echo $row['id']; ?>'>update</button>
                        </td>
                        <td>
                            <button type='submit' class='btn btn-primary' name='delete_row' value='<?php echo $row['id']; ?>'>delete</button>
                        </td>
                    </tr>
                <?php } ?>

                <tr>
                    <td>
                        <input type='submit' class='btn btn-primary' name='clear_table' value='delete all'>
                    </td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td ></td>
                    <td>
                        <input type='submit' class='btn btn-primary' name='update_table' value='update'>
                    </td>
                </tr>
            </tbody>
        </table>
    </form>
</div>

enter image description here

thank you :)

change the checkbox name='id' to name='id[]' and get the checkbox in array value.. — Arun
– Arun, Commented Dec 26, 2014 at 8:26
use name='id[]' insted of name='id' for your checkboxes,then you will get an array of selected values on submit.Update the table using that — AVM
– AVM, Commented Dec 26, 2014 at 8:27

spandanaz · Accepted Answer · 2014-12-26 08:35:01Z

2

Replace 'id' for the name to below.

 <input type="checkbox" name='<?php echo $row['id']; ?>' value='<?php echo $row['id']; ?>' <?php if($row['selected'] == 1) echo 'checked'; ?> />

When you declared Name='id' all the elements have been picking on the same name, after the above declaration, each checkbox will have a unique name equal to the ID.

answered Dec 26, 2014 at 8:35

spandanaz

213 bronze badges

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

1 Comment

Vamshi .goli Over a year ago

good answer.....everyone is saying that keep id array i don't know why they are saying even they have unique id value...anyways nice answer

Community · Accepted Answer · 2017-05-23 12:20:34Z

0

Nothing here that a few simple google searches won't answer. You could start with this:

Getting checkbox values on submit

and work your way from there

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Dec 26, 2014 at 8:27

Mayur Relekar

674 bronze badges

1 Comment

Aram Mkrtchyan Over a year ago

I am searching but not found anything that i want

Pratik Joshi · Accepted Answer · 2014-12-26 08:56:13Z

0

Use array like: id[] and each checkbox should be given value like their ID in table.

So it will be in short <input type="checkbox" name='id[]' value='<?php echo $row['id']; ?>' <?php if($row['selected'] == 1) echo 'checked'; ?> />

So after post You will get only checkboxes which were checked , so accordingly save data in DB.

answered Dec 26, 2014 at 8:56

Pratik Joshi

11.7k7 gold badges44 silver badges73 bronze badges

Comments

avisheks · Accepted Answer · 2014-12-26 08:57:32Z

0

That's simple something like this: form.php

<html>
<body>
<form action="action.php" method="POST">
<label class="checkbox inline">
<input type="checkbox" name="frm_update" id="frm_update" value="<?=$id>"> check this box
</label>
</form>
</body>
</html>

action.php

<?php
if(isset($_POST['frm_update'])){
  //do what you wanted to do. Save it to database etc
}

edited Dec 26, 2014 at 8:57

answered Dec 26, 2014 at 8:41

avisheks

1,1801 gold badge11 silver badges28 bronze badges

Collectives™ on Stack Overflow

Php update checkbox states in db

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related