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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!