Generate a complete, ready-to-run PHP project (no frameworks) that implements a public resume website plus an admin panel to edit all resume content. Requirements:
Project structure:
- index.php (public resume)
- admin/login.php, admin/dashboard.php, admin/edit.php, admin/logout.php
- inc/config.php (DB settings), inc/functions.php (helper functions)
- uploads/ (for profile picture)
- assets/ (css, simple responsive layout)
- sql/resume.sql (create DB + tables + seed admin)
Functionality:
1. Public resume (index.php) shows: name, headline, about, profile picture, experience (list: company, role, start_date, end_date, description), education (list), certifications (list), skills (comma separated), contact (email, phone), social links. Use a clean, mobile-first layout.
2. Admin authentication:
- admin login (username + password). Use PHP sessions.
- store admin password hashed with password_hash().
- logout endpoint destroys session.
3. Admin dashboard:
- show sections with "Edit" buttons for each (Profile, About, Experience, Education, Certifications, Skills, Contact).
- editing forms support adding/removing items for lists (experience/education/certifications). Keep implementation server-side (simple forms per item + add new).
- Edit profile picture: accept JPEG/PNG; limit file size to 2MB; sanitize filename; store in uploads/; remove previous file if replaced.
4. Security:
- Use PDO with prepared statements.
- CSRF token protection for all POST forms.
- Input validation + minimal escaping for output (htmlspecialchars).
- Rate-limit idea: block after 5 failed logins for session (commented guidance).
5. Database schema (create tables):
- admins (id, username, password_hash)
- resume_meta (id, name, headline, about, picture, skills, email, phone, social_json)
- experience (id, company, role, start_date, end_date, description, sort_order)
- education (id, institution, degree, start_year, end_year, description, sort_order)
- certifications (id, title, issuer, issue_date, link, sort_order)
6. Provide sql/resume.sql with CREATE TABLE and an initial admin user (username: admin). Use password placeholder comment showing how to create hash with PHP CLI: php -r "echo password_hash('YourPassword', PASSWORD_DEFAULT);"
7. Provide README with exact install steps:
- prerequisites (PHP >= 7.4, PDO MySQL, Apache/Nginx, MySQL/MariaDB).
- create database, import sql: `mysql -u root -p resume_db < sql/resume.sql`
- configure `inc/config.php`.
- set uploads/ writable: `chmod 755 uploads` or `chown www-data:www-data uploads`.
- open /admin/login.php and login.
8. Keep the code commented and concise. Use minimal external CSS (no frameworks), responsive design, and no JavaScript frameworks — only small unobtrusive JS for form UX if needed.
9. At the top of each PHP file include a short comment header explaining its purpose.
10. Output the project as individual files (do not zip). Provide full contents for each file.
Generate the full PHP source files as plaintext so I can copy them into my project.