Answered step by step
Verified Expert Solution
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 tmasaverow.php to add the data from the booking reference field to the database.
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 tmasaverow.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 : Data to add to database
First name Last name Email Booking reference
Zinolla Zanda zzanda@zinc.acuk ONL
Zeua Avrenim zeua.avrenim@zmail.acuk EGH
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 tablemanager.php
Table : Database table display
firstname lastname email
Zinolla Zanda zzanda@zinc.acuk
Zeua Avrenim zeua.avrenim@zmail.acuk
Table 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 ShowHide: Data from database table to produce the screenshot if required.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started