ITECH3224 Project: Raccoon Review - RESTful API & Web Application

This project involves the development of a Raccoon Review web application utilizing RESTful APIs and a MySQL database. The application allows users to view, sort, and add reviews for raccoons. The project includes the design of a front-end using HTML/CSS and a back-end with MySQL, with data formatted in XML. XML data is supported by a DOM tree. The application features sorting functionality based on raccoon names and ratings. Individual raccoon pages allow users to add new reviews, which are then updated in the background. The project also includes validation of XML and JSON data using online tools and POSTMAN. The assignment demonstrates the creation of RESTful APIs and the integration of various web development technologies. The student successfully implemented all the required functionalities and verified the data structures using appropriate validation techniques. This project highlights the learning process in designing RESTful APIs and building web applications.

ITECH3224/ASSIGNMENT 2

P a g e | 1
Contents
Introduction...........................................................................................................................................3
Raccoon review.....................................................................................................................................3
Raccoons get sorted according to their names..................................................................................4
Raccoons get sorted according to their ratings given........................................................................5
single.php..........................................................................................................................................7
Validation of xml data........................................................................................................................8
DOM structure.......................................................................................................................................9
Conclusion.............................................................................................................................................9
References.............................................................................................................................................9
List of figures
Figure 1: Home page.............................................................................................................................3
Figure 2: Name sorting..........................................................................................................................4
Figure 3: json data.................................................................................................................................5
Figure 4: XML data.................................................................................................................................6
Figure 5: viewing each raccoon.............................................................................................................7
Figure 6: XML validation........................................................................................................................8
Figure 7: json validation.........................................................................................................................8
Figure 8: DOM structure........................................................................................................................9

P a g e | 2
Introduction
This assignment requires a good knowledge of web development with a good hold on some basic
concepts of XML, JSON, Mysql, and webs development skills. This assessment requires the designing
of RESTful API to perform some of the very basic functionality and to perform CRUD operations. I
have designed Front-end using HTML/CSS. The website has a backend support with MySQL
database. I have designed the MySQL data into XML format. XML formatted data is supported by the
DOM tree (Li, L., & Chou, 2011).
Raccoon review
Index.php
This shows the list of all the raccoons available in the system. All the details of the raccoons are
visible. The listings can be sorted based on the two filters either name sorting or another one is
rating based sorting.
Figure 1: Homepage

P a g e | 3
Name sorting
Raccoons get sorted according to their names.
Figure 2: Name sorting

P a g e | 4
Rating sort
Raccoons get sorted according to their ratings given.
Raccoon_data.json
Figure 3: json data

P a g e | 5
Raccoon_data.xml
The SQL data is viewed in xml format using restful API.
Figure 4: XML data

P a g e | 6
single.php
This page produces individual raccoons separately. The user can add new reviews to particular raccoons. The
list will be updated in the background.
Figure 5: viewing each raccoon

P a g e | 7
Validation of xml data
I made use of online tools to validate XML data.
Figure 6: XML validation
Verification of JSON data
This verification is done by using POSTMAN service. I made use of online JSON validator to check the
JSON format.
Figure 7: JSON validation

P a g e | 8
DOM structure
Figure 8: DOM structure

P a g e | 9
Conclusion
All the RESTful services are working quite well. The XML structured data is verified using an online
tool. These API’s are producing JSON data in a correct format (Crockford & D., 2006). All the
functionalities of the web applications are executing in an expected way. I have provided the
screenshots of various scenarios in this web service. I have designed DOM tree which supports my
XML formatted data in a complementary way. This assignment helped in learning of designing
RESTful API’s. This assessment will prove to be beneficial for my further studies.

P a g e | 10
References
 Li, L. and Chou, W., 2011, July. Design and describe REST API without violating REST: A Petri
net based approach. In Web Services (ICWS), 2011 IEEE International Conference on(pp. 508-
515). IEEE.
 Crockford, D., 2006. The application/JSON media type for javascript object notation (JSON).