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 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128
|
<!-- Navbar fixed top -->
<div class="navbar navbar-default navbar-fixed-top" role="navigation">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">C*******l</a>
</div>
<div class="navbar-collapse collapse">
<!-- Left nav -->
<ul class="nav navbar-nav">
<li><a href="index.php">home</a></li>
<li> <a href="#" class="dropdown-toggle" data-toggle="dropdown">catalogue <b class="caret"></b></a></li>
<?php
$host = 'localhost';
$login = '****';
$pass = '*****';
$bdd = '*******';
try
{
$pdo = new PDO('mysql:host=' . $host . ';dbname=' . $bdd, $login, $pass);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e)
{
echo "<p>Erreur : " . $e->getMessage() . "</p>";
exit();
}
?>
<ul class="dropdown-menu">
<?php
// ici je recupére ma catégorie princpale ex pharmacie
$reponse = $pdo->query("SELECT id, parent_id, nom_" . $_SESSION['langue'] . " FROM categories WHERE parent_id = 0 AND etat = '1' ORDER BY position");
while ($donnees = $reponse->fetch(PDO::FETCH_ASSOC))
{
echo '<li>
<a href="' . menu_link($donnees['id'], $donnees["nom_" . $_SESSION['langue'] . ""]) . '">' . $donnees["nom_" . $_SESSION['langue'] . ""] . '<span class="caret"</span></a>';
?>
<ul class="dropdown-menu">
<?php
// ici je recupére la categorie enfant de la categorie principale
// ex pharmacie -> accessoires
$req = $pdo->prepare("SELECT id, parent_id , nom_" . $_SESSION['langue'] . " FROM categories WHERE parent_id = ? AND etat = '1' ORDER BY position ASC");
$req->execute(array(
$donnees['id']
));
while ($donnees2 = $req->fetch(PDO::FETCH_ASSOC))
{
echo '<li>
<a href="' . menu_link($donnees2['id'], $donnees2["nom_" . $_SESSION['langue'] . ""]) . '">' . $donnees2["nom_" . $_SESSION['langue'] . ""] . '<span class="caret"></span></a>';
?>
<ul class="dropdown-menu">
<?php
//Icije recupére lasoussouscategorie ex pharmacie->accessoires->piluliers
$rep = $pdo->prepare("SELECT id, parent_id , nom_" . $_SESSION['langue'] . " FROM categories WHERE parent_id = ? AND etat = '1' ORDER BY position ASC");
$rep->execute(array(
$donnees2['id']
));
while ($donnees3 = $rep->fetch(PDO::FETCH_ASSOC))
{
echo '
<li class="disabled"><a class="disabled" href="' . menu_link($donnees3['id'], $donnees3["nom_" . $_SESSION['langue'] . ""]) . '">' . $donnees3["nom_" . $_SESSION['langue'] . ""] . '</a></li>';
}
}
}
?>
</ul>
</li>
</ul>
</li>
</ul>
</li>
</ul> |
Partager