Count checked checkbox(array) numbers & saving checked checkboxes

Question

I have an array of checkbox in a table in PHP file like this :

echo "<td $Blocked><input type =\"checkbox\" name=\"Blocked[]\" value=\"checkblock\" /></td>";

I am trying to get the value of number of checked checkboxes and save it to DB.

$Blocked = 'unchecked';

if ((isset($_POST['edit_tc']))) {
    if (isset($_POST['Blocked'])) {
        if (is_array($_POST['Blocked'])) {
            foreach($_POST['Blocked'] as $value) {
                error_log($value);
            }
        }
        else {
            $value = $_POST['Blocked'];
            error_log($value);
        }

        $Blocked = 'checked';
    }
}

"edit_tc" is the Submit button.

How do I take the number of it when the user checks the checkbox & clicks Submit button to save it to a table column?

This link may help you out: http://stackoverflow.com/questions/18382979/get-check-box-value-if-checked — William Francis Gomes, Sep 24 '14 at 09:55
@William Thanks a lot! I have another query as to how to save the status of checked checkboxes after submit is clicked. — BVee, Sep 24 '14 at 10:12
I did not get your query. I meant would like to keep the checkbox checked even after submit is clicked or better option is to hide the click and display text like "Blocked". — BVee, Sep 24 '14 at 10:19
Sorry my bad brother. Can u tell me how you are saving these values in your db? — William Francis Gomes, Sep 24 '14 at 10:21
@WilliamFrancisGomes, I think he is little confused.. He doesn't know what he really wants! He didn't add any query for insert. So, does he asking for an query? Nope, he is now asking for "checkbox checked even after submit is clicked" — Shaunak Shukla, Sep 24 '14 at 10:28
@ShaunakShukla thank you for notifying me. But i thought he wanted to show them checked after saving them into db. — William Francis Gomes, Sep 24 '14 at 10:32
@WilliamFrancisGomes, then my answer is not appropriate as requirement?? — Shaunak Shukla, Sep 24 '14 at 10:35
@Shaunak, sorry for confusing you. I wanted to know how to get the count of checked checkboxes. I know how to save it to DB using MYSQL query. As William said, its right. Now I want to keep the checkboxes checked after the page is submitted. — BVee, Sep 24 '14 at 10:41

DeDevelopers · Answer 1 · 2014-09-24T10:21:19.983

0

You can use this method...

if ((isset($_POST['edit_tc']))) {
  if (isset($_POST['Blocked'])) 
  {
    $data = $_POST['Blocked'];
   foreach ($data as $checkedValue)
   {
     $qry = mysql_query("INSERT INTO `Table_name` WHERE `column_id` = '$checkedValue'");
   }
  }
}

This is the method that will use to save each value as different records... You can modify that if needed.

edited Sep 24 '14 at 10:21

answered Sep 24 '14 at 10:08

DeDevelopers

581
1
7
25

score 0 · Accepted Answer · answered Sep 24 '14 at 10:42

0

I guess below code will solve all your problem.

<?php
$hello = array();
if(isset($_POST['submit'])) {
  extract($_POST);
  print_r($hello); //print all checked elements
}
?>

<form method="post">
    <input type="checkbox" name="hello[]" value="1" <?php if(in_array(1, $hello)){ echo 'checked'; } ?>>
    <input type="checkbox" name="hello[]" value="2" <?php if(in_array(2, $hello)){ echo 'checked'; } ?>>
    <input type="checkbox" name="hello[]" value="3" <?php if(in_array(3, $hello)){ echo 'checked'; } ?>>
    <input type="checkbox" name="hello[]" value="4" <?php if(in_array(4, $hello)){ echo 'checked'; } ?>>
    <button type="submit" name="submit" value="Submit">Submit</button>
</form>

You have to check the value of each checkbox inside the checkbox array you are getting using in_arrayfunction of PHP.

If you need to understand whole thing, just let me know.

Will be glad to help you out.

Regards.

answered Sep 24 '14 at 10:42

William Francis Gomes

561
1
7
29

I am not using different values. I am using a single value i.e. `value=\"checkblock\"` inside a table data So it is displayed as a column with checkboxes with single value. – BVee Sep 24 '14 at 10:48
@BVenky, are you using multiple checkboxes with same values? – Shaunak Shukla Sep 24 '14 at 10:49
@Shaunak, yes you are right. But I am using it in table column. – BVee Sep 24 '14 at 10:51
Is checkblock a variable or something? @BVenky – William Francis Gomes Sep 24 '14 at 10:52
1

@BVenky, yes I can see as `checkbox`.. but All checkboxes should have different value with same name OR same values with different names!! – Shaunak Shukla Sep 24 '14 at 10:54
@William, Yes it is given by user to make it blocked test cases. And I take the count and put it to the DB as $blocked. – BVee Sep 24 '14 at 10:55
So this must be like `$checkblock` and not `checkblock` , am i right @BVenky ?? – William Francis Gomes Sep 24 '14 at 10:58
Ya, that's why I am using $Blocked in this: `echo "";` – BVee Sep 24 '14 at 11:05
@WilliamFrancisGomes, Please let me know how to save the status of the checked checkboxes after page is submitted. – BVee Oct 16 '14 at 11:14
Hello @BVenky, you want to save all values in one column or multiple column? Let me know. – William Francis Gomes Oct 18 '14 at 04:13

score 0 · Answer 3 · answered Sep 24 '14 at 10:48

You can simply use count() function to get total number of checkbox checked by user. As only those checkbox values are posted to submitted page which are checked by user and if checkbox is not checked , its value will not be submitted. i.e The unchecked checkbox will not exist on submitted page.

USE:

    $totalCheckboxChecked=count($_POST['Blocked']);

Count checked checkbox(array) numbers & saving checked checkboxes

3 Answers3