━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
  CY CONSULTANCY CENTRE — ADMIN PANEL
  README & SETUP GUIDE
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

STEP 1: DATABASE SETUP
──────────────────────
1. Open phpMyAdmin (http://localhost/phpmyadmin)
2. Import the file: cy-php/admin/setup.sql
   (This creates the cy_consultancy database + all tables)

STEP 2: DATABASE CREDENTIALS
─────────────────────────────
Edit: cy-php/admin/includes/config.php

Change these lines:
  define('DB_HOST', 'localhost');    ← usually stays localhost
  define('DB_USER', 'root');         ← your MySQL username
  define('DB_PASS', '');             ← your MySQL password
  define('DB_NAME', 'cy_consultancy');

STEP 3: VISIT ADMIN PANEL
──────────────────────────
URL: http://localhost/cy-php/admin/login.php

Default Login:
  Username: admin
  Password:  admin123

⚠️ CHANGE YOUR PASSWORD after first login!

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
  ADMIN PANEL FEATURES
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 DASHBOARD
  - Stats overview (pages, posts, messages, etc.)
  - Recent blog posts & messages
  - Quick action buttons

📄 PAGES
  - Add / Edit / Delete website pages
  - Set hero heading, subheading, background image
  - Rich text content editor (Quill)
  - SEO meta title & description
  - Published / Draft status

📝 BLOG POSTS
  - Full CRUD with rich text editor (Quill)
  - Categories: Study Tips, Visa Guide, etc.
  - Featured image upload
  - Published / Draft + publish date
  - Auto-generated slug from title

🛎 SERVICES
  - Add / Edit / Delete services
  - FontAwesome icon picker support
  - Sort order management
  - Active / Inactive status

🌍 DESTINATIONS
  - Country management with flag emoji
  - Description + full content
  - University count
  - Active / Inactive

🏛 UNIVERSITIES
  - Link to destinations
  - Logo upload
  - Website URL
  - Sort order

⭐ SUCCESS STORIES
  - Student photo upload
  - Destination + university info
  - Testimonial text
  - Year + sort order

🖼 GALLERY
  - Multi-file upload (bulk)
  - Category filter (students, events, office, etc.)
  - Show/hide per image
  - Grid preview with delete

📬 MESSAGES
  - Gmail-style inbox layout
  - Read / Unread status
  - Click to view full message
  - Reply via Email button
  - WhatsApp reply button (if phone provided)

⚙ SITE SETTINGS
  - Site name, email, phone, address
  - WhatsApp & Facebook links
  - Homepage hero text
  - Default SEO meta tags
  - Logo upload
  - Footer copyright text

💻 HEADER/FOOTER EDITOR
  - Edit raw includes/header.php
  - Edit raw includes/footer.php
  - Syntax-aware textarea with tab support
  - Warning before saving

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
  FILE STRUCTURE
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

cy-php/
├── admin/
│   ├── setup.sql              ← Run this first!
│   ├── login.php              ← Login page
│   ├── logout.php
│   ├── index.php              ← Dashboard
│   ├── includes/
│   │   ├── config.php         ← DB config + helpers
│   │   ├── header.php         ← Admin layout top
│   │   └── footer.php         ← Admin layout bottom
│   └── pages/
│       ├── pages.php          ← Website pages CRUD
│       ├── page-add.php
│       ├── page-edit.php
│       ├── blog.php           ← Blog CRUD
│       ├── blog-add.php
│       ├── blog-edit.php
│       ├── services.php       ← Services CRUD
│       ├── destinations.php   ← Destinations CRUD
│       ├── universities.php   ← Universities CRUD
│       ├── success.php        ← Success stories
│       ├── gallery.php        ← Gallery + upload
│       ├── messages.php       ← Contact inbox
│       ├── settings.php       ← Site settings
│       └── header-footer.php  ← Code editor

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
  SECURITY NOTES
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✓ All admin pages require login (session check)
✓ Passwords stored as bcrypt hash
✓ All DB queries use prepared statements
✓ All output is htmlspecialchars() escaped
✓ File uploads: only allowed image extensions
✓ Add .htaccess to /admin/ to restrict by IP if needed

Built by Mamun — CY Consultancy Centre
