bonjour voila j'ai un petit souci dans mon code et je patauge un peu je suis debutant alors j'affiche mon menu via une BDD le menu s'affiche mais pas mes ITEM voici mon code merci de votre aide
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
 
            <?php
                require 'admin/database.php';
 
                echo '<nav class="navbar2 navbar-expand-sm navbar-dark">
                <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav2" aria-controls="navbarNav2" aria-expanded="false" aria-label="Toggle navigation">
                          <span class="navbar-toggler-icon"></span>
                  </button>
                  <div class="collapse navbar-collapse" id="navbarNav2">
                  <ul class="nav nav-pills justify-content-center mr-auto " id="myTab" role="tablist">';
 
                $db = Database::connect();
                $statement = $db->query('SELECT * FROM category');
                $category = $statement->fetchAll();
                foreach ($category as $category) 
                {
                    if($category['id'] == '2')
                        echo '<li class="nav-item"><a class="nav-link active" id="' . $category['id'] . '" data-toggle="tab"  href="#' . $category['id'] . '" role="tab" aria-controls="' . $category['id'] . '" aria-selected="true">' . $category['name'] . '</a></li>';
 
                    else
                        echo '<li class="nav-item"><a class="nav-link" id="' . $category['id'] . '" data-toggle="tab"  href="#' . $category['id'] . '" role="tab" aria-controls="' . $category['id'] . '" aria-selected="false">' . $category['name'] . '</a></li>';
                }
 
                echo    '</ul>
                      </nav>';
 
echo '<div class="tab-content">';
 
                foreach ($category as $category) 
                {
                    if($category['id'] == '2')
                        echo '<div class="tab-pane active" id="' . $category['id'] .'" role="tabpanel" aria-labelledby="' . $category['id'] .'">';
                    else
                        echo '<div class="tab-pane" id="' . $category['id'] .'" role="tabpanel" aria-labelledby="' . $category['id'] .'">';
 
                    echo '<div class="row">';
 
                    $statement = $db->prepare('SELECT * FROM items WHERE items.category = ?');
                    $statement->execute(array($category['id']));
                    while ($item = $statement->fetch()) 
                    {
                        echo '<div class="col-">
                                <div class="thumbnail">
                                    <img src="images/' . $item['image'] . '" alt="...">
                                    <div class="caption">
                                        <h4>' . $item['name'] . '</h4>
                                        <p>' . $item['description'] . '</p>
                                        <button type="button" class="btn  btn-sm btn-block btn-order"><a href="#"><span class="fas fa-download"></span> download</a></button>
                                    </div>
                                </div>
                            </div>';
                    }
 
                   echo    '</div>
                        </div>';
                }
                Database::disconnect();
                echo  '</div>';
            ?>