Kartoday E-commerce Website: Design, Implementation, and Testing

Desklib provides past papers and solved assignments for students. This project details e-commerce website development.

Contents
List of figures:............................................................................................................................2
Introduction:...............................................................................................................................3
1. Critically evaluate the functions and advantage of the web application............................4
2. Critically compare different types of server-side and client-side scripting languages......5
3. Examine the web security concern and make a recommendation for the security
improvements.........................................................................................................................6
LO2- Be able to design web applications..................................................................................7
2.1 Design a web application to meet a given requirement...................................................7
2.2 Synthesise client-side and server-side functionality in a web application.....................11
2.3 Apply a database design for use in a web application...................................................12
2.4 Evaluate alternative designs and solutions to meet a give requirement.........................17
LO3 Be able to implement the web application.......................................................................18
3.1 Implement a web application to a prepared design using client side and server side
scripting languages...............................................................................................................18
Explanation of source code:.................................................................................................29
3.2 implement a web-enabled database management system to store, retrieve and
manipulate data in a web application...................................................................................31
3.3 Identify and implement opportunities for error handling and reporting........................40
LO4 Be able to test web applications.......................................................................................41
4.1 Critically review and test a web application using a web-enabled database management
system...................................................................................................................................41
4.2 Analyze actual test results against expected results to identify discrepancies...............43
4.3 Critically evaluate independent feedback on a developed web application and make
recommendations for improvements....................................................................................46
4.4 Create user documentation for a developed web application.........................................47
Conclusion-..............................................................................................................................56
References-...............................................................................................................................57
Appendix-.................................................................................................................................58

List of figures:
Figure 1: website home page......................................................................................................8
Figure 2: website validation page..............................................................................................8
Figure 3: website signup page....................................................................................................9
Figure 4: product description.....................................................................................................9
Figure 5: ER Diagram..............................................................................................................12
Figure 13: home page...............................................................................................................14
Figure 14: signup page.............................................................................................................15
Figure 15: seller page...............................................................................................................16
Figure 16: products category page...........................................................................................17
Figure 17: product page before login.......................................................................................18
Figure 18: item available page.................................................................................................19
Figure 19: price description page.............................................................................................20
Figure 20: purchased products.................................................................................................21
Figure 21: shopping cart page..................................................................................................22
Figure 22: order placed............................................................................................................23
Figure 23: forgot password page..............................................................................................24
Figure 24: seller table...............................................................................................................28
Figure 25: archival table...........................................................................................................29
Figure 26: asset table................................................................................................................30
Figure 27: comment table.........................................................................................................31
Figure 28: storage table............................................................................................................32
Figure 29: item category table..................................................................................................33
Figure 30: information table.....................................................................................................34
Figure 31: products table..........................................................................................................35

Introduction:
The web application is helpful to spread the business globally through the internet. These
web applications can be on any topic. This assignment aims to develop web site design and
implementation skills using server-side and client-side technologies. The main focus of the
unit and assignment is to use a server-side scripting language to build a sophisticated website.
This also enables to test the website.
This assignment has 4 parts which include understanding the development of web
application, designing of the website using various technologies and implement the website
and finally testing of the website.

LO1- understanding the concept of web application development
1. Critically evaluate the functions and advantage of the web application.
The web application is the software program which logically interacts with the functions to
fulfill the need of the particular business and store them in the remote server which can
access from the web browser in the client system. The web application is developed with the
various combination of languages such as JavaScript, HTML, CSS, and PHP etc. There is a
various example of web application such as www.amazon.com, www.google.com etc.
The web application provide various platform and scope for the application to run such we
can implement payment using the SSL integration, implement form validation etc. also in one
single application we can access various application such as Google provide us access to the
Gmail and from Gmail we can access our Google drive or hangout or any other required
application according to our choices or need.
The web application is made simple so that any user can easily use it either for their business
purpose or for searching purpose. The web application can be easily accessed by the internet
by anyone having the basic knowledge of the web development.
To provide security to the web application various security measures are applied such as anti-
virus for scanning the software on the web server. Using the firewall for blocking the harmful
source from accessing the web server. Nowadays developing the web application has become
more simple and easy as various templates are available or by using the word press we can
easily develop our own website.
Functions of a web application:
The web application development implementation is having different functions that are very
useful and most important in the application development of web based application.
 Implementation of scripting language.
 Web based application support server and client side scripting language.
 Web based application supports user interface compatibility.
 Web application includes data integration and data implementation process also.
 In the implementation of web application the web based application support database
connectivity of several platforms.
 The process of integration is very fast in web based application.
Advantages of a web based application:
There are several advantages available of a web application. Some of main advantages are
given below:
 Web application have the capability of multiple browser compatibility process.
 Web application supports different platform supportability also.
 The web based application is having the functionality of easy management also.
 There are one of the biggest advantages available which is data security.
 Web based application took less time to execute than other platform developed
application.
 The cost of web based application is less than other application.

2. Critically compare different types of server-side and client-side scripting
languages.
Client-Side Scripting language Server-Side Scripting language
It is used for developing the web page more
interactive.
It uses various languages for developing the
website by itself. The PHP is the server-side
scripting language which uses CMS
(Content Management System) for proving
the different structures of the web
application.
It is said to be the scripting language which
runs on the client browser.
It is said to be the scripting language which
runs on the web server.
The client sends a request to the web
server from the user side for accessing
the web application for e.g.
www.splunk.com
Its work is to acknowledge the request
which has been sent by the user so that it
can provide the client with response in
terms of metadata such as source and header
of the requested web application.
It does not interact with the storage which is
permanent. Only the cookies and local
storage are interacted by the client side
scripting.
It interacts with the storage which is
permanent such as a database which is
connected to the web application for storing
the data.
The example of the client-side scripting
languages is CSS, HTML, and JavaScript.
The example of the server-side scripting
language is PHP, ASP.NET, Ruby etc.
Server-Side Scripting:
JSP:
JSP is a type of server side scripting language. JSP is known as Java server page. JSP used to
create and develop dynamically generated web pages. That dynamic web pages usually based
on the HTML, XML or many web development technology.
PHP:
In the implementation of web based application the user of server side scripting is most
important server side language. Most of web application use PHP for server side scripting
language.
ASP:
This is also a type of server side scripting language and this server side scripting language is
similar to HTML.
Client-Side Scripting:
JQuery:
In the development of web application development JQuery is known as client side scripting
language. The JQuery is a sort of JavaScript Library. Each and every library can be
implemented in this scripting language.

JavaScript:
JavaScript is a type of dynamic computer programming language. This is the most important
section of the web application development process and implementation. JavaScript server
side scripting language linked with
VBScript:
In the application development of client side scripting language and known as interpreted
language also. This language support visual basic platform compatibility.

3. Examine the web security concern and make a recommendation for the
security improvements.
As in today’s world internet has become the most important medium for doing business and
information sharing. So to protect our application secure and free from vulnerabilities need to
perform various program to protect the application from the hackers in the following ways:
 Form validation- by applying the form validation we can safeguard the user's details ant
the application as well. The form validation can be applied on both server-side scripting
as well as the client-side scripting.
 SQL injection- sometimes if our website is not protected then by performing the SQL
injection on the website the hacker can take access to our database. Therefore to prevent
from the SQL injection the website must be implemented on the secure HTTPS server.
And also need to inject the escape character such as ‘/= or 1=1’.
 Protecting the session information- Always need to store the sensitive data like password
and credit card details always written in the temporary files by encrypting the data and
storing it in the session file.
 Antivirus Update- by updating the anti-virus continuously time-to-time for safeguarding
the web application.
 Securing the File uploaded- for securing the file which will be installed in the website
must need to disable the malicious script so that complete website will be executed on the
server.

LO2- Be able to design web applications.
2.1 Design a web application to meet a given requirement.
Figure 1: website home page
Figure 2: website validation page

Figure 3: website signup page
Figure 4: product description

2.2 Synthesise client-side and server-side functionality in a web application.
List of the programming languages used on both client-side and server-side scripting are:
JavaScript- the JavaScript is the dynamic high-level language which is used as the core
technology while the production of the content on the World Wide Web. It supports all the
web browser without using any plugins facility.
PHP- PHP is the server-side scripting language which makes action on the server while
website development. The PHP code is also embedded with the HTML code with a various
variety of the website templates. The PHP is used for implementing the dynamic and static
website and also the web application.
The communication from client-side to server-side-
The user input the data or the information on the web application and then the scripting
language such as PHP will store all the data on the web server so that it can be accessed
again. Now the PHP will provide the content such as the image of the product, the price of
the product and the details about the product which has been shown in the image provided of
the website. Whenever the user will send the request for searching the data the PHP script
will fetch the same data from the web server which has the database named “kartodaydb”.
The database also contains the signup and login users details so that whenever they log in
again they don’t need to give their details again the web server will fetch the data from the
database table.

2.3 Apply a database design for use in a web application
The database for the website is developed using MySQL and to run this database XAMPP
server is used. The database name for the website is “kartodaydb”. This has various tables
such as admin, Asset_archive, Comment, fav, orders, order_details, purchases, user_details
and so on.
The below screenshot is for seller table. This stores the seller information. These tables
include 11 columns which are Seller Id, fname, mname, Lname, Birthday, Address, City,
Contact_number, Gender, Email, and Password.
Figure 5: ER Diagram