Barangay Resident Profiling and Information Management System (BRPMS) in PHP/MySQL

About the Project / Introduction

The Barangay Resident Profiling and Information Management System (BRPMS) is a comprehensive, web-based local governance application designed to modernize and streamline demographic data collection and record-keeping for local government units (LGUs). Historically, barangay officials and health workers have relied on cumbersome, paper-based masterlists and manual tallying to track constituent data. This outdated methodology is highly susceptible to data loss, physical damage, and extreme inefficiency when generating mandated statistical reports for national agencies like the DILG, DSWD, and DOH.

BRPMS bridges this technological gap by providing a secure, centralized digital repository for community data. The system utilizes a hierarchical data architecture, allowing administrators to map physical infrastructures by linking geographical zones (Puroks) to specific structural units (Households), and subsequently binding individual residents to these households.

Beyond basic demographics, the system boasts an Advanced Socio-Economic and Health Profiling Engine. It allows local officials to capture granular data points—ranging from employment status and educational attainment to critical health indicators (such as Hypertension, Diabetes, and PWD status), female reproductive health (pregnancy and family planning), and local food production activities (backyard farming and livestock).

Furthermore, the system features a Dynamic Reporting Module equipped with smart column-visibility toggles and multi-layered filters. This empowers barangay secretaries to instantly generate, preview, and export highly customized, visually appealing Excel spreadsheets and PDF documents, reducing administrative workload from days to mere seconds.

Features

1. Dashboard & Analytics

• Overview Metrics: Real-time counter for total active residents, registered households, and boarders.

• Theme Switcher: Integrated UI toggles for Light, Dark, and Grey modes to ensure comfortable viewing during long administrative sessions.

2. Household & Resident Management

• Hierarchical Structure: Group family members accurately under a single Household Number and Purok.

• Deep Resident Profiling: Capture 40+ distinct data points per resident, including:

  • Basic Info: Name, Age, Gender, Civil Status, Relation to Head.

  • Socio-Economic: Occupation, Monthly Income, Educational Attainment, Voter Status.

  • Health & Sanitation: Water Source, Toilet Type, Electricity Access, PWD status.

  • Medical Conditions: Track specific illnesses like CVD, HPN, Diabetes, Cancer, TB, Leprosy, and more.

  • Female Reproductive Health: Track pregnancy, breastfeeding, and Family Planning methods.

  • Food Security: Monitor backyard vegetable gardens, livestock, poultry, and fishponds.

• Post-Redirect-Get (PRG) Pattern: Robust form handling that prevents duplicate data entry upon accidental page refreshes.

3. Boarder Management

• Dedicated module to track transient populations and boarders residing within the barangay jurisdiction independently from permanent households.

4. Advanced Reporting & Export Engine

• Smart Column Visibility: A dynamic checklist that allows admins to hide or show specific data columns (e.g., hiding income to print a simple health report).

• Live PDF Preview: Integrated FPDF library instantly calculates page widths and renders a live, downloadable PDF based on active filters.

• Excel Export: Generates perfectly formatted .xls files complete with official Barangay logos and customizable headers/footers.

• Multi-layered Filters: Sort data alphabetically, by age, by income, or filter specifically for PWDs and specific age brackets.

5. Security & Data Integrity

• Secure Soft-Delete (Archiving): Records are never permanently deleted. Archiving a resident removes them from active reports but retains their data in the database.

• Admin Verification: Archiving a resident requires the active administrator to re-enter their password for authorization, preventing accidental deletions.

• Encrypted Credentials: Passwords are securely hashed using PHP's password_hash().

Technologies Used

• Front-End: HTML5, CSS3, JavaScript, FontAwesome Icons

• Back-End: PHP 8.x

• Database: MySQLi / MariaDB

• Libraries: FPDF (For dynamic PDF Generation)

Snapshots

Here are the following screenshots of this Barangay Resident Profiling and Information Management System:

Dashboard

Resident List

Household Management

Boarder Registration and Management

Reports

User Management

Installation / Setup Instructions

1. Download and Extract: Download the source code archive (.zip) and extract it.

2. Local Server Setup: Ensure you have a local server installed (such as XAMPP, WAMP, or MAMP).

3. Move Files: Copy the extracted folder (e.g., BRPMS_SANFABIAN) and paste it into your server's root directory:

   • For XAMPP: C:\xampp\htdocs\

4. Start Services: Open your XAMPP Control Panel and start Apache and MySQL.

5. Database Configuration:

   • Open your browser and navigate to http://localhost/phpmyadmin/.

   • Create a new database and name it barangay_db.

   • Click the Import tab, select the barangay_db.sql file included in the downloaded folder, and click "Go" to execute the import.

6. Run the System:

   • Open a new tab in your web browser and navigate to the project URL (e.g., http://localhost/BRPMS_SANFABIAN/).

7. Login: Use the default administrative credentials provided below.

Default Admin Credentials

• Username: admin

• Password: admin123 (Note: Update this in your actual source code if you changed the default hash)

Disclaimer: This system is a capstone/academic project intended for educational purposes and reference. It can be freely modified and utilized as a foundational framework for actual LGU implementations.

Explore more on this website for more Free Source Codes, Tutorials, and Articles covering various programming languages.