Raccoon Review Website: RESTful API Design and Implementation

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).