summary refs log tree commit diff stats
diff options
context:
space:
mode:
-rw-r--r--mysql-php/index.typ17
1 files 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(