Client Side Validation And CRUD Operations For Board Games Aficionados Essay.

This task combines your client side mark-up skills (HTML & CSS) and combines it with some server side programming. This being PHP and databases.Consider the Case Study: Board Games Aficionados and the internet in Block 1 then
proceed to answer the following within the context of the case study.For this part we focus on client side validation and form creation. We can assume the database and back-end components are yet to be created. You will however require some information to produce the form, which will be provided as a simple data dictionary.

When designing the form, keep usability and accessibility in mind. These aspects will come into play with the mobile application that’s to be developed as part of Block 3. For the purposes of this task, we will expect the form to have the necessary controls for saving the data with the intention of adding the back-end code later.a. Create an HTML form along with suitable CSS to facilitate storing/retrieving the data described in Table 1 at the end of Task 1.

b. Use JavaScript or the new HTML 5 to perform the client side validation on the form from (a) that will also report any data errors back to the user in a suitable manner these should be detailed messages. Make sure your validators check the data typing and not just length or empty fields.

c. Produce the SQL code (DDL & DML) for the following:
? Create the table players and board_games with the columns and data types from Table 1 and Table 2 at the end of 
? Inserts the data into the table for three players .
? Deletes a row from players and linked board_games based on given criteria. (A member with the ID of 5).
? Retrieves one or more rows from table players and their board_games for a given criterion. (All members who have a Gmail email address).

d. Produce PHP code that accepts the form data from (a), conducts server side data validation and stores (C of CRUD) the data into the database. Simple error messages should be returned to the client/browser in a suitable manner for the user.Validation is important for this question.
e. Produce PHP code that can be used to perform deletes, updates and retrievals (RUD of CRUD) from the table players. This should make use of the HTML form as a template, with the necessary changes, created in (a) above.
f. Create a basic test plan for your form. Test the form and document your test results for all of the CRUD pages.

HTML Form Creation

The board game web application was designed very carefully with proper html and CSS implementation. The CSS was used to make the web application more attractive and eye-catching. The board game web application is made for the community of Puketapu, a town in New Zealand, has a club called Board Games Aficionados. The web application suites their purpose as it provides the basic information related with the events, date and many more. Their previous web application was just a static web page which just show some basic game information and does not provide any modification as well. 

However, the web application is been modified to a certain level where the Create, Read, Update and Delete function were enabled to enhance the functionality and the effectiveness of the web application. The modified web application can be considered as a moderate web application members can easily log-in and check game records as well. The whole interface of the web application was not too glossy as the CSS file is very basic. However, the functionality and usability of the web application is very moderate as it provides easy log-in and easy modification options.

This web application lacks some major utilities comparing to the modern web application. The design of the web application is very poor as it does not provide several layers and sections which are common in the modern web application.

b. Comparison of the Web Application Frameworks

1. WordPress – It is an open-source and online website creation tool, which is mainly coded in PHP. It is one of the most easiest and powerful blogging tool in the recent times. The platform provides enough efficiency for web developers in order to build efficient sites for clients. WordPress is an ideal tool for simple form of websites for blogging and publishing news articles.
2. Joomla – It is an open-source and free form of content management system (CMS) that would be useful for publishing contents on the internet platform. The tool is mainly designed as a form of community platform that has strong features of networking. In terms of comparison, Joomla combines the purpose of flexibility and power, with the retention of the nature of user-friendliness powered by WordPress (Coker & Mukundan, 2013). The platform of Joomla is primarily used for designing websites that would have much level of content and provides a structured form of flexibility such as social networking sites and e-Commerce sites.
3. Codeignitor – It is a PHP development framework that possesses a small footprint. It is very much helpful for developers who would need a basic, simple and a sophisticated toolkit in order to create a fully featured applications based on the web platform (Chang et al., 2015). Codeignitor is also known as an open source software that is helpful in providing a secure framework of development. This is also used for the creation of dynamic websites with the use of PHP.
4. Text pattern – It is a free and open source CMS that is primarily based on MySQL and PHP. The main aim of Text pattern is to become a general purpose CMS that would be suitable for the aim of deployment within many form of contexts. ­­Text pattern and WordPress are two forms of blogging platforms and open source content management systems that are free of cost and are based on the platforms of MySQL and PHP (Sima, Kelly & Hoffman, 2015). Hence, users have the capability to download the latest versions of the CMSs in a straight manner and free from the official websites.

In comparison to the other form of platforms, WordPress would provide much form of flexibility when compared to the other platforms. WordPress provides the ability for customization, creation of plugins, modification of themes and the modification of the core files. Although Joomla provides the feature of customizability, the tool lacks the approach of web and the latest model of themes.

c. Impact of Responsive Web Applications 

The optimization of mobile is becoming free of access in the recent times with the growing use of technology. The responsive form of design of web applications would allow the user to possess a single website that would automatically fit within the screen size of the mobile device during the process of viewing. The responsiveness of the web based applications could be performed by the adaption of the content, navigation, design and the interaction method of deliverance of the same form of comfort (Zheng, Zhang & Ganesh, 2016).

It also provides the purpose of usability for the mobile devices as similar with the desktop users. The responsive form of web design could be defined as the methodology that would recommend the implementation and design of a particular website, which would be able to respond to the behaviour and environment depending on the size of screen, operating system and orientation of the device.

A mobile web application would mainly combine the versatility of the internet applications with the additional functionality of touch enabled devices. Responsive web applications provides a rich look for the website and provides a best feeling for the users. The optimization within the web applications would also provide various form of services such as improved form of video capabilities, offline browsing and improved location based services (Adams & Pinenkov, 2015). As the mobile applications are based on the internet technologies, they are mostly compatible with the latest smartphones for the content view of large form of mobile audiences.

The speed of the computing devices is limited. The limitation within the computing speeds is fundamental. An efficient algorithm within the computing device would be able to perform higher forms of computation within the computer hardware. Further improvements within the computer hardware would be possible with the efficiency within the computing algorithms.  

Reference

Coker, J., & Mukundan, A. (2013). U.S. Patent No. 8,359,335. Washington, DC: U.S. Patent and Trademark Office.

Chang, W., Cheng, J., Allaire, J. J., Xie, Y., & McPherson, J. (2015). Shiny: web application framework for R. R package version 0.11, 1(4), 106.

Sima, C., Kelly, R., & Hoffman, W. M. (2014). U.S. Patent No. 8,656,495. Washington, DC: U.S. Patent and Trademark Office.

Rose, A. S., & Hildebrand, P. W. (2015). NGL Viewer: a web application for molecular visualization. Nucleic acids research, 43(W1), W576-W579.

Zheng, Y., Zhang, X., & Ganesh, V. (2013, August). Z3-str: a z3-based string solver for web application analysis. In Proceedings of the 2013 9th Joint Meeting on Foundations of Software Engineering (pp. 114-124). ACM.

Adams, K., & Pinenkov, V. (2015). U.S. Patent No. 8,949,988. Washington, DC: U.S. Patent and Trademark Office.