<?php
$sql = "SELECT ps_category.id_category, ps_category_lang.name, ps_category_lang.description, ps_category_lang.meta_title FROM `ps_category` JOIN ps_category_lang ON ps_category.id_category = ps_category_lang.id_category WHERE id_parent = 2 AND active = 1 ORDER BY position";
$res = mysqli_query($connection, $sql);
while($r = mysqli_fetch_assoc($res)){
  echo "<li class=\"dropdown menu-left padding-left-0 padding-right-15-md border-bottom border-bottom-0-md animated-bg-md animated-bar\">";
  echo "<a class=\"dropdown-toggle padding-left-20 padding-right-20 border-left border-right border-white text-uppercase\" data-toggle=\"dropdown\" role=\"button\" aria-haspopup=\"true\" aria-expanded=\"false\" data-title=\"" . $r["description"] . "\" href=\"/women-glasses\" tabindex=\"4\">" .$r["name"] . "</a>";
  echo "<div data-width-desktop=\"450px\" data-background-image=\"/img/c/" . $r["id_category"] . ".jpg\" class=\"dropdown-menu menu-mega-dropdown padding-30-md padding-top-40-md bg-gray-lightest border-top-0 padding-bottom-0-md padding-right-0-md open\" style=\"width: 450px; background-image: url(/img/c/".$r["id_category"].".jpg); display: block;\">";
  echo "<h3 class=\"color-gray-darker margin-top-0-md margin-bottom-25-md padding-left-20 padding-right-20 padding-0-md text-capitalize\">";
  echo "<a class=\"color-gray-darker\" href=\"/index.php?controller=category&id_category=".$r["id_category"]."\">" . $r["description"] . "</a>";
  echo "</h3>";
  echo "<div class=\"menu-dd-links visible-md-table font-small width-70p-md\">";
  echo "<div class=\"visible-md-table-row\">";
  echo "<ul class=\"visible-md-table-cell list-unstyled padding-0 vertical-align-top padding-bottom-20-md padding-right-35-md\">";
  echo "<li class=\"margin-bottom-10-md\"><a class=\"font-regular padding-left-20 padding-right-20 padding-left-0-md padding-right-0-md padding-top-15 padding-bottom-15 text-capitalize\" href=\"/premium-sunglasses-women\" target=\"_self\">Adaugati recent</a></li>";
  echo "<li class=\"margin-bottom-10-md\"><a class=\"font-regular padding-left-20 padding-right-20 padding-left-0-md padding-right-0-md padding-top-15 padding-bottom-15 text-capitalize\" href=\"/premium-sunglasses-women\" target=\"_self\">Cei mai vanduti</a></li>";
  $query_subcategories = "SELECT ps_category.id_category, ps_category_lang.name, ps_category_lang.meta_title FROM `ps_category` JOIN ps_category_lang ON ps_category.id_category = ps_category_lang.id_category WHERE id_parent = " . $r["id_category"] . " AND active = 1 ORDER BY position";
  $res_subcategories = mysqli_query($connection,  $query_subcategories);
  while($r_subcategories = mysqli_fetch_assoc($res_subcategories)) {
    echo "<li class=\"margin-bottom-10-md\"><a class=\"font-regular padding-left-20 padding-right-20 padding-left-0-md padding-right-0-md padding-top-15 padding-bottom-15 text-capitalize\" href=\"/premium-sunglasses-women\" target=\"_self\">" . $r_subcategories["name"] . "</a></li>";
  }
  echo "<li class=\"margin-bottom-10-md\"><a class=\"font-regular padding-left-20 padding-right-20 padding-left-0-md padding-right-0-md padding-top-15 padding-bottom-15 text-capitalize\" href=\"/index.php?controller=category&id_category=".$r["id_category"]."\" target=\"_self\">Toti ochelarii pentru " .$r["name"] . "</a></li>";
  echo "</ul></div></div>";
  echo "</div></li>";
  }
?>