Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

iii.Store booking reference in the database Modify tma 0 2 _ save - row.php to add the data from the booking reference field to the

iii.Store booking reference in the database
Modify tma02_save-row.php to add the data from the booking reference field to the database.
(8 marks)
Look carefully at how the other data elements are added to the database and reflect that for the booking reference field.
Note carefully that tma02_save-row.php handles two distinct situations: one when the record has been edited and the other when the record is new. Here, we are only considering a new record and you need to update only that part, leaving the other unchanged.
Add the following two entries:
Table 1: Data to add to database
First name Last name Email Booking reference
Zinolla Zanda z.zanda@zinc.ac.uk ONL/135791
Zeua Avrenim zeua.avrenim@zmail.ac.uk EGH/246810
If you have created any other records when testing, they should be removed prior to adding the two entries above. The quickest way to clear the test data is to drop and recreate the table using table-manager.php.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Learning PostgreSQL

Authors: Salahaldin Juba, Achim Vannahme, Andrey Volkov

1st Edition

178398919X, 9781783989195

More Books

Students also viewed these Databases questions

Question

What is the Definition for Third Normal Form?

Answered: 1 week ago

Question

Provide two examples of a One-To-Many relationship.

Answered: 1 week ago