iii.Store $$booking reference$$ in the database

Modify tma$02\_$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 tma$02\_$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.