add checkbox with values from query

Question

i'm trying to create a php web app that will have options to select using checkbox form and then submit the checkedbox to other file. but how can i do this if the value of checkbox is defined with values from query? please help me, i cant find a solution :/

<form action="addPratosEnc4.php" method="POST">
        *Pratos a Adicionar:
            <select name="nomeA">
            <?php
                    try
                    {
                      $host = "xxxx";
                      $user ="xxx";
                      $password = "xxx";
                      $dbname = $user;
                      $db = new PDO("mysql:host=$host;dbname=$dbname", $user, $password);
                      $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                      $sql = "SELECT nomeA FROM Disponivel;";
                      $result = $db->query($sql);
                      foreach($result as $row)
                      {
                       $nomeA = $row['nomeA'];
                       /*should be here?*/
                      }
                      $db = null;
                    }
                    catch (PDOException $e)
                    {
                      echo("<p>ERROR: {$e->getMessage()}</p>");
                    }
            ?>

            </select>
        <br>
        <br>
        <input type="submit" value="Disponibilizar">
        </form>

I don't think you can put checkboxes into a <select> block.

cen
– cen

2013-11-28 23:56:24 +00:00
Commented Nov 28, 2013 at 23:56 — cen
– cen, Commented Nov 28, 2013 at 23:56
did php threw any error message ?

Prashant G
– Prashant G

2013-11-29 00:14:54 +00:00
Commented Nov 29, 2013 at 0:14 — Prashant G
– Prashant G, Commented Nov 29, 2013 at 0:14

hanzo2001 · Accepted Answer · 2013-11-30 19:47:05Z

1

Ok, let's get this straight

You want checkboxes, right! I mean, check!
The nameA column is unique or primary, no duplicates!

the logic and template together

<?php
try {
  $host = "xxxx";
  $user ="xxx";
  $password = "xxx";
  $dbname = $user;
  $db = new PDO("mysql:host=$host;dbname=$dbname",$user,$password);
  $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
  $q = "SELECT nomeA FROM Disponivel";
  $options = array();
  $count = 0;
  foreach($db->query($q) as $row) {
    $count++;
    $options[$row['nomeA']] = '<input type="checkbox" name="dispo[]" value="'.$row['nomeA'].'" />';
  }
  echo '<p>Rows processed: '.$count.'</p>';
  $db = null;
} catch (PDOException $e) {
  echo '<p>ERROR: '.$e->getMessage().'</p>';
}
?>
<form action="addPratosEnc4.php" method="POST">
  *Pratos a Adicionar:
  <?php
  if (!$options) echo ' agora no hay pratos';
  else foreach ($options as $name => $input) echo '<label>'.$input.' '.$name.'</label><br />';
  ?>
  <br />
  <br />
  <button type="submit">Disponibilizar</button>
</form>

Try this, ask any questions if you have them and if any solutions worked for you, please mark them as answer

edited Nov 30, 2013 at 19:47

answered Nov 29, 2013 at 16:05

hanzo2001

1,4081 gold badge13 silver badges24 bronze badges

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

8 Comments

user3046650 Over a year ago

no checkbox appear, only this: web.ist.utl.pt/ist170438/proj/addPratoToEnc4.php

hanzo2001 Over a year ago

ok, let me make some changes. We're gonna have to debug this so bear with me for a while

hanzo2001 Over a year ago

I added a row counter to the code. Please rerun in your environment and if the number of rows is 0 then there may be another underlying problem with the query or the database. I'll have to check on you later, gotta go

user3046650 Over a year ago

the result is 56, so it's not db problem :/ maybe is the way we create checkbox's

Narrim Over a year ago

I would argue that processing to foreach loops - 1 to add the options to an array and a second to write the html seems like overhead. Yes you should try and write functions to get all the code out of html but only call it once.

|

Narrim · Accepted Answer · 2013-11-29 00:10:44Z

1

To render the option list you do:

    .......
                        $nomeA = $row['nomeA'];
                        /*should be here?*/
?> <option value="<?php echo $nomeA; ?>"><?php echo $nomeA; ?></option><?php
                        }
                        $db = null;
                        }
........

This should create a option list within the select that is filled with the results from the query. I assume you meant an option list not checkboxes - A select box gives you each option and you can only select 1. You could also do this with radiobuttons. On the other hand you may have meant to use Checkbox's where the user can select multiple boxes.
In this case you shouldnt wrap anything in the select just something like

<input type="checkbox" name="group" value="<?php echo $nomeA; ?>">I have a <?php echo $nomeA; ?><br>

within the for loop.

Good Luck Narimm

answered Nov 29, 2013 at 0:10

Narrim

5808 silver badges22 bronze badges

2 Comments

user3046650 Over a year ago

i want to have checkbox so user can select multiple box right?

Narrim Over a year ago

Yes Checkboxes allow a user to select more than 1

Adam Chawki · Accepted Answer · 2013-11-29 00:16:18Z

0

echo'<input type ="checkbox" name = "'.$row['nomeA'].'"value = "'.$row['nomeA'].'" />'.$row['nomeA'].'<br />;

instead of : $nomeA = $row['nomeA']; remove the select tag and that should work.

edited Nov 29, 2013 at 0:16

answered Nov 29, 2013 at 0:08

Adam Chawki

747 bronze badges

Comments

user3046650 · Accepted Answer · 2013-12-03 03:01:08Z

just to complete my task, i will post what its need to get the values selected:

<?php
            session_start();
            $email = $_SESSION['email'];
            $nEnc = $_SESSION['nEnc'];
            $options = $_REQUEST['dispo'];
            echo("<p>$email</p>");
            echo("<p>$nEnc</p>");
            try
            {
                $host = "xxxx";
                $user ="xxxx";
                $password = "xxxx";
                $dbname = $user;
                $db = new PDO("mysql:host=$host;dbname=$dbname", $user, $password);
                $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                foreach($options as $name){
                    $nomeA = $name;
                    $sql = "INSERT INTO RegistoEnc VALUES ('$email',$nEnc,'$nomeA');";
                    echo("<p>$sql</p>");
                    $db->query($sql);
                };
                $db = null;
            }
            catch (PDOException $e)
            {
                echo("<p>ERROR: {$e->getMessage()}</p>");
            }
            echo "<br>Encomenda Criada!!<br>";
        ?>

Collectives™ on Stack Overflow

add checkbox with values from query

4 Answers 4

the logic and template together

8 Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

the logic and template together

8 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related