Build checkboxes with PHP from mysql

Question

I have the following table in my database:

CREATE TABLE subjects (
  subject_id int(11) NOT NULL AUTO_INCREMENT,
  subject text,
  PRIMARY KEY (subject_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

In the table I have already entered some data (subject names).

What I'm trying to do is that for each subject in the table, a checkbox is created with the name of the subject next to it.

So far I have managed to create checkboxes for each subject in the table, but I can not get the name of the subject shown next to the checkbox. Does anyone know how to do it?

I'm doing it this way:

<?php
$sql = "SELECT subject FROM subjects"; /*Select from table name: subjects*/
$result = $conn->query($sql); /*Check connection*/

if($result)
{
    foreach($result as $row)
    {
        echo "<input type='checkbox' name='data[]' value='" . htmlspecialchars($row['subject']) . "' /> <label>Here goes the subject name</label>";
    }
}
?>

This is how my table looks like:

And this is what I'm getting in PHP:

try debugging the $row object, and see what it contains, using var_dump() or print_r() - you might be getting an object or array back from your query, rather than an associative array. you might only need to use $row[0] — Matthew Knight
– Matthew Knight, Commented Apr 29, 2019 at 19:14
Are you just looking for echo "<input type='checkbox' name='data[]' value='" . htmlspecialchars($row['subject']) . "' /> <label>" . htmlspecialchars($row['subject']) . "</label>"; — Chris White
– Chris White, Commented Apr 29, 2019 at 19:14
Your query is only selecting subject; is that the name? Should you maybe do a SELECT * and access $row["subject_id"] in value and just output $row["subject"] after? — Tim Lewis
– Tim Lewis, Commented Apr 29, 2019 at 19:16

Jay Blanchard · Accepted Answer · 2019-04-29 19:21:14Z

1

Pretty easy actually, just concatenate the $row['subject'] variable in between the label tags:

foreach($result as $row)
    {
        echo "<input type='checkbox' name='data[]' value='" . htmlspecialchars($row['subject']) . "' /> <label>" .$row['subject'] . "</label>";
    }

You can use variables more than once in any output.

answered Apr 29, 2019 at 19:21

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

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

5 Comments

ana Over a year ago

Yes it works! Thank you. It also works with <label>" . htmlspecialchars($row['subject']) . "</label>

Jay Blanchard Over a year ago

Not sure why you're wrapping the values in that function - things coming from the database should be safe already.

miken32 Over a year ago

No, you always escape for HTML output, never escape values before putting them in the database.

GrumpyCrouton Over a year ago

@JayBlanchard I've always heard things should be stored in databases raw most of the time, and escaped on output.

Elroy Jetson Over a year ago

escape on output is sufficient.

Collectives™ on Stack Overflow

Build checkboxes with PHP from mysql

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related