<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require 'header1.php'; require_once 'subclasses/document.php'; $dbh_document = new document(); $dbh_document->execute_query("SELECT d.document_name, r.requirement_name FROM document d JOIN requirement r ON d.document_id = r.document_id WHERE is_offered='yes'"); $result = $dbh_document->result; $document_requirements = array(); while ($row = $result->fetch_assoc()) { $document_requirements[] = $row; } $dbh_document->execute_query("SELECT DISTINCT document_name, document_description FROM document WHERE is_offered='yes'"); $result = $dbh_document->result; $documents = array(); while ($row = $result->fetch_assoc()) { $documents[] = $row; } ?> <main> <div class="block-body"> <h1 class="doc-headings">Listahan ng mga Dokumento</h1><br/><br/> <div class="div-list-doc"> <hr class="hr"> <center> <?php foreach ($documents as $row) { extract($row); echo "<ul class='list-of-doc'>";