Sr. No.	Category	Question
1.	HTML + CSS Real-World Practices	Build a simple device-friendly (responsive) portfolio website with a navbar, about section, projects section, and contact form.".
2.	HTML + CSS Real-World Practices	Create a dropdown navigation menu that changes style on hover or click ensuring it works for all screen sizes.
3.	HTML + CSS Real-World Practices	Design a registration form with input fields for name, email, phone, password, and a submit button.
4.	JavaScript Real-World Practices	Build a gallery that displays product images. When a user clicks on a thumbnail, the larger image updates accordingly. Implement a filter function using JavaScript to display products based on categories.
5.	JavaScript Real-World Practices	Create a countdown timer that counts down to a specific event (e.g., New Year's Day). Display days, hours, minutes, and seconds, and update the timer every second using JavaScript.
6.	JavaScript Real-World Practices	Use JavaScript to create a simple to-do list application where users can add tasks, mark them as completed, and remove them.
7.	jQuery Real-World Practices	Use jQuery to create an image slider or carousel. It should have controls (next/previous) and transition animations (fade/slide).
8.	jQuery Real-World Practices	Create a form that uses jQuery for client-side validation. For example, check if the email is in the correct format or if all fields are filled.
9.	jQuery Real-World Practices	Use jQuery to hide and show different sections of a webpage when certain buttons are clicked (e.g., showing additional information when clicking a "Read More" button).
10.	PHP Real-World Practices	Create a login and registration system using PHP and MySQL. Ensure the passwords are hashed, and sessions are used to keep users logged in.
11.	PHP Real-World Practices	Design a contact form that takes user input (name, email, message) and sends it via email using the PHP mail() function.
12.	PHP Real-World Practices	Build a basic CRUD app that allows users to add, update, view, and delete records from a MySQL database. You could build something like a blog post system or a simple inventory management app.
13.	PHP Real-World Practices	Create a PHP script that allows users to upload files (e.g., images, PDFs) and store them in a specific directory. Implement restrictions on file size and types.
14.	MySQLi + PHP + phpMyAdmin Real-World Practices	Use phpMyAdmin to create a database named employees_db with a table employees that stores: id (Primary key, Auto Increment), first_name (VARCHAR 100), last_name (VARCHAR 100), email (VARCHAR 150, UNIQUE), phone_number (VARCHAR 20). Write SQL queries in phpMyAdmin to insert, update, delete, and select data from this table.
15.	MySQLi + PHP + phpMyAdmin Real-World Practices	Create a PHP script to connect to the employees_db database using MySQLi and handle errors if the connection fails. Display a success message when the connection is successful.
16.	MySQLi + PHP + phpMyAdmin Real-World Practices	Use PHP to fetch all records from the employees table and display them in an HTML table. Add a search form to filter employees by last_name and display only the results that match the search term.
17.	CRUD (Create, Read, Update, Delete) Operations Real-World Practices	Design an HTML form to input employee details (first_name, last_name, email, phone_number). Write a PHP script to handle form submission and insert the employee record into the database using MySQLi INSERT query.
18.	CRUD (Create, Read, Update, Delete) Operations Real-World Practices	Display a list of employees with an "Edit" button next to each. When the "Edit" button is clicked, show an HTML form pre-filled with the employee's current data.
19.	CRUD (Create, Read, Update, Delete) Operations Real-World Practices	Use PHP to update the employee's record in the database using the MySQLi UPDATE query.
20.	CRUD (Create, Read, Update, Delete) Operations Real-World Practices	Add a "Delete" button next to each employee in the list. When the "Delete" button is clicked, prompt the user for confirmation (use JavaScript for confirmation). Use PHP to delete the employee from the database using the MySQLi DELETE query.
21.	Advanced Features Real-World Practices	Create a simple user authentication system. In phpMyAdmin, create a users table with fields: id, username, email, password (hashed). Build a registration form that stores the user’s details in the database with the password hashed using PHP's password_hash() function. Implement a login form that checks the credentials using MySQLi and starts a session upon successful login.
22.	Advanced Features Real-World Practices	Paginate by fetching employee data from the database and display it with pagination (e.g., 10 records per page). Use PHP to implement pagination logic and update the SQL query with LIMIT and OFFSET clauses.
23.	Advanced Features Real-World Practices	Create an employee management system where users can upload a profile picture along with their information. Modify the employees table to include a profile_picture column. Use an HTML file input field to allow image uploads, and PHP to handle the upload process (move files to a uploads/ folder). Store the file path in the database and display the uploaded image on the employee list.
24.	Advanced Features Real-World Practices	Create a Relationship Between Tables: In phpMyAdmin, create two tables: departments with id and department_name, employees with a department_id foreign key referencing departments(id). You can add more columns. Modify the employee management system to allow selecting a department when adding a new employee. Display employees along with their department name using a MySQLi JOIN query.
25.	Advanced Features Real-World Practices	Create a form that allows users to search for employees based on multiple criteria (e.g., first_name, department_name, phone_number). Write a PHP script that constructs a dynamic SQL query based on the input and fetches the results.
26.	Advanced Features Real-World Practices	Data Export to CSV: Add a button to export the employee data to a CSV file. Use PHP to fetch all employee records from the database and write them to a CSV file that users can download.
27.	Advanced Features Real-World Practices	Reporting and Analytics: Build a basic reporting page that shows statistics such as the total number of employees, number of employees per department, and employees added in the last month. Use phpMyAdmin to practice writing SQL aggregate functions (COUNT(), GROUP BY, HAVING) to fetch this data and display it in a dashboard.