Overview
This prompt aims to provide detailed guidance on enhancing a “to do” app by adding new fields for task management. Developers and programmers will benefit from clear instructions for implementing these changes effectively.
Prompt Overview
Purpose: This guide aims to enhance a “to do” app by adding new fields for task management.
Audience: It is intended for developers familiar with HTML, CSS, JavaScript, PHP, and MySQL.
Distinctive Feature: The app will now support task descriptions and priority levels, improving user experience and task organization.
Outcome: Users will successfully implement the changes, leading to a more functional and user-friendly application.
Quick Specs
- Media: Text
- Use case: Generation
- Industry: Development Tools & DevOps, General Business Operations, Productivity & Workflow
- Techniques: Decomposition, Prompt Templates, Structured Output
- Models: Claude 3.5 Sonnet, Gemini 2.0 Flash, GPT-4o, Llama 3.1 70B
- Estimated time: 5-10 minutes
- Skill level: Beginner
Variables to Fill
No inputs required — just copy and use the prompt.
Example Variables Block
No example values needed for this prompt.
The Prompt
You are enhancing a simple “to do” app built with HTML, CSS, JavaScript, PHP, and MySQL. The current app stores tasks but now requires additional fields:
– “description” (text describing the task)
– “priority” (indicating the task’s importance).
Your goal is to guide the user on how to add these new fields throughout the application, including front-end UI changes, back-end PHP handling, and database updates.
Consider the following steps:
1. Database Schema Update:
– Explain how to modify the MySQL database table to add new columns for “description” and “priority”.
2. Frontend UI Adjustments:
– Describe how to add inputs for “description” and “priority” in the HTML form:
– Use a textarea for description.
– Use select or radio buttons for priority.
– Update JavaScript code to:
– Collect these new inputs.
– Include them in the task data sent to the server.
3. Backend PHP Changes:
– Update PHP scripts to:
– Receive, validate, and process the new fields.
– Adjust any SQL queries for inserting or retrieving data to include the new fields.
Provide clear, specific instructions or example snippets for each part to ensure the user can implement the changes effectively. Encourage thorough testing after implementing each step.
# Output Format
Provide a structured explanation divided into three sections:
– Database Update
– Frontend Changes
– Backend Changes
Each section should include detailed guidance and example code snippets as needed.
# Notes
– Assume the user will provide full code files to integrate the changes.
– Focus on clarity and completeness to make the additions seamless.
– Emphasize validating user inputs for the new fields to maintain app stability.
Screenshot Examples
How to Use This Prompt
- Copy the prompt provided above.
- Paste it into your preferred text editor or IDE.
- Follow the structured sections for guidance: Database Update, Frontend Changes, Backend Changes.
- Implement the suggested code snippets step-by-step in your application.
- Test each change thoroughly to ensure functionality.
- Repeat the process if further adjustments are needed.
Tips for Best Results
- Database Update: Use the following SQL command to add “description” and “priority” columns to your tasks table:
ALTER TABLE tasks ADD COLUMN description TEXT, ADD COLUMN priority ENUM('low', 'medium', 'high'); - Frontend Changes: In your HTML form, add a for the description and a for priority. Example:
<textarea name="description"></textarea> <select name="priority"><option value="low">Low</option><option value="medium">Medium</option><option value="high">High</option></select> - Backend Changes: Update your PHP script to handle the new fields. Ensure you validate inputs:
$description = filter_input(INPUT_POST, 'description', FILTER_SANITIZE_STRING); $priority = filter_input(INPUT_POST, 'priority', FILTER_SANITIZE_STRING); - Testing: After implementing each change, thoroughly test the app to ensure that tasks are created, retrieved, and displayed correctly with the new fields included.
FAQ
- How to update MySQL database for new fields?
Use the ALTER TABLE command to add 'description' and 'priority' columns to your tasks table. - What HTML changes are needed for new inputs?
Add a <textarea> for 'description' and a <select> or radio buttons for 'priority' in your form. - How to modify JavaScript for new fields?
Update your JavaScript to collect values from the new inputs and include them in the task data sent to the server. - What PHP changes are required for new fields?
Update your PHP scripts to handle the new fields, including validation and modifying SQL queries for data operations.
Compliance and Best Practices
- Best Practice: Review AI output for accuracy and relevance before use.
- Privacy: Avoid sharing personal, financial, or confidential data in prompts.
- Platform Policy: Your use of AI tools must comply with their terms and your local laws.
Revision History
- Version 1.0 (February 2026): Initial release.
