Jean-Pierre Niyibizi - Geotechnical Engineer Portfolio

# Jean-Pierre Niyibizi - Geotechnical Engineer Portfolio

## Project Overview
Professional portfolio and business website for Jean-Pierre Niyibizi, a Geotechnical Engineer and Africa Sustainability Advocate. The site features:
- Dynamic content management system
- Blog and portfolio showcases
- Contact form for client inquiries
- Admin dashboard for content updates
- SQLite database (no external DB required)

## Technical Stack
- **Language**: PHP 8.2.23
- **Database**: SQLite (file-based, portable)
- **Frontend**: Bootstrap 5, vanilla JavaScript
- **Architecture**: MVC-like pattern with routing

## Project Structure
```
/
├── admin/              # Admin panel (login, dashboard, content management)
├── public/             # Public-facing website
│   ├── assets/        # Images, logos, static files
│   ├── partials/      # Reusable components (nav, footer, sections)
│   └── uploads/       # User-uploaded content
├── db.php             # Database bootstrap & auto-seeding
├── db.sqlite          # SQLite database file
└── router.php         # Custom routing logic
```

## Key Features
1. **Auto-initializing Database**: `db.php` creates and seeds the database on first run
2. **Admin Dashboard**: Located at `/admin` with full CRUD capabilities
3. **Dynamic Sections**: Content sections managed via database
4. **Security**: CSRF protection, prepared statements, input sanitization
5. **Contact Form**: Built-in with message storage

## Development Setup (Replit)
The server runs on port 5000 using PHP's built-in server with custom routing:
```bash
php -S 0.0.0.0:5000 -t . router.php
```

## Default Admin Credentials
- **Username**: admin
- **Password**: admin123
- **Note**: Change password immediately after first login via the dashboard

## Recent Changes
- **2025-10-09 (Latest)**: Added Rich Text Editor and SEO Features
  - Integrated TinyMCE rich text editor for blog posts and portfolio content
  - Added SEO fields: URL slugs, meta descriptions, and meta keywords
  - Implemented auto-slug generation from titles (URL-friendly)
  - Redesigned admin dashboard with modal-based editing UI
  - Enhanced blog posts and portfolio management with better UX
  - Database migration: Added meta_description, meta_keywords, and slug columns to posts and portfolio tables
  
- **2025-10-09**: Fresh GitHub import and Replit environment setup
  - Verified PHP 8.2.23 is installed and working
  - Configured workflow "Server" on port 5000 (0.0.0.0:5000) with router.php
  - Added favicon.ico handler to router.php to serve logo.jpg as favicon
  - Configured autoscale deployment for production
  - Verified all pages work: homepage, blog, portfolio, admin login
  - Confirmed database (db.sqlite) exists and is functional
  - All static assets (images, CSS, JS) are loading correctly

## Database Tables
- `users` - Admin users and authentication
- `settings` - Site-wide configuration
- `sections` - Dynamic page sections
- `messages` - Contact form submissions
- `posts` - Blog posts
- `portfolio` - Portfolio projects
- `newsletter_subscribers` - Email subscriptions
- `content_elements` - Granular content management

## Important URLs
- **Homepage**: `/` or `/public/index.php`
- **Admin Login**: `/admin/login.php`
- **Admin Dashboard**: `/admin/dashboard.php`
- **Blog**: `/public/blog.php`
- **Portfolio**: `/public/portfolio.php`

## User Preferences
None documented yet.

## Notes
- No external dependencies (no Composer, no npm)
- Database auto-creates on first access
- Uploads directory has security rules via .htaccess
- All forms include CSRF protection