Question 4- PHP (20 Marks) The scenario given below shows how a user can write comments and give ratings on the hotels that they have stayed in. Table: Hotel Hotel ID Hotel Name Hotel Star H1 Hotel Continental Pena H2 H3 Royal Hotel H4 Hotel Central Seaview unway Hotel Georgetown Table : Feedback Feedback ID Feedback Date Feedback Customer Feedback Rati Feedback Comment 2017-05-16 2017-07-11 James 2017-10-30 Mary Anne 2017-10-30 2017-10-30 ite good for the OK...but the toilet Wasted my money Fantastic! Value for money Hotel ID H2 H2 H4 H2 H4 was sme hotel is bad! (a) Write the PHP codes for the view.php page which displays the records as shown [13 marks] below. The data is retrieved from both tables. If no records are found for the particular hotel, display "No Comment or Ratings Found". The hyperlink links to the give_comment.php page that brings along the Hotel ID. Calculate the average rating based on the rating given by the user. Hotel Star Aveage Rating Hotel Nane Commeats aud Rnllogs Give Feedback Hotel Coatinental Penang Sunway Hotel Georgetown2017-07-11James-OK..but the toilet was smelly. -3.0 Royol Hotel Hotel Ceutral Seaview 12017-10.30 ..Ahnad..Thishotel isbad-20 Comient or Ratings Foand 017-05-16-Ali-Quite good for the price.-3.0 017-10.30-Cothy-Fantnstie! Vahue for money. ive Conments and Raring 0.0 ie Comments and Reting 1.5 Gve Comments and Rating .7 S.0 4No Comnuent or Ratings Found 017-10-30-Mary Anne- Wasted my mouey-1.0 Feedback_Date, Feedback_Customer, Feedback Comment and Feedback Rating (b) Based on question (a), write the codes for the give_comment.php page. [7 marks] The page should display the hotel that is currently selected to be given comments and rating. (This is identified from the view.php page.) A form is provided which uses the post method. The form elements are named as feedback_customer, feedback_comment and feedback_rating. The button name is sendbtn. Insert the user's data into the feedback table and redirect the user to the view.php page to see the changes. . Hotel Star Arerage Ratiog Hotel Name Comments and Ratings Gire Feedback No Comment or Ratings Foand 017-05-16-Ali-Quite good for the price.-3.0 017-10-30Calby-Faotastiet Value for money.- 5.0 Hotel Coatinental Penang Sunway Hotel Georgetown 4 2017-07-11James. OK but the toilet was smelly. 3.0 3.7 Royal Hotel 18-02-02-Bery White We had a wonderfal stay!400 Hotel Ceatral Seaview 017-10-30-Mary AnneWasted my money-10 Give Comments and Rating 2017-10-30.Ahmad- This hotel is bad!-20 1.5 End of Page
