diff options
Diffstat (limited to 'mysql-php/text')
| -rw-r--r-- | mysql-php/text/a1.typ | 34 | ||||
| -rw-r--r-- | mysql-php/text/a2.typ | 4 |
2 files changed, 33 insertions, 5 deletions
diff --git a/mysql-php/text/a1.typ b/mysql-php/text/a1.typ index efdc981..b2ae406 100644 --- a/mysql-php/text/a1.typ +++ b/mysql-php/text/a1.typ @@ -8,8 +8,34 @@ ] #scos(1)[ - === Form page - #align(center, image("/output/1/1.png", width: 60%)) - === Display record - #image("/output/1/2.png", width: 100%) + === Menu page + #align(center, image("/output/1/1.png", width: 80%)) + === Form page + #align(center, image("/output/1/2.png", width: 70%)) + #v(4em) + === Display record + #image("/output/1/3.png", width: 80%) + === Display record (2000--2005) + #image("/output/1/4.png", width: 80%) + === Search record by email + ==== Form + #align(center, image("/output/1/5.png", width: 50%)) + #v(3em) + ==== Record found + #align(center, image("/output/1/6.png", width: 70%)) + ==== Record not found + #align(center, image("/output/1/7.png", width: 80%)) ] + +== 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/text/a2.typ b/mysql-php/text/a2.typ index 989f30f..1f3c115 100644 --- a/mysql-php/text/a2.typ +++ b/mysql-php/text/a2.typ @@ -4,7 +4,9 @@ #set par(leading: 0.65em) #assignment(2)[ - Write a PHP script to insert the records in the table in Assignment 1 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 `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. ] #scos(2)[ |