Question: 2. a. Write down the source code of the HTML page below. b. When the Save/Update button is clicked, the information has to be submitted

2. a. Write down the source code of the HTML page below. b. When the "Save/Update" button is clicked, the information has to be submitted to a PHP file named "z.php". In z.php either a new record has to be added to the database table named "registration" or a record has to be updated depending on the "studentno" field. The operation handled must be displayed (using echo) with two messages: "Record Added" or "Record Updated". Restriction: For queries, prepared statements with parameters must be used. Student Registration HTML Table Student No: Name: Text controls Surname: Age: Save/Update Type=number control Computer Protected M 100% MYSQL Database Server Address: sct.emu.edu.tr Database Name: DBNM Username: USRX Password: PX Table Name: registration Additional Field Name Field Type Field Size Information Explanation studentno varchar Primary key / not null Represents students' number Name varchar 20 not null Represents students' name varchar 20 not null Represents students' surname Age varchar 3 not null Represents students' age 8 surname
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
