SFGT - Student Freelancer Gig Tracker Vision A campus-built platform to connect students directly with freelance gig opportunities, making it simple for students to apply, earn, and gain experience—and for employers to post, review, and hire talented student freelancers easily.

Purpose Make freelance work accessible, affordable, and credible for students and campus employers. SFGT helps students build real portfolios and helps employers discover untapped talent.

Problem Addressed Gigs are hard to find for students. Traditional job sites are competitive and generic, leaving students with few local or campus opportunities.

Employers struggle to hire students quickly. No dedicated workflow, poor applicant tracking, and little transparency.

All sides want visibility and accountability. Status updates, history, clear analytics, and direct communication are missing in legacy platforms.

How SFGT Solves This Dedicated dashboards for students and employers with live stats and application/gig management.

Simple gig posting and one-click quick apply.

Application status filtering (pending, accepted, rejected) and summary counts.

Modern PHP/Tailwind implementation for lightweight, responsive usage on localhost/XAMPP.

Error-proof setup, clear troubleshooting, and port flexibility (default is 3307 for MySQL).

Key Features User authentication (email + password)

Custom dashboards by role (student/employer)

Gig browsing and posting

Application submission with cover letter, experience, rate

Live stats on applications, gigs, earnings/hiring

Review and status tracking

Secure session management

Getting Started Clone/download repository and import into XAMPP htdocs.

Create database: Create MySQL DB called sfgw (port 3307 recommended).

Import tables: Use included schema or migrations; main tables are signin, gigs, applications.

Start XAMPP services: Apache and MySQL (confirm port, update code if changed).

Configure DB connection in PHP:

php $pdo = new PDO('mysql:host=localhost;port=3307;dbname=sfgw', 'root', ''); Open app in browser, login or register, and use dashboard according to user role.

Troubleshooting Can't connect to MySQL: Check XAMPP's MySQL is running. Update port from 3306 to 3307 if you changed config.

Blank page or fatal error: Enable PHP errors, review error messages, check session and DB credentials.

Applications/gigs not displaying: Make sure you use matching field names (useremail in applications), and seed some test data if needed.

Authors & Contributors Built and maintained locally by students for students.

For support, contact project creator or use the provided troubleshooting guide.

License Personal, non-commercial use. Free for campus and student self-hosting.