Question

Create a list of several elements you think should make up a login page. Make sure to obtain instructor approval for the elements of your login page. Consider the execution flow to capture the user interaction.

Execute this assignment according to the following guidelines:
1.In MySQL, build the necessary tables to store the information required during the log in process.

2.In PHP, write the functions that will enable the capturing of user input and store in the database.

3.In HTML, build the functional login form to capture user login.

4.In PHP, perform the necessary user authentication. Before you code, document every detail of the user experience such as: number of login trials allowed, constraints on the password, etc.

5.Based on the desired interaction and data captured, build the MySQL tables to store this information and enable the desired functionality.

6.Connect the Registration and Login pages.

7.Document any revisions that might be necessary to code, schema, tables, or user interface created in the previous module.

Answer 1

gsal cae for devigning tabley during regitation to Stoye the infymation CREATE TABLE TF NOT EXISTS 'student-details C'sno int Clo) AoT NUL fixst name' vanchar Cro) NOT NULL last name varchr 2) noTNULL gender varchar 40) NOT NULL dob Vacha) NOT NULL email varchan (30) NOT NULL, Ph one Vach (13) wOT NULL addxs Varcharo0)NOT NULL / Year varchar (20) NOT NULL 'fav-wt varchar (20) T NULL Varchar Cio) NOT NULL 'Pav- cc' Varchar Cto) NOT NULL fav-oops' Varchar C10) NOT NULL usey name' varchar Cao) NoT NULL, Paso secqves varchar C4) NoT NULL varch ar CRo NOT NULL sec ans Varchar Cloo) NOT NULL

PY ffe NOLL) Varchah (200) NOT ENAINE- Ino DB DEFAULT CHARSET-akin 1 Inderes foy dumped tables Indexey Po tabk'student -detail ALTER TABLE Student-details ADD PRIMARY KEYC'Sno); for damped bables AUTO-TNCREMENT ftabk Student dekails AVTO TNCREMENT ALTER TABLE 'student details MODI FY Sno' int Clo) NOT NULL AUTO -TNCREMENT; a PHP Code fos Cap Rturing of usey input and Stoye in the data base, 22 Php indude "Ablontig php'; s fist name- $lest POST C"f name"]; name = $- POSTC" fmame"); $gender$POST Cden"J $ dob email PoST [ 'email --POST "phme' address $PosTCadd ve $- PoST [dob Phone

SoddrePoSTCaddves ear-PoST "Yea J Rv.t-PoST 7"; fav cn--POST Cc fav- ca-PasTC "Cc"J far-oops - PosT Co0 PS"J; Susex-htmlenti ties Cmyszyeal- escape-*ringC$-PoST r uname $pahtmlentities(myse k _3ead-es%ape_- GringCPosTCuI) secqves- P0ST["seCuxity " $- POSTC"sansuwe" mame-. FI ES['PaDAe' ] [* $temp name- . FJLES CPofi Se"JC' tmp-name' name sAkext Rathinhf$nmme, PATHINFO_ EXTENSION); / $ext-SttappenC$ h'eext.)" $extP Joationi ploads Gf Cmove uploaded-Ak(ttemp nameslocatom.tname)) auou stl"TNSERT NTO Student- detaik (ytname, Jast name, ganden, doby email, Phone, addrey year Pav- ooPS, Us name, pawšd, fav- wt, fav-CN, fav cc sec- ves, Sec-ans, piofk

genden'dob' email' Values C's Artname', "$ last name phone $addrey', '$ add rer as', favwt fov- cn, Pavc5$ fav-0oPs',usey',$ Pa seques $sanswer', ' myst9.vey C name elsx echoscript' echo "Unsup pated Fie echo /scsipb'; echoscaipt winda hcdion-ogin php' c/sci pt" out put yegiytation

- REGISTRATION FORM First name Last name Male Female Gender dd/mm/yyyy DOB: Email Phone No Address here..... .! Address: Year: Select Fav Subjects: WT CN CC OOPS User name Password Confirm Password Security Question Select Security Answer...!! Security Answer: Profile Pic: Choose file No file chosen Reset Register Already have account...??