<?php

require 'components/get_listview_referrer.php';
require 'subclasses/health.php';
$dbh_health = new health();
$dbh_health->set_where("health_id='" . quote_smart($health_id) . "'");
if ($result = $dbh_health->make_query()->result) {
    $data = $result->fetch_assoc();
    extract($data);
}
Example #2
0
<?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 citizen_id FROM citizen WHERE username='******'")->result;
extract($citizen->fetch_assoc());
$id_citizen = $citizen_id;
require_once 'subclasses/health.php';
$dbh_health = new health();
$dbh_health->execute_query("SELECT * FROM health WHERE citizen_id = {$id_citizen}");
$result1 = $dbh_health->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 $asthma;
    echo '</li>';
Example #3
0
require 'path.php';
init_cobalt('Delete health');
if (isset($_GET['health_id'])) {
    $health_id = urldecode($_GET['health_id']);
    require_once 'form_data_health.php';
}
if (xsrf_guard()) {
    init_var($_POST['btn_cancel']);
    init_var($_POST['btn_delete']);
    require 'components/query_string_standard.php';
    if ($_POST['btn_cancel']) {
        log_action('Pressed cancel button');
        redirect("listview_health.php?{$query_string}");
    } elseif ($_POST['btn_delete']) {
        log_action('Pressed delete button');
        require_once 'subclasses/health.php';
        $dbh_health = new health();
        $object_name = 'dbh_health';
        require 'components/create_form_data.php';
        $dbh_health->delete($arr_form_data);
        redirect("listview_health.php?{$query_string}");
    }
}
require 'subclasses/health_html.php';
$html = new health_html();
$html->draw_header('Delete Health', $message, $message_type);
$html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc);
$html->draw_hidden('health_id');
$html->detail_view = TRUE;
$html->draw_controls('delete');
$html->draw_footer();
Example #4
0
<?php

//****************************************************************************************
//Generated by Cobalt, a rapid application development framework. http://cobalt.jvroig.com
//Cobalt developed by JV Roig (jvroig@jvroig.com)
//****************************************************************************************
require 'path.php';
init_cobalt('Add health');
require 'components/get_listview_referrer.php';
if (xsrf_guard()) {
    init_var($_POST['btn_cancel']);
    init_var($_POST['btn_submit']);
    require 'components/query_string_standard.php';
    require 'subclasses/health.php';
    $dbh_health = new health();
    $object_name = 'dbh_health';
    require 'components/create_form_data.php';
    extract($arr_form_data);
    if ($_POST['btn_cancel']) {
        log_action('Pressed cancel button');
        redirect("listview_health.php?{$query_string}");
    }
    if ($_POST['btn_submit']) {
        log_action('Pressed submit button');
        $message .= $dbh_health->sanitize($arr_form_data)->lst_error;
        extract($arr_form_data);
        if ($dbh_health->check_uniqueness($arr_form_data)->is_unique) {
            //Good, no duplicate in database
        } else {
            $message = "Record already exists with the same primary identifiers!";
        }
Example #5
0
//****************************************************************************************
//Generated by Cobalt, a rapid application development framework. http://cobalt.jvroig.com
//Cobalt developed by JV Roig (jvroig@jvroig.com)
//****************************************************************************************
require 'path.php';
init_cobalt('Edit health');
if (isset($_GET['health_id'])) {
    $health_id = urldecode($_GET['health_id']);
    require 'form_data_health.php';
}
if (xsrf_guard()) {
    init_var($_POST['btn_cancel']);
    init_var($_POST['btn_submit']);
    require 'components/query_string_standard.php';
    require 'subclasses/health.php';
    $dbh_health = new health();
    $object_name = 'dbh_health';
    require 'components/create_form_data.php';
    extract($arr_form_data);
    if ($_POST['btn_cancel']) {
        log_action('Pressed cancel button');
        redirect("listview_health.php?{$query_string}");
    }
    if ($_POST['btn_submit']) {
        log_action('Pressed submit button');
        $message .= $dbh_health->sanitize($arr_form_data)->lst_error;
        extract($arr_form_data);
        if ($dbh_health->check_uniqueness_for_editing($arr_form_data)->is_unique) {
            //Good, no duplicate in database
        } else {
            $message = "Record already exists with the same primary identifiers!";
Example #6
0
//Generated by Cobalt, a rapid application development framework. http://cobalt.jvroig.com
//Cobalt developed by JV Roig (jvroig@jvroig.com)
//****************************************************************************************
require 'path.php';
init_cobalt('View health');
if (xsrf_guard()) {
    init_var($_POST['btn_cancel']);
    init_var($_POST['btn_submit']);
    if ($_POST['btn_cancel']) {
        log_action('Pressed cancel button');
        redirect("listview_health.php");
    }
    if ($_POST['btn_submit']) {
        log_action('Pressed submit button');
        require 'subclasses/health.php';
        $dbh_health = new health();
        if ($message == "") {
            log_action('Exported table data to CSV');
            $timestamp = date('Y-m-d');
            $token = generate_token(0, 'fs');
            $csv_name = $token . $_SESSION['user'] . '_health_' . $timestamp . '.csv';
            $filename = TMP_DIRECTORY . '/' . $csv_name;
            $csv_contents = $dbh_health->export_to_csv();
            $csv_file = fopen($filename, "wb");
            fwrite($csv_file, $csv_contents);
            fclose($csv_file);
            chmod($filename, 0755);
            $csv_name = urlencode($csv_name);
            $message = 'CSV file successfully generated: <a href="/' . BASE_DIRECTORY . '/download_generic.php?filename=' . $csv_name . '">Download the CSV file.</a>';
            $message_type = 'system';
        }