From 02b6f38e3300e10136692dd634dffbf5ece98867 Mon Sep 17 00:00:00 2001 From: Sudipto Mallick Date: Tue, 2 Jan 2024 15:30:50 +0530 Subject: Update the list of PHP assignmnets in `php-mysql/index.typ` --- mysql-php/index.typ | 17 +++++++++-------- 1 file changed, 9 insertions(+), 8 deletions(-) diff --git a/mysql-php/index.typ b/mysql-php/index.typ index c231878..21fe3bc 100644 --- a/mysql-php/index.typ +++ b/mysql-php/index.typ @@ -11,14 +11,15 @@ #set raw(lang: "php") -+ Create a table `Student` in a MySQL database containing the fields `name`, `roll`, `city`, `email` and `date_of_birth` and insert 5 records into this table and display them using PHP. -+ Write a PHP script to insert the records in the table in Question 2 and display the records in a separate table of all those students who were born in between `01/01/2000` to `31/12/2005`. -+ Design a HTML form to take a valid email from user and search the corresponding student from the database using PHP script and display the details of that student in tabular form. -+ Design a `Login` table to take `username` and `password`. Show all records of the `Student` table for an authorized user. A user if authorized when the username and password exists in the `Login` table of the MySQL database. -+ Design a Login form and check valid username and password to display student details using PHP script. Also write a PHP script allowing to change username and password. -+ Write PHP script to insert, delete and update records in a table. -+ Suppose a table `Food_Details` containing the fields `Food_items` and `Price_per_item`. Design a menu to select different food items and input the quantity ordered by customer. Generate a bill containing Customer name, Food items, quantity, price and Total price. Net price should be the total price plus 15% GST of total price. -+ Create a table as Question 7. Create another table `Customer_details` containing the fields `customer_name`, `total_amount_paid`, `date_of_payment`. Design a menu to select different food items and input the quantity ordered by customer. Generate a bill containing Customer name, Food items, quantity, and Total price. Also insert the record i.e. customer name, total amount paid and date of payment in `Customer_details` table. Net price should be the total price plus 15% GST of total price. ++ Create a table `Student` containing the fields `name`, `roll`, `city`, `email` and `date_of_birth`. Then, + - Insert 5 records into this table, + - Display all of them, and + - Display those students who were born in between `01/01/2000` to `31/12/2005`. + - Take a valid E-mail address from the user, search for the student with the E-mail address and display the details of the student. ++ Design a `Login` table to take `username` and `password`, and + - Show all records of the `Student` table for an authorized user, whose username and password exists in the `Login` table. + - Allow the authenticated users to change their username and password. ++ Suppose a table `Food_Details` containing the fields `Food_items` and `Price_per_item`. Create another table `Customer_details` containing the fields `customer_name`, `total_amount_paid`, `date_of_payment`. Design a menu to select different food items and input the quantity ordered by customer. Generate a bill containing Customer name, Food items, quantity, and Total price. Also insert the record i.e. customer name, total amount paid and date of payment in `Customer_details` table. Net price should be the total price plus 15% GST of total price. + Suppose a table `Salary` contained the fields `EmpName`, `BasicPay`, `HRA`, `DA` and `Professional_tax`. Record should exists only for `EmpName` and `BasicPay`. Design a HTML form to take input for HRA percentage, DA percentage, and Professional tax. Now write a PHP script to generate the DA, HRA and Professional tax of every employee and store them into Salary table with respect to every employee. Now display the records. + Design a HTML form to take inputs from user and store the records into a table `Employee` using PHP script containing the following fields. #align(center, tablex( -- cgit 1.4.1-2-gfad0