Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.54 KB | None | 0 0
  1. /*
  2. *Função que ira criar um menu dinamico
  3. *@param $urlBase irá receber a url
  4. */
  5. public function get_menu($urlBase){
  6. $sql_cat = "SELECT * FROM `categorias` ORDER BY id DESC";
  7. $categorias = self::conn()->prepare($sql_cat);
  8. $categorias->execute();
  9.  
  10. while($cat = $categorias->fetchObject()){
  11. echo '<li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">'.$cat->nome.'</a>';
  12. $sqlSub = "SELECT * FROM `subcat` WHERE id_cat = '".$cat->id."'";
  13. $subcat = self::conn()->prepare($sqlSub);
  14. $subcat->execute();
  15. //se não encontrar subcategoria na listagem ele fecha a lista
  16. if($subcat->rowCount() == 0){
  17. echo '</li>';
  18. }else{
  19. echo '<ul class="dropdown-menu">';
  20. //senao ele exibi a subcategoria
  21. while ( $sub = $subcat->fetchObject()) {
  22. echo '<li><a href="'.$urlBase.$sub->slug.'">'.$sub->nome.'</a></li>';
  23. }
  24. echo '</ul>';
  25. }
  26. echo '</li>';
  27. }
  28. }//TERMINA A FUNÇÃO GET MENU
  29.  
  30. <!--menuDinamico-->
  31. <nav class="navbar navbar-inverse">
  32. <div class="container">
  33. <div class="navbar-header">
  34. <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#menu-navegacao">
  35. <span class="icon-bar"></span>
  36. <span class="icon-bar"></span>
  37. <span class="icon-bar"></span>
  38. </button>
  39. <a class="navbar-brand hidden-md hidden-lg" href="">BccBueno</a>
  40. </div>
  41. <div class="collapse navbar-collapse menu-navegacao" id="menu-navegacao">
  42. <ul class="nav navbar-nav navbar-left" ng-repeat="menu in menus">
  43.  
  44. <li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">{{menu.nome}}</a></li>
  45. </ul>
  46. </div>
  47. </nav>
  48. <!--// menuDinamico-->
  49.  
  50. $scope.menu = function () {
  51. $http({
  52. method: 'post',
  53. url: 'php/select.php',
  54. data: {post: 'Menu'},
  55. }).then(function successCallback(response) {
  56. $scope.menus = response.data;
  57. console.log($scope.menus);
  58. alert(response.data);
  59. });
  60.  
  61.  
  62.  
  63. };
  64.  
  65. $sql = "SELECT * FROM `categorias` ORDER BY id DESC";
  66. $resultado = $dbhandle->query($sql);
  67. $data = array();
  68.  
  69. if ($resultado->num_rows > 0) {
  70. while ($row = $resultado->fetch_assoc()) {
  71. $data[] = $row;
  72. }
  73. }else{
  74. echo "0 resultados";
  75. }
  76.  
  77. var_dump($data);
  78.  
  79. echo json_encode($data);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement