Undefined index html select

Question

I want to be able to use a value from a select in my php code, but every time i get a notice saying undefined index categorie, what am I doing wrong? I've searched stuff similar to this and they all tell me to do what I'm doing already, can someone help?

<select name="categorie" value="all">
                    <option value="all">All</option>
                    <option value="action">Action</option>
                    <option value="romance">Romance</option>
                    <option value="comedy">Comedy</option>
                    <option value="drama">Drama</option>
                    <option value="horror">Horror</option>
                    <option value="fantasy">Fantasy</option>
                    <option value="scifi">Sci-fi</option>
                </select>
                <br>
                <form method="post" action="">
                <input type="submit" value="Search" name="search">
                </form>
                <?php
                $db = new PDO('mysql:host=localhost;dbname=id1552202_accounts', 'id1552202_thecouch', 'Fargo123');   
                if(isset($_POST['search'])){
                   $categorie = $_POST['categorie'];
                    if( $categorie === "all"){
                        $all = $db->prepare("SELECT name, path FROM Reviews ORDER BY date");   
             $all->execute();
        while($result = $all->fetch(PDO::FETCH_ASSOC)){
         echo $result['name'];
            echo '<br>';
        echo $result['path'];
         }
                    } else 

                    $selectreview = $db->prepare("SELECT name, path FROM Reviews WHERE genre = :categorie ORDER BY date");   
                    $selectreview->bindParam("categorie", $categorie);
             $selectreview->execute();
        while($result = $selectreview->fetch(PDO::FETCH_ASSOC)){
         echo $result['name'];
            echo '<br>';
            echo '<br>';
        echo $result['path'];
         }
        }

capcj · Answer 1 · 2017-05-21T02:04:51.487

Your category is not defined, that why you're experiencing that error, you must define that. Filtered well within first conditional, but need to improve in the else statement. Other point is the select outside form: in that way it will never get the value of the select, put inside the form like @addie said.

                $selectreview = $db->prepare("SELECT name, path FROM Reviews WHERE genre = :categorie ORDER BY date");   



                $selectreview->bindParam("categorie", $categorie);



         $selectreview->execute();
    while($result = $selectreview->fetch(PDO::FETCH_ASSOC)){
     echo $result['name'];
        echo '<br>';
        echo '<br>';
    echo $result['path'];
     }

My suggestion is, in the else, take the reviews without categorie bind, just to fill your frontend before the user select one to filter!

} else 

                    $selectreview = $db->prepare("SELECT name, path FROM Reviews ORDER BY date, categorie");   

             $selectreview->execute();
        while($result = $selectreview->fetch(PDO::FETCH_ASSOC)){
         echo $result['name'];
            echo '<br>';
            echo '<br>';
        echo $result['path'];
         }

Yeah! And the else is the condition that code doesn't run. You're binding a value that does not exist until you submit the form. It's wrong. — capcj, May 21 '17 at 02:00

Adnan · Answer 2 · 2017-05-21T02:01:48.923

1

place <form> on top of html, worked for me

<form method="post" action="">
    <select name="categorie">
    <option value="all">All</option>
    <option value="action">Action</option>
    <option value="romance">Romance</option>
    <option value="comedy">Comedy</option>
    <option value="drama">Drama</option>
    <option value="horror">Horror</option>
    <option value="fantasy">Fantasy</option>
    <option value="scifi">Sci-fi</option>
    </select>
<input type="submit" value="Search" name="search">
</form>

edited May 21 '17 at 02:01

answered May 21 '17 at 01:46

Adnan

101
2
10

yeah, i already did that – luis alcantara May 21 '17 at 01:50
He already did! – capcj May 21 '17 at 01:50
why the down vote? – Adnan May 21 '17 at 01:52
1

Because you did not paid attention to the code oO – capcj May 21 '17 at 01:58
yes my bad, i got it now – Adnan May 21 '17 at 01:59
@Carlos Alexandre check my edit – Adnan May 21 '17 at 02:02
I already checked :) – capcj May 21 '17 at 02:03
1

and thanks for reminding me about that – Adnan May 21 '17 at 02:04

Undefined index html select

2 Answers2