Comprehensive PHP Repair and API Development

Job ID: 40165547

Budget: $30 – $250 SGD

PHP Fixes & API Development
1) Authentication & Login
Fix Gmail OAuth (Client ID, redirect URI, token expiry), direct login session issues, and Gemini API (key, limits, error handling, fallback).
Docs: login flow, OAuth/Gemini setup, error fixes.

2) UI / UX
Fix white/blue contrast (WCAG), attractions movement/slider bug (responsive), update main menu to include Transport & Transfers and show it under Attractions & Tickets.
Docs: before/after menu, CSS/JS changes.

3) Search & Filters
Fix broken search (API, SQL, indexing, empty states). Add filters: destination, price, duration, category, supplier, rating.
Docs: search logic, filter schema, SQL tuning.

4) Homepage
Redesign based on provided reference (responsive, fast, SEO).
Docs: layout & components.

5) Supplier API
Scalable modular supplier API, SQL storage, normalized schema, manual vs supplier data comparison table, sync to packages with conflict rules.
Docs: API, DB schema, sync logic.

6) Distributor API
Secure distributor API (JWT/API keys, rate limits, logs).
Docs: endpoints & auth flow.

7) Admin
Admin 2FA, roles, Menu-3 up/down, Menu-3 & 4 download options.
Docs: 2FA setup.

8) Security
Use bcrypt/Argon2 hashing (not Drive storage); secrets via manager.
Docs: security architecture.

9) Documentation
Purpose, approach, APIs/tables, deployment, maintenance per item.
Related categories: PHP SQL MySQL phpMyAdmin API Development Core PHP