Project Overview We require a freelancer to build a simple keyword monitoring web application using PHP + MySQL. The system will track public online content (news/web sources) based on predefined keywords and present results in a client dashboard with basic reports. The application will support multiple clients, each with restricted users and keyword limits, controlled by an admin. This is an MVP project with a strict scope and limited budget. User Roles 1. Admin (System Owner) • Create / edit clients • Set per-client limits: o Number of users o Number of keywords • Enable / disable clients • View basic system usage 2. Client Users (Max 3 per Client) • Secure login • Manage keywords (within assigned limit) • View monitoring results • Access reports • Export data Core Functional Features Keyword Monitoring • Keywords defined per client • Scheduled background job (cron-based) • Monitor public web / news sources only • Store matched results with: o Keyword o Source o Date/time o URL • Duplicate handling (basic) Client Dashboard • Total keywords monitored • Total results found • New results (last 24 hours / 7 days) • Recent activity list Client Reports (MVP Scope) 1. Keyword-wise Report • Keyword name • Total number of matches • Latest occurrence date • Filter by date range 2. Time-based Report • Results grouped by: o Day o Week • Date range filter (From – To) 3. Export • Export filtered results to CSV • Downloadable by client users Technical Requirements • Backend: PHP (no framework required) • Database: MySQL / MariaDB • Frontend: Basic HTML / CSS / JavaScript • Hosting: Standard shared hosting • Cron job for monitoring • Simple authentication (no SSO) Deliverables • Fully working web application • Source code • Database schema • Setup & deployment instructions • Admin credentials Out of Scope (Important – Not Included) • Social media platform APIs (Facebook, Instagram, TikTok, X) • Real-time streaming • Sentiment analysis • AI-based analysis • Advanced analytics or charts • PDF reports • Mobile app • Payment or subscription system Any request outside this scope will be treated as additional work. Timeline • 1 to 2 weeks Budget • Fixed budget • Please propose your best approach within a limited budget Required Skills • PHP & MySQL • Cron jobs • Data scraping or API consumption (public sources) • Clean and simple coding practices Nice to Have (Optional) • Experience with public news APIs • Experience building admin panels Important Note This project is intended as a Phase 1 MVP. Future enhancements may be discussed after successful delivery.