- Using this database, create a PHP file that requires a username and a password to access the database server. This should beaccomplished with the use of a text field, a password field, and abutton. Then, write PHP code to connect to the database and displayall database data, table by table.
- In the same file, write code to delete a specific student,given his/her name, from a specific class, given the title of thecourse taught in the class
MYSOL Workbench Local instance MySQL80 x File Edit View Arrange Model X EER Diagram x L ocal instance MySQL80 X Database Tools Scripting MySQL Model Help ODO Diagram Modeling Additions Bird’s Eye Zoom: 100% timestamps username, email, passwor.. category tegory_id, name Catalog Tree mydb Tables 2 Views Routine Groups university dass CoID VARCHAR(45) SID INT(11) grade INT(11) course CoD VARCHAR(45) title VARCHAR(45) credits INT(11) Catalog Layers User Types Description Editor No Selection student SID INT(11) name VARCHAR(45) major VARCHAR(45) Description Properties H. Templates Ready Show transcribed image text MYSOL Workbench Local instance MySQL80 x File Edit View Arrange Model X EER Diagram x L ocal instance MySQL80 X Database Tools Scripting MySQL Model Help ODO Diagram Modeling Additions Bird’s Eye Zoom: 100% timestamps username, email, passwor.. category tegory_id, name Catalog Tree mydb Tables 2 Views Routine Groups university dass CoID VARCHAR(45) SID INT(11) grade INT(11) course CoD VARCHAR(45) title VARCHAR(45) credits INT(11) Catalog Layers User Types Description Editor No Selection student SID INT(11) name VARCHAR(45) major VARCHAR(45) Description Properties H. Templates Ready
Expert Answer
Answer to Using this database, create a PHP file that requires a user name and a password to access the database server. This shou…