diff options
Diffstat (limited to 'mysql-php/text/a3.typ')
| -rw-r--r-- | mysql-php/text/a3.typ | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-php/text/a3.typ b/mysql-php/text/a3.typ new file mode 100644 index 0000000..9f30e6c --- /dev/null +++ b/mysql-php/text/a3.typ @@ -0,0 +1,28 @@ +#import "/tpl.typ": * +#show: A => apply(A) +#set raw(lang: "php") +#set par(leading: 0.7em) + +#assignment(3)[ + Create the following tables: `Food_Details` with the fields `Food_item` and `Price_per_item`; `Customer_details` with the fields `customer_name`, `total_amount_paid`, `date_of_payment`. Design a form with the menu of food items, taking order from customer. Generate a bill containing the customer name, food items, quantity, and total price and insert a record in the `Customer_details` table. Net price is the total price plus 15% GST of total price. +] + +#scos(3)[ + === Menu form to order food items + #align(center, image("/output/3/1.png", width: 65%)) + === Bill generated from an order + #align(center, image("/output/3/2.png", width: 70%)) +] + +== Records in `STUDENTS_DB.STUDENT` +#table( + columns: 5, + [*`ROLL`*], [*`NAME`*], [*`CITY`*], [*`EMAIL`*], [*`DATE_OF_BIRTH`*], + [`24354946`], [`Hu Shengti`], [`Chengdu`], [`hst@m15342.cn`], [`2001-05-10`], + [`35464647`], [`Albert Rechtsburger`], [`Düsseldorf`], [`arb@gmx.de`], [`1999-06-17`], + [`76879140`], [`Nora Akagami`], [`Nara`], [`norakiki@mail.co.jp`], [`2002-07-04`], + [`78324598`], [`Grzegorz Brzezinski`], [`Łódź`], [`grzbrzski@fastmail.com`], [`1997-07-04`], + [`89764243`], [`Park Jihoon`], [`Busan`], [`pjh2346@naver.com`], [`2002-10-01`], + [`97381425`], [`Mark Sanders`], [`San Francisco`], [`marksanders@gmail.com`], [`2004-03-24`], +) + |