developer coding template risk: low

PHP MySQL Meeting Room Booking App Builder

The prompt directs the model to act as a developer building a meeting room booking web app using PHP 7 and MySQL step by step, covering project structure, database schema, Tailwind…

PROMPT

Act as a developer tasked with building a meeting room booking web app using PHP 7 and MySQL. Your task is to develop the application step by step, focusing on different roles and features.

Your steps include:
1. **Create Project Structure**
   - Set up a project directory with necessary subfolders for organization.

2. **Database Schema**
   - Design a schema for meeting room bookings and user roles, ready for import into MySQL.

3. **UX/UI Design**
   - Utilize Tailwind CSS with Glassmorphism and a modern orange theme to create an intuitive interface.
   - Ensure a responsive, mobile-friendly design.

4. **Role Management**
   - **Admin Role**: Manage meeting rooms, oversee bookings.
   - **User Role**: Book meeting rooms via a calendar interface.

5. **Export Functionality**
   - Implement functionality to export booking data to Excel.

Rules:
- Use PHP 7 for backend development.
- Ensure security best practices.
- Maintain clear documentation for each step.

Variables:
- ${projectName} - Name of the project
- ${themeColor:orange} - Color theme for UI
- ${databaseName} - Name of the MySQL database

INPUTS

projectName REQUIRED

Name of the project

e.g. MeetingRoomBooking

themeColor

Color theme for UI

e.g. orange

databaseName REQUIRED

Name of the MySQL database

e.g. meeting_bookings

OPTIONAL CONTEXT

theme color

ROLES & RULES

Role assignments

Act as a developer tasked with building a meeting room booking web app using PHP 7 and MySQL.

Use PHP 7 for backend development.
Ensure security best practices.
Maintain clear documentation for each step.

EXPECTED OUTPUT

Format

markdown

Constraints

clear documentation for each step
use PHP 7
security best practices

SUCCESS CRITERIA

Create project structure with subfolders.
Design database schema for meeting room bookings and user roles.
Utilize Tailwind CSS with Glassmorphism and modern orange theme for UX/UI.
Ensure responsive mobile-friendly design.
Implement admin role for managing rooms and bookings.
Implement user role for booking via calendar.
Implement export functionality to Excel.

FAILURE MODES

May skip specified steps.
Might not adhere to PHP 7.
Could neglect security best practices.
UI may not be responsive or use specified theme.
Incomplete role management or export features.

CAVEATS

Dependencies

${projectName} variable
${themeColor:orange} variable
${databaseName} variable

Missing context

MySQL connection credentials or host details.
Authentication and authorization mechanisms (e.g., login, sessions).
Detailed booking features (e.g., time slots, recurrence, capacity).
Libraries for calendar UI and Excel export.

Ambiguities

Unclear specific admin actions for 'oversee bookings' (e.g., approve, edit, delete).
No specific calendar library or implementation details mentioned.
Export to Excel method or library not specified.
Glassmorphism design details vague.

QUALITY

OVERALL: 0.82
CLARITY: 0.85
SPECIFICITY: 0.80
REUSABILITY: 0.90
COMPLETENESS: 0.75

IMPROVEMENT SUGGESTIONS

Specify libraries: e.g., FullCalendar.js for calendar, PhpSpreadsheet for Excel export.
Detail security practices: PDO with prepared statements, bcrypt hashing, CSRF tokens, input validation.
Provide example project folder structure (e.g., /public, /includes, /assets).
Define precise features: booking duration limits, overlap prevention, notifications.
Add output format: e.g., provide code files, SQL dump, screenshots for each step.

USAGE

Copy the prompt above and paste it into your AI of choice — Claude, ChatGPT, Gemini, or anywhere else you're working. Replace any placeholder sections with your own context, then ask for the output.