Certesha - Certification Verification Portal

An online certificate verification system built with PHP, MySQL, and Bootstrap.

Features

• Certificate Generation: Generate certificates for verified users
• Certificate Verification: Verify certificate authenticity online
• Contact Management: Submit and manage contact inquiries
• Feedback System: Collect user feedback with ratings
• Newsletter Subscription: Subscribe users to newsletter updates
• Admin Dashboard: Manage certificates, users, and feedback
• Secure Authentication: Login system with password hashing and remember-me functionality

System Requirements

• PHP: 7.4 or higher
• MySQL: 5.7 or higher
• Web Server: Apache with mod_rewrite enabled
• Modern Browser: Chrome, Firefox, Safari, or Edge

Installation

1. Clone or Download the Repository

git clone https://github.com/codewithesha2002-design/Certesha-Certification-Verification.git
cd Certesha-Certification-Verification

2. Database Setup

1. Create MySQL database and user:

CREATE DATABASE cgv;
CREATE USER 'cgv'@'localhost' IDENTIFIED BY 'Design@sdl123';
GRANT ALL PRIVILEGES ON cgv.* TO 'cgv'@'localhost';
FLUSH PRIVILEGES;

2. Import the database schema:
   • See DATABASE_SCHEMA.md for detailed table structure
   • Run the SQL statements to create all tables

3. Configure Web Server

1. Point your web server document root to the project directory
2. Ensure .htaccess is enabled (for pretty URLs)
3. Set appropriate file permissions:

   chmod 755 -R ./
   chmod 644 -R ./*.php

4. Verify Installation

1. Open your browser and navigate to: http://localhost/
2. You should see the Certesha homepage
3. Test the certificate verification system at certv.php

File Structure

.
├── index.html              # Main landing page
├── certg.php              # Certificate generation page
├── certv.php              # Certificate verification page
├── contact.php            # Contact form handler
├── feedback.php           # Feedback form handler
├── newsletter.php         # Newsletter subscription handler
├── DATABASE_SCHEMA.md     # Database schema documentation
├── README.md              # This file
├── config/                # Configuration files
│   ├── db.php            # Database connection
│   ├── config.php        # Configuration & functions
│   ├── configverify.php  # Verification configuration
│   └── functions.php     # Main functions
├── assets/               # Static assets
│   ├── css/
│   ├── js/
│   ├── img/
│   └── vendor/           # Third-party libraries
├── login/                # Admin login system
│   ├── index.php
│   ├── login.php
│   ├── authenticate.php
│   ├── add_admin.php
│   ├── add_customer.php
│   └── ...
└── SQL/                  # SQL dump files
    └── cgv.sql

Configuration

Database Connection

Update the database credentials in:

• config/db.php (for public pages)
• login/config/config.php (for admin panel)

Current credentials:

• Host: localhost:3306
• User: cgv
• Password: Design@sdl123
• Database: cgv

Email Configuration (Optional)

For email functionality, update the email configuration in:

• assets/vendor/php-email-form/validate.js
• config/functions.php

Usage

Public Features

1. Home Page: View service offerings and company information
2. Generate Certificate: Navigate to certg.php and enter certificate ID
3. Verify Certificate: Navigate to certv.php and enter certificate ID
4. Contact Us: Fill the contact form in the footer
5. Feedback: Click the feedback button to submit ratings and comments
6. Newsletter: Subscribe to newsletter for updates

Admin Features

1. Login: Navigate to login/login.php
2. Manage Certificates: Add, view, and manage certificates
3. Manage Users: Add admin and customer accounts
4. View Feedback: Review customer feedback and ratings
5. Contact Management: View and manage contact inquiries

Security Features

• SQL Injection Prevention: Uses prepared statements with parameter binding
• XSS Protection: HTML escaping for output
• Password Security: Password hashing with bcrypt algorithm
• Session Management: Secure session handling with validation
• CSRF Protection: HTTP-only cookies and secure headers
• Input Validation: Server-side input validation for all forms

Troubleshooting

Database Connection Issues

• Verify MySQL server is running
• Check database credentials in config files
• Ensure database user has proper privileges

Form Submission Issues

• Check browser console for JavaScript errors
• Ensure PHP error reporting is enabled
• Verify form field names match expected values

Certificate Not Found

• Verify certificate exists in customers table
• Check certificate number format matches database
• Ensure customer record has all required fields

Support & Contact

• Email: codewithesha2002-design@gmail.com
• Twitter: @codewithesha
• LinkedIn: Kanika Sharma
• GitHub: codewithesha2002-design

License

See LICENSE file for details.

Development Status

This project is actively maintained. For issues and feature requests, please visit our GitHub repository.

---

Last Updated: March 7, 2026