public function testGetMappedLicenseRefView()
{
$this->testDb = new TestPgDb();
$this->testDb->createPlainTables(array('license_ref', 'license_map'));
$this->dbManager = $this->testDb->getDbManager();
$this->dbManager->queryOnce("CREATE TABLE license_candidate (group_fk integer) INHERITS (license_ref)");
$this->dbManager->insertTableRow('license_map', array('license_map_pk' => 0, 'rf_fk' => 2, 'rf_parent' => 1, 'usage' => LicenseMap::CONCLUSION));
$this->dbManager->insertTableRow('license_ref', array('rf_pk' => 1, 'rf_shortname' => 'One', 'rf_fullname' => 'One-1'));
$this->dbManager->insertTableRow('license_ref', array('rf_pk' => 2, 'rf_shortname' => 'Two', 'rf_fullname' => 'Two-2'));
$this->dbManager->insertTableRow('license_candidate', array('rf_pk' => 3, 'rf_shortname' => 'Three', 'rf_fullname' => 'Three-3', 'group_fk' => $this->groupId));
$this->assertCountBefore = \Hamcrest\MatcherAssert::getCount();
$view = LicenseMap::getMappedLicenseRefView(LicenseMap::CONCLUSION);
$stmt = __METHOD__;
$this->dbManager->prepare($stmt, $view);
$res = $this->dbManager->execute($stmt);
$map = $this->dbManager->fetchAll($res);
$this->dbManager->freeResult($res);
assertThat($map, is(arrayWithSize(2)));
$expected = array(array('rf_origin' => 1, 'rf_pk' => 1, 'rf_shortname' => 'One', 'rf_fullname' => 'One-1'), array('rf_origin' => 2, 'rf_pk' => 1, 'rf_shortname' => 'One', 'rf_fullname' => 'One-1'));
assertThat($map, containsInAnyOrder($expected));
}
<?php
require "../lib/db.php";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if ($_FILES['image']['type'] === 'image/jpeg') {
$ext = '.jpg';
} else {
if ($_FILES['image']['type'] === 'image/png') {
$ext = '.png';
}
}
$filepath = DIRECTORY_SEPARATOR . "files" . DIRECTORY_SEPARATOR . "users" . DIRECTORY_SEPARATOR . time() . $ext;
move_uploaded_file($_FILES['image']['tmp_name'], '..' . $filepath);
$db = new DbManager();
$db->execute("INSERT INTO users (name, position_id, contact_number, profile_image_path, user_name, password) VALUES (?, ?, ?, ?, ?, ?);", array($_POST['name'], $_POST['position'], $_POST['contact_number'], $filepath, $_POST['user_name'], $_POST['password']));
}
<?php
session_start();
require "./lib/db.php";
require "./lib/util.php";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$myusername = addslashes($_POST['username']);
$mypassword = md5(addslashes($_POST['password']));
$db = new DbManager();
$users = $db->execute("SELECT id, full_name FROM users WHERE user_name = ? AND password = ?", array($myusername, $mypassword));
if (count($users) > 0) {
$_SESSION['login_username'] = $myusername;
$_SESSION['login_id'] = $users[0]['id'];
$_SESSION['login_full_name'] = $users[0]['full_name'];
header("location: pages/index.php");
} else {
header("location: index.php");
$_SESSION['error'] = 'Incorrect input';
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<meta name="description" content="">
<meta name="author" content="">
<?php
require "../lib/db.php";
if ($_SERVER["REQUEST_METHOD"] == "GET" && !empty($_POST['id'])) {
$db = new DbManager();
$user = $db->execute("SELECT u.name, p.name, u.contact_number, u.profile_image_path users u INNER JOIN positions p ON p.id = u.position_id WHERE id = ?;", array($_POST['id']));
echo json_encode($user);
}
<?php
include "../includes/header.php";
include "../includes/sidebar.php";
require "../lib/db.php";
require "../lib/util.php";
$db = new DbManager();
$options = $db->execute("SELECT id, genre, name FROM options ORDER BY id ASC", array());
$operators = $db->execute("SELECT id, genre, name FROM operators WHERE genre = 1 ORDER BY id ASC", array());
?>
<div id="page-wrapper">
<div class="row">
<div class="col-lg-12">
<h1 class="page-header"><i class="fa fa-folder fa-fw"></i> Reports</h1>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<div class="row">
<div class="panel panel-primary">
<div class="panel-heading">
Generate Report
</div>
<!-- /.panel-heading -->
<div class="panel-body">
<form class="form-inline">
<div class="form-group">
<select id="option" class="form-control">
<?php
foreach ($options as $i) {
?>
<?php
require "../lib/db.php";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$db = new DbManager();
$id = $db->execute("INSERT INTO residents (full_name, relationship_id, birth_date, birth_place, civil_status_id, years_of_residency, occupation, citizenship, religion, gender_id, highest_education_attainment_id, deleted) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);", array($_POST['full_name'], $_POST['relationship_id'], $_POST['birth_date'], $_POST['birth_place'], $_POST['civil_status_id'], $_POST['years_of_residency'], $_POST['occupation'], $_POST['citizenship'], $_POST['religion'], $_POST['gender_id'], $_POST['highest_education_attainment_id'], 0));
$db->execute("INSERT INTO owner_residents (owner_id, resident_id) VALUES (?, ?);", array($_POST['pk_owner'], $id));
echo $id;
}
<?php
include "includes/header.html";
include "includes/sidebar.html";
require "lib/db.php";
require "lib/util.php";
$db = new DbManager();
if (!empty($_GET['id'])) {
$i = $db->execute("SELECT * FROM residents WHERE id = ?", array($_GET['id']));
}
$genders = $db->execute("SELECT id, name FROM genders ORDER BY id ASC", array());
$martial_statuses = $db->execute("SELECT id, name FROM martial_statuses ORDER BY id ASC", array());
?>
<div id="page-wrapper">
<div class="container-fluid">
<!-- Page Heading -->
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">
Resident Registration
</h1>
</div>
</div>
<!-- /.row -->
<form role="form" method="post" action="registration.php">
<input name="id" type="hidden" value="<?php
echo $_GET['id'];
<?php
require "../lib/db.php";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$db = new DbManager();
$db->execute("DELETE users WHERE id = ?;", array($_POST['id']));
}
<?php
include "../includes/header.php";
include "../includes/sidebar.php";
require "../lib/db.php";
require "../lib/util.php";
$id = $_GET['id'];
$db = new DbManager();
$genders = $db->execute("SELECT id, name FROM genders ORDER BY id ASC", array());
$ownerships = $db->execute("SELECT id, name FROM ownerships ORDER BY id ASC", array());
$educations = $db->execute("SELECT id, name FROM educations ORDER BY id ASC", array());
$civil_statuses = $db->execute("SELECT id, name FROM civil_statuses ORDER BY id ASC", array());
$relationships_dependent = $db->execute("SELECT id, name FROM relationships WHERE genre = 1 ORDER BY id ASC", array());
$relationships_boarder = $db->execute("SELECT id, name FROM relationships WHERE genre = 2 ORDER BY id ASC", array());
$house_statuses = $db->execute("SELECT id, name FROM house_statuses ORDER BY id ASC", array());
$owner = $db->execute("SELECT\n o.id\n , o.full_name\n , o.address\n , o.house_number\n , o.birth_date\n , o.birth_place\n , o.citizenship\n , o.religion\n , o.occupation\n , o.years_of_residency\n , os.id AS ownership_id\n , os.name AS ownership_name\n , e.id AS education_id\n , e.name AS education_name\n , c.id AS civil_status_id\n , c.name AS civil_status_name\n , g.id AS gender_id\n , g.name AS gender_name\n , h.id AS house_status_id\n , h.name AS house_status_name\n FROM owners o\n INNER JOIN ownerships os\n ON os.id = o.type_of_ownership_id\n INNER JOIN educations e\n ON e.id = o.highest_education_attainment_id\n INNER JOIN civil_statuses c\n ON c.id = o.civil_status_id\n INNER JOIN genders g\n ON g.id = o.gender_id\n INNER JOIN house_statuses h\n ON h.id = o.house_status_id\n WHERE o.id = ?\n", array($id));
$owner = $owner[0];
$residents = $db->execute("SELECT\n res.id\n , res.full_name\n , res.birth_date\n , res.birth_place\n , res.occupation\n , res.years_of_residency\n , r.id AS relationship_id\n , r.genre AS relationship_genre\n , r.name AS relationship_name\n , e.id AS education_id\n , e.name AS education_name\n , c.id AS civil_status_id\n , c.name AS civil_status_name\n , g.id AS gender_id\n , g.name AS gender_name\n FROM residents res\n INNER JOIN owner_residents ors\n ON ors.resident_id = res.id\n INNER JOIN owners o\n ON o.id = ors.owner_id\n INNER JOIN relationships r\n ON r.id = res.relationship_id\n INNER JOIN educations e\n ON e.id = res.highest_education_attainment_id\n INNER JOIN civil_statuses c\n ON c.id = res.civil_status_id\n INNER JOIN genders g\n ON g.id = res.gender_id\n WHERE o.id = ?\n", array($id));
?>
<div id="page-wrapper">
<div class="row">
<div class="col-lg-12">
<h1 class="page-header"><i class="fa fa-pencil"></i> Edit House</h1>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<div class="row">
<div class="col-lg-12">
<!-- Nav tabs -->
<?php
include "includes/header.html";
include "includes/sidebar.html";
require "lib/db.php";
require "lib/util.php";
$db = new DbManager();
if (!empty($_GET['id'])) {
$i = $db->execute("SELECT id, first_name, middle_name, last_name, suffix, birth_date, TIMESTAMPDIFF(YEAR,birth_date,CURDATE()) AS age, address_line_1, address_line_2, address_line_3, address_line_4, address_line_5, gender_id, martial_status_id, citizenship, contact_number FROM residents WHERE id = ?", array($_GET['id']));
}
$genders = $db->execute("SELECT id, name FROM genders ORDER BY id ASC", array());
$martial_statuses = $db->execute("SELECT id, name FROM martial_statuses ORDER BY id ASC", array());
?>
<div id="page-wrapper">
<div class="container-fluid">
<!-- Page Heading -->
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">
Resident Registration
</h1>
</div>
</div>
<!-- /.row -->
<form role="form">
<input name="id" type="hidden" value="<?php
<?php
require "../lib/db.php";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$db = new DbManager();
$db->execute("UPDATE residents SET\n full_name = ?\n , birth_date = ?\n , birth_place = ?\n , years_of_residency = ?\n , occupation = ?\n , citizenship = ?\n , religion = ?\n , relationship_id = ?\n , highest_education_attainment_id = ?\n , civil_status_id = ?\n , gender_id = ?\n , status_id = ?\n WHERE id = ?;\n ", array($_POST['full_name'], $_POST['birth_date'], $_POST['birth_place'], $_POST['years_of_residency'], $_POST['occupation'], $_POST['citizenship'], $_POST['religion'], $_POST['relationship_id'], $_POST['highest_education_attainment_id'], $_POST['civil_status_id'], $_POST['gender_id'], $_POST['status_id'], $_POST['resident_id']));
}
<?php
require "../lib/db.php";
if ($_SERVER["REQUEST_METHOD"] == "GET") {
$db = new DbManager();
$operators = $db->execute("SELECT\n opr.id AS id\n , opr.name AS name\n FROM options opt\n INNER JOIN operators opr\n ON opr.genre = opt.genre OR opr.genre = 1\n WHERE opt.id = ?\n ORDER BY opr.id ASC;\n ", array($_GET['option_id']));
$r = '';
foreach ($operators as $k => $v) {
$r = $r . '<option value="' . $v['id'] . '">' . $v['name'] . ' </option>';
}
echo $r;
}
<?php
require "../lib/db.php";
if ($_SERVER["REQUEST_METHOD"] == "GET") {
$db = new DbManager();
$residents = $db->execute("SELECT\n res.id\n , res.full_name\n , rel.name AS rel_name\n , gen.name AS gen_name\n , res.birth_date\n , res.birth_place\n , civ.name AS civ_name\n , res.years_of_residency\n , res.occupation\n , edu.name AS edu_name\n FROM residents res\n LEFT OUTER JOIN relationships rel\n ON rel.id = res.relationship_id\n LEFT OUTER JOIN genders gen\n ON gen.id = res.gender_id\n LEFT OUTER JOIN civil_statuses civ\n ON civ.id = res.civil_status_id\n LEFT OUTER JOIN educations edu\n ON edu.id = res.highest_education_attainment_id\n LEFT OUTER JOIN owner_residents ors\n ON ors.resident_id = res.id\n WHERE ors.owner_id = ? AND rel.genre = ?\n ORDER BY res.id ASC;\n ", array($_GET['pk_owner'], $_GET['genre']));
$r = '<tr><th></th><th>Full Name</th><th>Relationship</th><th>Gender</th><th>Birth Date</th><th>Birth Place</th><th>Civil Status</th><th>Years of Residency</th><th>Occupation</th><th>Highest Education Attainment</th></tr>';
foreach ($residents as $k => $v) {
$r = $r . '<tr>';
foreach ($v as $k2 => $v2) {
if (isset($_GET['edit']) && $k2 === 'id') {
$r = $r . '<td><button value="' . $v2 . '" style="float:right" class="btn btn-xs btn-danger"><span class="glyphicon glyphicon-remove"></span> </button></td>';
} else {
if ($k2 !== 'id') {
$r = $r . '<td>' . $v2 . ' </td>';
}
}
}
$r = $r . '</tr>';
}
echo $r;
}
<?php
require $_SERVER['DOCUMENT_ROOT'] . "/lib/db.php";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$db = new DbManager();
if (empty($_POST['pk_owner'])) {
$id = $db->execute("INSERT INTO owners (house_number, type_of_ownership_id, full_name, address, birth_date, birth_place, citizenship, religion, highest_education_attainment_id, years_of_residency, civil_status_id, occupation, gender_id, deleted) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);", array($_POST['house_number'], $_POST['type_of_ownership_id'], $_POST['full_name'], $_POST['address'], $_POST['birth_date'], $_POST['birth_place'], $_POST['citizenship'], $_POST['religion'], $_POST['highest_education_attainment_id'], $_POST['years_of_residency'], $_POST['civil_status_id'], $_POST['occupation'], $_POST['gender_id'], 0));
echo $id;
} else {
$id = $db->execute("UPDATE owners SET house_number = ?, type_of_ownership_id = ?, full_name = ?, address = ?, birth_date = ?, birth_place = ?, citizenship = ?, religion = ?, highest_education_attainment_id = ?, years_of_residency = ?, civil_status_id = ?, occupation = ?, gender_id = ? WHERE id = ?;", array($_POST['house_number'], $_POST['type_of_ownership_id'], $_POST['full_name'], $_POST['address'], $_POST['birth_date'], $_POST['birth_place'], $_POST['citizenship'], $_POST['religion'], $_POST['highest_education_attainment_id'], $_POST['years_of_residency'], $_POST['civil_status_id'], $_POST['occupation'], $_POST['gender_id'], $_POST['pk_owner']));
echo $id;
}
}
<?php
include "../includes/header.php";
include "../includes/sidebar.php";
require '../lib/db.php';
if (isset($_POST['id'])) {
$id = $_SESSION['login_id'];
$db = new DbManager();
if ($_POST['password'] == "") {
$query = $db->execute("UPDATE users SET full_name = ? WHERE id = ?", array($_POST['full_name'], $id));
header("location: user_settings.php");
$_SESSION['info'] = 'Successfully updated!';
$_SESSION['login_full_name'] = $_POST['full_name'];
} else {
$query = $db->execute("UPDATE users SET full_name = ?, password = md5(?) WHERE id = ?", array($_POST['full_name'], $_POST['password'], $id));
header("Refresh:0");
$_SESSION['info'] = 'Successfully updated!';
$_SESSION['login_full_name'] = $_POST['full_name'];
}
}
?>
<div id="page-wrapper">
<div class="row">
<div class="col-lg-12">
<h1 class="page-header"><i class="fa fa-gear fa-fw"></i> User Settings</h1>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<div class="row">
<div class="col-lg-6">
<?php
include "includes/header.html";
include "includes/sidebar.html";
require "lib/db.php";
$db = new DbManager();
$pos = $db->execute("SELECT id, name FROM positions ORDER BY id ASC", array());
?>
<div id="page-wrapper">
<div id="message"></div>
<div class="container-fluid">
<!-- Page Heading -->
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">
System Users
</h1>
</div>
</div>
<!-- /.row -->
<div class="panel panel-info">
<div class="panel-heading">
<button style="float:right" class="btn btn-primary btn-xs" data-toggle="modal" data-target="#myModalAdd"><span class="glyphicon glyphicon-plus"></span> Add New</button>
<h3 class="panel-title">
List of system users</h3>
</div>
<div class="panel-body">
<table class="table table-hover">
$where = $where . " '%" . $v[1] . "%' ";
} else {
if ($type === 'str' && strpos($k, 'Gender') === 0) {
$where = $where . " '" . $v[1] . "' ";
} else {
if ($type === 'int') {
$where = $where . " " . $v[1] . " ";
}
}
}
if ($first) {
$first = false;
}
}
$sql = $sql1 . $where . ' UNION ' . $sql2 . $where;
$residents = $db->execute($sql, array());
$h = '<thead><tr>';
if (count($residents) > 0) {
foreach ($residents[0] as $k => $v) {
$h = $h . '<td>' . $k . ' </td>';
}
$h = $h . '</tr></thead>';
}
$r = '<tbody>';
foreach ($residents as $k => $v) {
$r = $r . '<tr>';
foreach ($v as $k2 => $v2) {
$r = $r . '<td>' . $v2 . ' </td>';
}
$r = $r . '</tr>';
}
<?php
require "../lib/db.php";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if ($_FILES['image']['type'] === 'image/jpeg') {
$ext = '.jpg';
} else {
if ($_FILES['image']['type'] === 'image/png') {
$ext = '.png';
}
}
$filepath = DIRECTORY_SEPARATOR . "files" . DIRECTORY_SEPARATOR . "users" . DIRECTORY_SEPARATOR . time() . $ext;
move_uploaded_file($_FILES['image']['tmp_name'], '..' . $filepath);
$db = new DbManager();
$db->execute("UPDATE users SET name = ?, position_id = ?, contact_number = ?, profile_image_path = ? WHERE id = ?;", array($_POST['name'], $_POST['position'], $_POST['contact_number'], $filepath, $_POST['id']));
}
if ($_SERVER["REQUEST_METHOD"] == "GET" && !empty($_GET['words'])) {
$condition = "WHERE first_name LIKE ? OR middle_name LIKE ? OR last_name LIKE ? OR suffix LIKE ? OR address_line_1 LIKE ? OR address_line_2 LIKE ? OR address_line_3 LIKE ? OR address_line_4 LIKE ? OR address_line_5 LIKE ? OR citizenship LIKE ?";
$words = preg_split('/[\\s]+/', $_GET['words'], -1, PREG_SPLIT_NO_EMPTY);
$word = $words[0];
$param = array('%' . $word . '%', '%' . $word . '%', '%' . $word . '%', '%' . $word . '%', '%' . $word . '%', '%' . $word . '%', '%' . $word . '%', '%' . $word . '%', '%' . $word . '%', '%' . $word . '%');
} else {
if (!empty($_GET['page'])) {
$page = (int) $_GET['page'];
}
}
}
}
$db = new DbManager();
$offset = ($page - 1) * 10;
$sql = "SELECT id, CONCAT(first_name, ' ', IFNULL(middle_name, ''), ' ', last_name, ' ', IFNULL(suffix, '')) as full_name, birth_date, TIMESTAMPDIFF(YEAR,birth_date,CURDATE()) AS age, CONCAT(address_line_1, ' ', address_line_2, ' ', address_line_3, ' ', address_line_4, ' ', address_line_5) AS address FROM residents {$condition} ORDER BY modified_date_time DESC LIMIT {$offset}, 10;";
$residents = $db->execute($sql, $param);
$count = $db->execute("SELECT COUNT(1) AS c FROM residents {$condition} ;", $param);
$number_of_pages = (int) ceil($count[0]['c'] / 10);
?>
<div id="page-wrapper">
<div class="container-fluid">
<!-- Page Heading -->
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">
Resident Registration
</h1>
</div>
<?php
require "../lib/db.php";
if ($_SERVER["REQUEST_METHOD"] == "GET") {
$db = new DbManager();
$residents = $db->execute("SELECT\n own.house_number\n , gen.name AS gender\n , res.full_name\n , own.address\n , res.birth_date\n , res.birth_place\n , res.citizenship\n , res.religion\n , edu.name AS education\n , res.years_of_residency\n , civ.name AS civil_status\n , res.occupation\n , sts.name AS status\n FROM residents res\n LEFT OUTER JOIN relationships rel\n ON rel.id = res.relationship_id\n LEFT OUTER JOIN genders gen\n ON gen.id = res.gender_id\n LEFT OUTER JOIN civil_statuses civ\n ON civ.id = res.civil_status_id\n LEFT OUTER JOIN statuses sts\n ON sts.id = res.status_id\n LEFT OUTER JOIN educations edu\n ON edu.id = res.highest_education_attainment_id\n LEFT OUTER JOIN owner_residents ors\n ON ors.resident_id = res.id\n LEFT OUTER JOIN owners own\n ON own.id = ors.owner_id\n WHERE ors.resident_id = ?\n ORDER BY res.id ASC;\n ", array($_GET['resident_id']));
$r = '{';
foreach ($residents as $k => $v) {
foreach ($v as $k2 => $v2) {
$r = $r . '"' . $k2 . '":"' . $v2 . '",';
}
}
$r = preg_replace("/,\$/", "", $r);
$r = $r . '}';
echo $r;
}
<?php
include "../config/db_config.php";
include "../includes/header.php";
include "../includes/sidebar.php";
require "../lib/db.php";
require "../lib/util.php";
?>
<?php
$db = new DbManager();
$genders = $db->execute("SELECT id, name FROM genders ORDER BY id ASC", array());
$ownerships = $db->execute("SELECT id, name FROM ownerships ORDER BY id ASC", array());
$educations = $db->execute("SELECT id, name FROM educations ORDER BY id ASC", array());
$civil_statuses = $db->execute("SELECT id, name FROM civil_statuses ORDER BY id ASC", array());
$relationships_dependent = $db->execute("SELECT id, name FROM relationships WHERE genre = 1 ORDER BY id ASC", array());
$relationships_boarder = $db->execute("SELECT id, name FROM relationships WHERE genre = 2 ORDER BY id ASC", array());
$statuses = $db->execute("SELECT id, name FROM statuses ORDER BY id ASC", array());
$owner_id = $_GET['owner_id'];
if (isset($_GET['resident_id'])) {
$resident_id = $_GET['resident_id'];
} else {
$resident_id = '1000000';
}
if (isset($_GET["resident_id"])) {
$sqlResident = "\n\t\tselect\n\t\thouse_number\n\t\t, gen.name as gender\n\t\t, res.full_name\n\t\t, own.address\n\t\t, res.birth_date\n\t\t, res.birth_place\n\t\t, res.citizenship\n\t\t, res.religion\n\t\t, gen.id AS gen_id\n\t\t, gen.name as gender\n\t\t, edu.id AS edu_id\n\t\t, edu.name as education\n\t\t, res.years_of_residency\n\t\t, civ.id AS civ_id\n\t\t, civ.name as civil_statuses\n\t\t, res.occupation\n\t\t, sts.id AS sts_id\n\t\t, sts.name as status\n\t\t, rel.id AS rel_id\n\t\t, rel.genre AS rel_genre\n\t\t, rel.name AS relationship\n\t\tfrom residents res\n\t\tinner join owner_residents ors\n\t\ton ors.resident_id = resident_id\n\t\tinner join owners own\n\t\ton own.id = ors.owner_id\n\t\tinner join educations edu\n\t\ton edu.id = res.highest_education_attainment_id\n\t\tleft outer join statuses sts\n\t\ton sts.id = res.status_id\n\t\tinner join civil_statuses civ\n\t\ton civ.id = res.civil_status_id\n\t\tinner join genders gen\n\t\ton gen.id = res.gender_id\n\t\tinner join relationships rel\n\t\ton rel.id = res.relationship_id\n\t\twhere res.id = " . $_GET["resident_id"];
$resultResident = $conn->query($sqlResident);
$rowResident = $resultResident->fetch_assoc();
} else {
$sqlOwner = "\n\t\tselect\n\t\town.house_number\n\t\t, gen.name as gender\n\t\t, own.full_name\n\t\t, own.address\n\t\t, own.birth_date\n\t\t, own.birth_place\n\t\t, own.citizenship\n\t\t, own.religion\n\t\t, edu.name as education\n\t\t, own.years_of_residency\n\t\t, civ.name as civil_status\n\t\t, own.occupation\n\t\t, sts.name as status\n\t\tfrom owners own\n\t\tinner join educations edu\n\t\ton edu.id = own.highest_education_attainment_id\n\t\tleft outer join statuses sts\n\t\ton sts.id = own.status_id\n\t\tinner join civil_statuses civ\n\t\ton civ.id = own.civil_status_id\n\t\tinner join genders gen\n\t\ton gen.id = own.gender_id\n\t\twhere own.id = " . $owner_id;
$resultOwner = $conn->query($sqlOwner);
<?php
require "../lib/db.php";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$db = new DbManager();
$db->execute("DELETE FROM residents WHERE id = ?;", array($_POST['id']));
$db->execute("DELETE FROM owner_residents WHERE resident_id = ?;", array($_POST['id']));
}
<?php
include "includes/header.html";
include "includes/sidebar.html";
require "lib/db.php";
require "lib/util.php";
$db = new DbManager();
$genders = $db->execute("SELECT id, name FROM genders ORDER BY id ASC", array());
$martial_statuses = $db->execute("SELECT id, name FROM martial_statuses ORDER BY id ASC", array());
?>
<div id="page-wrapper">
<div class="container-fluid">
<!-- Page Heading -->
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">
Resident Registration
</h1>
</div>
</div>
<!-- /.row -->
<form role="form" method="post" action="registration.php">
<div class="panel panel-info">
<div class="panel-heading">
<h3 class="panel-title">Personal Information</h3>
</div>