diff options
Diffstat (limited to 'mysql-php/index.typ')
-rw-r--r-- | mysql-php/index.typ | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-php/index.typ b/mysql-php/index.typ index 21fe3bc..d76875a 100644 --- a/mysql-php/index.typ +++ b/mysql-php/index.typ @@ -11,10 +11,10 @@ #set raw(lang: "php") -+ 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`. ++ Create a table `Student` containing the fields `name`, `roll`, `city`, `email` and `date_of_birth`. Then, + - Create a form to insert records into this table (and insert at least 5 of them), + - Display all of the records, + - Display records of those students who were born in between `01/01/2000` to `31/12/2005`, and - 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. |