From 0ac38a6f4ce7144635525a5a73bf2946d2909fa6 Mon Sep 17 00:00:00 2001 From: Sudipto Mallick Date: Sun, 4 Feb 2024 10:52:50 +0000 Subject: Starting PHP assignment #3 document --- mysql-php/text/a3.typ | 28 ++++++++++++++++++++++++++++ mysql-php/tpl.typ | 16 +++++++++------- 2 files changed, 37 insertions(+), 7 deletions(-) create mode 100644 mysql-php/text/a3.typ (limited to 'mysql-php') 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`], +) + diff --git a/mysql-php/tpl.typ b/mysql-php/tpl.typ index 124e349..28c8343 100644 --- a/mysql-php/tpl.typ +++ b/mysql-php/tpl.typ @@ -19,7 +19,7 @@ let code-color = rgb("#f4f4f4") // show raw: set text(font: "CommitMono", size: 1.1em) // show raw: set text(font: "Source Code Pro", size: 1.1em) - show raw: set text(font: "Iosevka Fixed", size: 10pt) + show raw: set text(font: "Iosevka Fixed", size: 1.1em) show raw.where(block: false): box.with( fill: code-color, inset: (x: 3pt, y: 0pt), @@ -46,9 +46,11 @@ #let objective(body) = align(center, [*Objective*: #body]) #let oset(kind) = block(spacing: 0.6em, [===== #h(1em) #kind]) -#let scos(n, obody) = { - [=== Source Code] - hlfile("/code/a" + str(n) + ".php") - [=== Output] - obody -} +#let scos(n, obody) = [ + === Source Code + #show raw: set text(size: 10pt) + #hlfile("/code/a" + str(n) + ".php") + === Output + #obody +] + -- cgit 1.4.1-2-gfad0