Undefined index: checkbox in PHP

Question

0.00/5 (No votes)

See more:

A list of checkbox for user to select genre type. The genre input is from database. Because the sql will return the result in an array, a for loop to get all the values and make them into a check box. The error come from third line in the loop. It show undefined index genre

What I have tried:

<div class="list-group">
      <h3>Genre</h3>
      <?php
      $search_genre = "SELECT DISTINCT(genre) FROM movie_db WHERE product_status ='1' ORDER BY movieid DESC"
      $statement = mysqli_query($conn,$search_genre);
      $result = mysqli_fetch_all($statement);
      foreach ($result as $row){
         ?>
         <div class="list-group-item checkbox">
         <label><input type="checkbox" class="common_selector genre" value="<?php echo$row['genre'];?> > <?php echo $row['genre'];?></label>
</div>
<?php
}
?>

Posted 20-Oct-18 16:26pm

JiaWei Lee

Updated 23-Oct-18 3:38am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

W∴ Balboos, *GHB* · Answer 1 · 2018-10-22T07:37:00

Things for you to do:

Fix code - spaces are important:

value="<?php echo$row['genre'];?> >
value="<?php echo $row['genre']; ?>"

But really, loops that build HTML should, in general, build the HTML and not just the values (from the php). Your foreach() statement should not end the php abruptly but instead build the entire HTML, like this:

 foreach ($result as $row) {
  ECHO "<div class="list-group-item checkbox">"
     . " <label><input type='checkbox' class='common_selector genre'"
     . " value=\"{$row['genre']}\"> {$row['genre']} </label>"
     . "</div>";
}

This is much more readable and puts out your rows of data. This

Richard Deeming · Answer 2 · 2018-10-23T03:38:00

SELECT DISTINCT(genre) FROM movie_db WHERE product_status = '1' ORDER BY movieid DESC

That will produce a resultset with a single un-named column. As a result, your rows do not contain a column called genre.

Give your column an alias:

SELECT DISTINCT(genre) As genre FROM movie_db WHERE product_status = '1' ORDER BY movieid DESC

Undefined index: checkbox in PHP

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0