Data Analysis & SQL4.5 · 50 ratings

Meeting Room Booking Web App Development

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…

Role-Based

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

How to use this prompt

  1. 1

    Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

  2. 2

    Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

  3. 3

    Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique

Recommended models

claudegpt-4ogemini

Build on this prompt

Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.

Open in Studio How to prompt AI correctly

More in Data Analysis & SQL

Translate Business Questions Into SQL

Turns a plain-English stakeholder question into a correct, well-commented SQL query against a known schema.

Read prompt

Optimize A Slow SQL Query

Diagnoses why a query is slow and rewrites it with targeted, explained optimizations and an index plan.

Read prompt

Debug A SQL Query That Returns Wrong Results

Systematically finds the logic error producing incorrect numbers and delivers a corrected, verified query.

Read prompt

Explain An Unfamiliar SQL Query In Plain English

Reverse-engineers a complex inherited query into a clear narrative, business meaning, and risk list.

Read prompt