Checkbox in a while loop php

Question

I have a check box inside a while loop like this:

 <form method="POST">
    <?php $sql= mysql_query("SELECT * FROM names WHERE `id` ='$id' ");

     while ($get = mysql_fetch_array($sql)){ ?>
    <input type="checkbox" name="id_names" value="<? echo $get ['id'];?>"><?php echo $get ['name']; ?>
    <?php } ?>
   <input id="submitbtn"  type="submit" value="Submit" /><br><br>
</form>

The problem is at this part I am unable to get specific checkbox properties and even if the user selects two check boxes I am unable to echo the id out

<?php
      if(isset($_POST['id_names']))
        {
         $id_names= $_POST['id_names'];
         $email = mysql_query("SELECT `email` FROM users WHERE `id` = '$id_names'  ");
  while ($getemail = mysql_fetch_array($email))
      {
        echo $getemail['email'];
      }
         }
    ?>

I have tried searching for answers but I am unable to understand them. Is there a simple way to do this?

you can check here: stackoverflow.com/questions/14026361/… — coyote34
– coyote34, Commented Sep 29, 2016 at 11:45

Egg · Accepted Answer · 2016-09-29 11:58:23Z

0

The form name name="id_names" needs to be an array to allow the parameter to carry more than one value: name="id_names[]".

$_POST['id_names'] will now be an array of all the posted values.

answered Sep 29, 2016 at 11:58

Egg

1,7491 gold badge14 silver badges29 bronze badges

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

1 Comment

Shurvir Mori Over a year ago

how can we differentiate that array suppose, I get $_POST['id_name'] = 'add_2,add_3,add_4,add_5', so how can I get different different.

AHJeebon · Accepted Answer · 2016-09-29 12:30:09Z

0

Here your input field is multiple so you have to use name attribute as a array:

FYI: You are using mysql that is deprecated you should use mysqli/pdo.

<form method="POST" action="test.php">
    <?php $sql= mysql_query("SELECT * FROM names WHERE `id` =$id ");

    while ($get = mysql_fetch_array($sql)){ ?>
        <input type="checkbox" name="id_names[]" value="<?php echo $get['id'];?>"><?php echo $get['name']; ?>
        <input type="checkbox" name="id_names[]" value="<?php echo $get['id'];?>"><?php echo $get['name']; ?>
    <?php } ?>
    <input id="submitbtn"  type="submit" value="Submit" /><br><br>
</form>

Form action: test.php (If your query is okay.)

<?php
    if(isset($_POST['id_names'])){
        foreach ($_POST['id_names'] as $id) {
            $email = mysql_query("SELECT `email` FROM users WHERE `id` = $id");
            $getemail = mysql_fetch_array($email); //Here always data will single so no need while loop
            print_r($getemail); 
        }
    }
?>

edited Sep 29, 2016 at 12:30

answered Sep 29, 2016 at 12:06

AHJeebon

1,2481 gold badge12 silver badges17 bronze badges

3 Comments

AHJeebon Over a year ago

Check it now @AshneelChand.

Ashneel Chand Over a year ago

so the ` $id` is stored as numbers right so when i do WHERE id = $id it will say WHERE id = '1' ` but it should be somthing like WHERE id = jack

AHJeebon Over a year ago

Yes id is a integer, and no need to use Quotation.

Collectives™ on Stack Overflow

Checkbox in a while loop php

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related