Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- *Função que ira criar um menu dinamico
- *@param $urlBase irá receber a url
- */
- public function get_menu($urlBase){
- $sql_cat = "SELECT * FROM `categorias` ORDER BY id DESC";
- $categorias = self::conn()->prepare($sql_cat);
- $categorias->execute();
- while($cat = $categorias->fetchObject()){
- echo '<li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">'.$cat->nome.'</a>';
- $sqlSub = "SELECT * FROM `subcat` WHERE id_cat = '".$cat->id."'";
- $subcat = self::conn()->prepare($sqlSub);
- $subcat->execute();
- //se não encontrar subcategoria na listagem ele fecha a lista
- if($subcat->rowCount() == 0){
- echo '</li>';
- }else{
- echo '<ul class="dropdown-menu">';
- //senao ele exibi a subcategoria
- while ( $sub = $subcat->fetchObject()) {
- echo '<li><a href="'.$urlBase.$sub->slug.'">'.$sub->nome.'</a></li>';
- }
- echo '</ul>';
- }
- echo '</li>';
- }
- }//TERMINA A FUNÇÃO GET MENU
- <!--menuDinamico-->
- <nav class="navbar navbar-inverse">
- <div class="container">
- <div class="navbar-header">
- <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#menu-navegacao">
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </button>
- <a class="navbar-brand hidden-md hidden-lg" href="">BccBueno</a>
- </div>
- <div class="collapse navbar-collapse menu-navegacao" id="menu-navegacao">
- <ul class="nav navbar-nav navbar-left" ng-repeat="menu in menus">
- <li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">{{menu.nome}}</a></li>
- </ul>
- </div>
- </nav>
- <!--// menuDinamico-->
- $scope.menu = function () {
- $http({
- method: 'post',
- url: 'php/select.php',
- data: {post: 'Menu'},
- }).then(function successCallback(response) {
- $scope.menus = response.data;
- console.log($scope.menus);
- alert(response.data);
- });
- };
- $sql = "SELECT * FROM `categorias` ORDER BY id DESC";
- $resultado = $dbhandle->query($sql);
- $data = array();
- if ($resultado->num_rows > 0) {
- while ($row = $resultado->fetch_assoc()) {
- $data[] = $row;
- }
- }else{
- echo "0 resultados";
- }
- var_dump($data);
- echo json_encode($data);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement