A full-stack web application for managing birth certificate registrations, approvals, and issuance for Ifaa Bulaa Kebele Administration, Jimma, Oromia, Ethiopia.
🌐 Live Demo: http://obcskebele.infinityfreeapp.com/
- Public Homepage — Service overview, announcements, and community feedback
- User Dashboard — Apply for birth certificates, track application status, make payments
- Admin Dashboard — Manage users, announcements, hospitals, and officers
- Hospital Dashboard — Submit birth records, manage records
- Kebele Staff Dashboard — Manage kebele IDs, review applications
- Officer Dashboard — Review and approve/reject applications, send messages
- Email Notifications — Automated emails via PHPMailer on application approval
- QR Code — Generated on issued certificates for verification
- Payment System — Upload payment screenshot for certificate fee
- Role-based Login — Separate login for Admin, Hospital, User, Kebele Staff, Officer
| Layer | Technology |
|---|---|
| Frontend | HTML, CSS, Bootstrap 5, JavaScript |
| Backend | PHP (MySQLi) |
| Database | MySQL |
| PHPMailer (Gmail SMTP) | |
| QR Code | phpqrcode library |
| Hosting | InfinityFree |
OBCS/
├── ADMIN/ # Admin dashboard pages
├── assets/ # Images and uploaded files
├── hospitaldashboard/ # Hospital dashboard pages
├── image/ # UI icons
├── images/ # Static images
├── kebeledashboard/ # Kebele staff dashboard pages
├── officer/ # Officer dashboard pages
├── phpqrcode/ # QR code generation library
├── public/ # Login and signup pages
├── setup/ # Database connection & SQL files
│ ├── dbconnection.php
│ └── missing_tables.sql
├── userdashboard/ # User dashboard pages
├── vendor/ # PHPMailer and other dependencies
└── index.php # Main homepage
- Create a MySQL database named
birth_certificate_database - Import the main schema (tables: users, applications, certificates, hospitals, birth_records, messages, announcements, payments, kebele_ids, kebele_officers, application_support, account_support)
- Run
setup/missing_tables.sqlto create thefeedbackandapplications_supporttables - Run this to add the missing column:
ALTER TABLE users ADD COLUMN current_address VARCHAR(255) AFTER last_name;- Clone the repository:
git clone https://github.com/Ebo1996/OBCS.git- Move the folder to
C:\xampp\htdocs\OBCS - Start Apache and MySQL in XAMPP Control Panel
- Import your database in phpMyAdmin
- Update
setup/dbconnection.php:
$hostName = "localhost";
$username = "root";
$password = "";
$database = "birth_certificate_database";- Visit
http://localhost/OBCS/
| Role | Path |
|---|---|
| Admin | /public/login_new/addminlogin.php |
| Hospital | /public/login_new/hopsitalogin.php |
| User | /public/login_new/userlogin.php |
| Kebele Staff | /public/login_new/kebelelogin.php |
| Officer | /public/login_new/officerlogin.php |
Currently deployed on InfinityFree free hosting.
- Live URL: http://obcskebele.infinityfreeapp.com/
- Database Host: sql305.infinityfree.com
- Files uploaded via: FileZilla FTP
Pull requests are welcome. For major changes, please open an issue first.
This project was developed for Ifaa Bulaa Kebele Administration, Jimma, Oromia, Ethiopia.