Online Birth Certificate System Using PHP and MySQL

• Admin login and logout
• Admin dashboard with users, managers, applications, certificates, and recent activity
• Manage manager accounts
• Add manager
• Edit manager
• Delete manager
• Activate/deactivate manager accounts
• Manage citizen/user accounts
• Add user manually
• Edit user details
• Delete user account
• Activate/deactivate user accounts
• View all birth certificate applications
• View all death certificate applications
• Search and filter applications
• Approve birth certificate applications
• Approve death certificate applications
• Reject applications with reason
• Update application status manually
• Generate birth certificate
• Generate death certificate
• View certificate records
• Edit certificate records
• Delete certificate records
• Print certificates
• Download certificates
• Manage required document types
• Add document type
• Edit document type
• Delete document type
• Configure documents for birth/death/both application types
• Manage application statuses
• Manage status badge colors and descriptions
• Manage public notices
• Create, edit, delete, and toggle notices
• Manage contact/support queries
• Reply to contact queries
• Update query status
• Delete contact queries
• Manage website settings
• Configure site name, tagline, contact details, about content, terms, and help text
• Generate reports for users, managers, applications, and certificates
• Filter reports by date and status
• Print reports
• Update admin profile
• Change admin password

• Citizen registration
• Citizen login and logout
• Forgot password option
• Reset password using token
• User dashboard with total, pending, and approved application statistics
• View recent applications
• View active notices
• Apply for birth certificate
• Enter child details
• Enter parent details
• Upload required birth documents
• Apply for death certificate
• Enter deceased person details
• Enter applicant details
• Upload death certificate documents
• View submitted applications
• Filter applications by type
• Filter applications by status
• Track application status with timeline
• Track application using application number
• View approved certificates
• Download certificates
• Print certificates
• Submit contact/support query
• Update profile details
• Change password

• Manager login and logout
• Manager dashboard with assigned application statistics
• View pending application queue
• View recent certificate applications
• View birth certificate applications
• Search and filter birth applications
• View death certificate applications
• Search and filter death applications
• View applicant details
• View uploaded documents
• Verify application details
• Mark application as incomplete with note
• Forward verified applications to admin
• Reject invalid applications with mandatory reason
• Add remarks on applications
• Edit own remarks
• Delete own remarks
• View issued certificate records
• Search certificate records
• Filter certificate records
• Print certificate details
• Search citizen/user details
• View user profile
• View user application history
• Update manager profile
• Change manager password
• Complete online birth and death certificate system source code
• Suitable for final year project, major project, and minor project
• Project report content can be prepared from included modules
• Three role-based portals: Admin, Manager, and User
• Multi-stage application workflow
• Birth application number format: BIR-YYYY-XXXXX
• Death application number format: DTH-YYYY-XXXXX
• Application status flow: Pending → Under Review → Verified → Approved → Rejected → Certificate Generated
• Document upload support
• Allowed file types: JPG, JPEG, PNG, PDF
• Maximum upload size: 5 MB
• Public and logged-in application tracking
• Certificate print and download
• Contact query/support system
• Notices and announcement system
• Website settings management
• Pagination on list pages
• Search and filter options
• CSRF protection on forms
• PDO prepared statements
• Password hashing using password_hash() and password_verify()
• Input sanitization using htmlspecialchars
• Session-based authentication
• Role-based access control
• Inactive account status checking
• Password reset token system
• Setup script for password hash initialization
• Upload directory creation through setup script
• Useful for viva, source code review, project report writing, and project demonstration

w to run this code?

1. Copy the project folder into:

   C:\xampp\htdocs\Online Birth and Death Certificate System\

2. Start Apache and MySQL.

3. Import the database file:

   database/database.sql

4. Edit database configuration:

   config/db.php

5. Set database details:

   define('DB_HOST', 'localhost');
   define('DB_NAME', 'certificate_system');
   define('DB_USER', 'root');
   define('DB_PASS', '');
   define('DB_CHARSET', 'utf8mb4');

6. Edit base URL:

   config/constants.php

7. Set:

   define('BASE_URL', '/Online Birth and Death Certificate System');

8. Run setup script:

   http://localhost/Online%20Birth%20and%20Death%20Certificate%20System/setup/install.php

9. Verify upload folder:

   assets/uploads/

10. Delete the setup/ folder after installation.
11. Open application:

http://localhost/Online%20Birth%20and%20Death%20Certificate%20System/

Admin

• Username: admin
• Password: Admin@123
• Login URL: /admin/login.php

Sample Manager

• Username: manager1
• Password: Manager@123
• Login URL: /manager/login.php

Sample User

• Username: arjunv
• Password: User@123
• Login URL: /login.php