ITECH3224 Web Development: Raccoon Review Project - Assignment 2

This project focuses on web development and design principles, particularly the implementation of a RESTful API for performing CRUD operations. The front-end is designed using HTML and CSS, supported by a MySQL database structured in XML format for DOM tree handling. The project includes features such as sorting raccoons by name and rating, displaying raccoon images and reviews, and allowing users to add their reviews. The XML structure is validated using online tools, and the JSON data is formatted appropriately. The report includes screenshots demonstrating various functionalities and emphasizes the learning benefits of working with RESTful APIs and web services. This resource is available on Desklib, which offers a range of study tools and solved assignments for students.

ITECH3224/ASSIGNMENT 2

P a g e | 1
Contents
Introduction...........................................................................................................................................3
Raccoon review.....................................................................................................................................3
Add_review_detail.php.....................................................................................................................8
XML validation method.....................................................................................................................9
DOM structure.....................................................................................................................................10
Conclusion...........................................................................................................................................11
References...........................................................................................................................................11
List of figures
Figure 1: index page..............................................................................................................................3
Figure 2: sorting method.......................................................................................................................4
Figure 3: sorted name............................................................................................................................4
Figure 4: sorting using ratings................................................................................................................5
Figure 5: raccoon.json...........................................................................................................................5
Figure 6: raccoon.json...........................................................................................................................7
Figure 8: XML validation........................................................................................................................9
Figure 9: json validation.........................................................................................................................9
Figure 10: DOM structure....................................................................................................................10

P a g e | 2
Introduction
This assignment mainly requires a full idea or knowledge about we development & designing. For
this, all the basic concepts should be clear. JSON, XML, web development skills & mysql all the
concepts should be cleared. This assignment is requiring the designing of RESTful API just to
performing some of the very basics functions & for performing CRUD operations. In this assessment,
front-end has been designed with the help of using HTML or CSS. This website is supporting the
back-end technology with Mysql database. Mysql database has been designed in the format of XML.
Because XML is only handled or supported by DOM tree.
Raccoon review
Index.php
This page provides raccoons name, raccoon image and ratings of each raccoon.
Figure 1: index page

P a g e | 3
Sorting methods
 Naming sort: ALL the raccoons are sort according to their names.
 Rating sort: All the raccoons are sorted according to their ratings.
Figure 2: sorting method
Name sorting
Figure 3: sorted name

P a g e | 4
Rating sort
Figure 4: sorting using ratings
Raccoon.json
Figure 5: raccoon.json

P a g e | 5
Raccoon.xml

P a g e | 6
Figure 6: raccoon.json

P a g e | 7
Add_review_detail.php
User can reviews to a particular raccoons.
Figure 7: viewing each raccoon

P a g e | 8
XML validation method
Online XML validation
Figure 7: XML validation
JSON validation method
Figure 8: json validation

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

P a g e | 10
Conclusion
Working of all the RESTful services is quite good. We verify the XML structure on an online tool.
RESTful API’s are producing all the JSON data in appropriate format. Functionalities of all the web
applications are getting performed in a proper way. Even i have attached all the screenshots of all
the different scenarios in this web services. We have designed Data in XML format, because DOM
tree supports this only. This assessment will helpful just for learning all the RESTful APIs. This
assignment will be beneficial for understanding these web services.
References
1. Masne, S. (2018). What is REST – Learn to create timeless RESTful APIs.. [online]
Restfulapi.net. Available at: https://restfulapi.net/ [Accessed 2 Jun. 2018].
2. Valuebound. (2018). An overview of JSON API: A text-based data exchange format |
Valuebound. [online] Available at: https://valuebound.com/resources/blog/overview-of-
json-api [Accessed 2 Jun. 2018].