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.
Table 2: Database table display
firstname lastname email
Zinolla Zanda z.zanda@zinc.ac.uk
Zeua Avrenim zeua.avrenim@zmail.ac.uk
Table 2 shows the data table which should now be displayed. Notice that the new booking reference column is not currently shown.
In your solution document, provide your code and a screenshot of the web page showing the new table containing entries with the fields completed. You can use the Show/Hide: Data from database table to produce the screenshot if required.

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

Data And Information Quality Dimensions, Principles And Techniques

Authors: Carlo Batini, Monica Scannapieco

1st Edition

3319241060, 9783319241067

More Books

Students also viewed these Databases questions

Question

Define organization development (OD)

Answered: 1 week ago