<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require 'header1.php'; require 'components/get_listview_referrer.php'; $username = $_SESSION['user']; require_once 'subclasses/citizen.php'; $dbh_citizen1 = new citizen(); $citizen = $dbh_citizen1->execute_query("SELECT city FROM citizen WHERE username='******'")->result; extract($citizen->fetch_assoc()); $city_citizen = $city; require_once 'subclasses/school.php'; $dbh_school = new school(); $dbh_school->execute_query("SELECT * FROM school WHERE city = {$city_citizen} && is_evacuation = 'Yes'"); $result1 = $dbh_school->result; ?> <main> <div class="block-body"> <div class="fold-2"> <h3 class="fold-2-head center-obj fold-head">Mga lugar sa Ating Barangay</h3> <hr class="hr"/> <?php //echo $city_citizen; while ($row1 = $result1->fetch_assoc()) { extract($row1); echo '<li>'; echo $school_name; echo '</li>';
<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require 'header1.php'; require 'components/get_listview_referrer.php'; $username = $_SESSION['user']; require_once 'subclasses/citizen.php'; $dbh_citizen = new citizen(); $citizen = $dbh_citizen->execute_query("SELECT citizen_id,birth_date,birth_place,weight,height,civil_status FROM citizen WHERE username='******'")->result; extract($citizen->fetch_assoc()); ?> <main> <div class="fold-body"> <h3 class="fold-complain-head">Mag-Request ng Barangay ID</h3> <hr class="hr"/> <p class="complain-desc">Patunayang ikaw ay isang mamamayan sa ating barangay.</p> <?php if (xsrf_guard()) { init_var($_POST['btn_cancel']); init_var($_POST['btn_submit']); require 'components/query_string_standard.php'; require 'subclasses/cedula.php'; $dbh_cedula = new cedula(); $object_name = 'dbh_cedula'; require 'components/create_form_data.php'; extract($arr_form_data);