setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Function to fetch menu and sub-menu from the database function getMenu($pdo, $parent_id = NULL) { $query = 'SELECT id, menu_name, url FROM menupage WHERE (parent_id IS NULL AND :parent_id IS NULL) OR parent_id = :parent_id'; $stmt = $pdo->prepare($query); $stmt->execute([':parent_id' => $parent_id]); return $stmt->fetchAll(PDO::FETCH_ASSOC); } // Recursive function to build the menu array function buildMenuArray($pdo, $parent_id = NULL) { $menuArray = []; $menupage = getMenu($pdo, $parent_id); // Check if menu is found, otherwise return an empty array if (empty($menupage)) { return $menuArray; // Return empty array } foreach ($menupage as $menu) { $submenu = buildMenuArray($pdo, $menu['id']); // Recursive for submenu $menuArray[] = [ 'menu_name' => $menu['menu_name'], 'url' => $menu['url'], // Include 'url' in the array 'submenu' => $submenu ]; } return $menuArray; } // Generate menu array $menuData = buildMenuArray($pdo); ?>

Parak Laweh Pulau Air Nan XX, Kec. Lubuk Begalung, Kota Padang