Career Bridge is a web-based solution developed as a VI Semester BCA Project at St Claret College, Bangalore. It replaces manual placement tracking with an automated, secure platform.

• Students: Manage profiles, apply for jobs, and access MOOC/Internship resources.
• Administrators: Manage records, recruitment schedules, and verify eligibility.
• Companies: Filter and identify candidates based on GPA and skill sets.

• Secure Authentication: Multi-role login for students and administrators.
• Placement Dashboard: Real-time tracking of applications and interview status.
• Smart Password Reset: Secure token-based reset via PHPMailer & Google SMTP.
• Eligibility Matching: Automated filtering using GPA and technical skills.
• Resource Hub: Integrated links to training materials and external internships.

1. Install XAMPP: Ensure Apache and MySQL modules are running.
2. Clone the Project:

   cd C:/xampp/htdocs
   git clone [https://github.com/Thousifibrahim/CBSCC.git](https://github.com/Thousifibrahim/CBSCC.git) career-bridge

1. Open phpMyAdmin (http://localhost/phpmyadmin).
2. Create a new database named career_bridge.
3. Import the provided SQL schema file.
   • Note: If schema is missing, use the core table structure:

   CREATE TABLE studentlogin (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) NOT NULL UNIQUE,
    token VARCHAR(64),
    token_expiry DATETIME
   );

Update includes/config.inc.php with your Google App Password:

define('SMTP_HOST', 'smtp.gmail.com');
define('SMTP_USERNAME', 'your-email@gmail.com');
define('SMTP_PASSWORD', 'xxxx-xxxx-xxxx-xxxx'); // 16-character App Password
define('SMTP_PORT', 587);

1. Upload: Move project files to the public_html/ folder via FTP (FileZilla).
2. Database: Re-create the database in the hosting cPanel and update your credentials.
3. URL Sync: Ensure BASE_URL in your config file matches your live domain.

• Unit Testing: Verified SQL query execution and token validation logic.
• Integration: Seamless data flow between PHP backend and MySQL tables.
• Security: Implementation of input sanitization and secure SMTP privacy.
• UAT: Beta-tested with sample student and admin accounts.

• St Claret College: For academic infrastructure and support.
• Mentors: Dr. Chinmaya Dash (Project Guide) & Ms. Jayalakshmi R. (HOD).
• Resources: Documentation supported by W3Schools and GeeksforGeeks.

SMD Thousif Ibrahim & S R Sandeep BCA VI Semester | Batch 2023–24