get checkbox id and value at the same time php

Question

I would like to know how do I get the value of the checkbox that is assigned by an ID to it at the same time.

Here is my brief code:

<table class="data" cellpadding="0" cellspacing="0">
<?php
$select=mysql_query("select * from products_list ORDER BY id ASC");
while($row=mysql_fetch_array($select)){

$class = ' class="new_arrival" ';

echo "<tr>
<td>".$row['id']."</td>
<input type='hidden' name='product_id' value='".$row['id']."' />
<input type='checkbox' name='product_new' checked='checked' onclick='document.product_listing.submit();' /></td></tr>";
?>
</table>

if (isset($_POST['product_new'])) {

$id = $_POST['product_id'];

echo ("<script language='JavaScript'>
    window.alert('".$id."')
    </script>");
}

The result I keep getting for ID is the latest record in database but the value of the checkbox works fine.

I've tried this:

<input type='checkbox' name='product_new[".$row['id']."]' checked='checked' onclick='document.product_listing.submit();' />

foreach($_POST['product_category'] as $id => $value)

Using foreach loop, it did work somehow but it will loop through those checkboxes whether it's checked or uncheck.

Hope you guys understand, been stuck in this for 2 days. My purpose is to click the checkbox be it check or uncheck, it will update the database according to the ID which is assigned by mysql show result.

Any help will be much appreciated. Thanks!!

What do you mean by update the value be it checked or unchecked? What do you want the script to do when you click on a checkbox? — Usman Zaheer
– Usman Zaheer, Commented Jul 27, 2012 at 10:23
Your HTML says product_new[".$row['id']."] but you foreach over $_POST['product_category'] - try looping $_POST['product_new'] instead. — DaveRandom
– DaveRandom, Commented Jul 27, 2012 at 10:30
I want the script to do update the database with the checkbox value. If the result for the checkbox is checked, user uncheck it, it will update the database with the value of uncheck and vice versa. But I also need to get the ID of the checkbox which I use mysql show result to assign to the checkbox so that I can update the database as to which the checkbox is being check or uncheck. Is this clear? =x — Dr3am3rz
– Dr3am3rz, Commented Jul 27, 2012 at 10:30
Yes it is. refer to my answer below. I believe you shouldn't be submitting form on every checkbox click as it will reload the page every time and irritate the user. — Usman Zaheer
– Usman Zaheer, Commented Jul 27, 2012 at 10:35

Usman Zaheer · Accepted Answer · 2012-07-27 10:32:49Z

1

I don't quite understand what exactly are you looking to do with checkboxes but here are a couple of things that would help you do whatever you want to do:

HTML form don't submit the value of a checkbox if it is not checked e.g. if you have a single checkbox like and you submit the form with it unchecked you will get null if you try to access chkbox1
If you are looking to get if the clicked checkbox is checked or not you can do it by either making each onclick pass the value of the id like

<input type='checkbox' name='product_new[".$row['id']."]' checked='checked' onclick='setValueAndSubmit(<?=$row[id]?>)' />

and write the function in js which checks the checked attribute of the checkbox and process accordingly

OR

you if you looking to look at all the checkbox values on submit then you can simply iterate over the checkbox group and you will only find the checkbox names of the checkboxes that are checked, unchecked won't be submitted.

EDIT: Just remove the onclick after every checkbox and put a submit button, and once the form submits you will get the names and values of the checked checkboxes so set those, and unset all the others.

edited Jul 27, 2012 at 10:32

answered Jul 27, 2012 at 10:30

Usman Zaheer

6258 silver badges24 bronze badges

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

4 Comments

Quentin Over a year ago

"PHP form" — That's an HTML form.

Dr3am3rz Over a year ago

Hmm.. Because I want to update the database just by clicking the checkbox only without the submit button.

Usman Zaheer Over a year ago

Then try using ajax, that won't load the page

Dr3am3rz Over a year ago

do you have any simple example or reference you can recommend?? I tried searching for that too but I'm a beginner and hardly understand..

meiamsome · Accepted Answer · 2012-07-27 10:32:47Z

0

If I understand the issue correctly...

This is happening due to having more than one input with the name product_id so referencing by name results in one being taken, but not the one you want.

So, a fix would be to add a single field, product_id to the form outside of the loop and alter that value in the onClick of the checkbox.

Example onclick:

<input type='checkbox' name='product_new' checked='checked' onclick='document.product_listing['product_id'] = ".$row['id'].";document.product_listing.submit();' /></td></tr>";`

Something like that ought to work.

answered Jul 27, 2012 at 10:32

meiamsome

2,9441 gold badge19 silver badges19 bronze badges

3 Comments

Usman Zaheer Over a year ago

You have to group the name name='product_new[]'

meiamsome Over a year ago

I'm not so sure, judging by OP, that being an array wouldn't be helpful and as stated it's value works fine as-is. I would probably set the value for that in another hidden field in an idealistic world. (adding document.product_listing['product_id'].checked = this.checked; to the onclick, removing the name attribute and making a blank input that is hidden with the name product_new)

Dr3am3rz Over a year ago

Hmm.. Can I ask for example? I don't understand you last sentence. =x

DaveRandom · Accepted Answer · 2012-07-27 10:39:23Z

0

Just put the id in the value= attribute of the checkbox.

To generate the HTML:

<table class="data" cellpadding="0" cellspacing="0">
<?php

  $query = "
    SELECT *
    FROM products_list
    ORDER BY id ASC
  ";
  $result = mysql_query($query);

  // What if the query fails? Handle error here!

  while ($row = mysql_fetch_ssoc($result)) {

    // ...

    echo "
    <tr>
      <td>".htmlspecialchars($row['id'])."</td>
      <td><!-- I'm guessing this open td tag was missing and should be added -->
        <input type='checkbox' name='product_new[]' checked='checked' value='".htmlspecialchars($row['id'])."' />
        <!-- You don't want the onclick for the checkbox to submit the form, or you will only ever get one result -->
      </td>
    </tr>";

    // ...

  }

?>
</table>

And when the form is submitted:

if (isset($_POST['product_new'])) {
  foreach ($_POST['product_new'] as $id) {
    // Do stuff with $id here
  }
}

answered Jul 27, 2012 at 10:39

DaveRandom

88.8k11 gold badges159 silver badges174 bronze badges

2 Comments

Dr3am3rz Over a year ago

Hmm.. If I use foreach, it will loop through the whole checkboxes that I may have in that page.

DaveRandom Over a year ago

The only checkboxes that are sent back to the server are the ones that are checked. This will loop through only those.

Collectives™ on Stack Overflow

get checkbox id and value at the same time php

3 Answers 3

4 Comments

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related