Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i . Create a database table Modify table - manager.php to create a new table in your database. ( 3 marks ) So far the
iCreate a database table
Modify tablemanager.php to create a new table in your database.
marks
So far the code has used an existing database table called ttguests, but that has no provision for a booking reference field. You will now create a new table in your database.
Examine the file tablemanager.php
Notice the variable $databasetable which must be set to the name of your new table required. You will create a table called ttoucuWhere 'oucu' is replaced with your own OUCU
Your new table will contain all the columns which exist in ttguests, with the addition of the new booking reference column. Base your answer closely on the existing SQL statement.
The booking reference field may contain up to characters.
Modify the SQL statement in the $createsql variable to meet these requirements. Remember that column names cannot contain spaces, so you must choose a suitable name. Once you are happy with your SQL open tablemanager.php on the TT server and click the create button to execute the SQL to create the table.
Once a table is created it cannot be modified, so if you create a table with the incorrect structure, you must delete it before you can create a corrected version. This can be done using the drop button when executing tablemanager.php
In your solution document, provide your code and a screenshot of your browser displaying the result of executing tablemanager.php
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