ONLINE QUIZ TEST-3

A
MAJOR PROJECT
ON
ONLINE QUIZ TEST
This is submitted in partial fulfillment of the requirement for the degree
of
MASTER IN COMPUTER APPLICATION
by
Name: STITI ROUT
Regd. No.: 2105274109
UNDER THE GUIDANCE OF:

PROF. SUBASHIS MOHAPATRA
DEPARTMENT OF MASTER IN COMPUTER

APPLICATION
UNITED SCHOOL OF BUSINESS MANAGEMENT,
BHUBANESWAR
Master in Computer Application
UNITED SCHOOL OF BUSINESS MANAGEMENT
Bonafide certificate
This is to certify that the project report entitled “ONLINE QUIZ Website”
submitted by STITI ROUT (2105274109) to UNITED SCHOOL OF
BUSINESS MANAGEMENT, Bhubaneswar in partial fulfillment of the
requirement for the award of the degree of “MASTER IN COMPUTER
APPLICATION” is a record of Bonafede work carried out by him under the
guidance of PROF.SUBASHIS MOHAPATRA. The project fulfills the
requirements as per the regulations of this University. The contents of this
report have not been submitted and will not be submitted either in part or in full,
for the award of any other degree / diploma and the same is certified.
Head of the Department Principal
Internal Examiner External Examiner

Declaration
I hereby declare that the project report entitled “submitted by me to UNITED

SCHOOL OF BUSINESS MANAGEMENT”,BHUBANESWAR in partial
fulfillment of the requirement for the award of the degree of “MASTER IN
COMPUTER APPLICATION” is a record of Bonafede project work carried out by
me under the guidance of SUBASHIS MOHAPATRA. I further declare that the work in
this project has not been submitted and will not be submitted, either in part or in full, for
the award of any other degree / diploma in this or any other Institute / University.
Place: Bhubaneswar Signature of the Candidate

Date: 05/08/2023 Name : STITI ROUT
Regn. No: 2105274109
Acknowledgement
I am really indebted to United School Of Business Management, Bhubaneswar for
providing me an opportunity to undertake this project work as partial fulfillment of the
Master’s Degree in Computer Application (MCA) curriculum.
I would like to express my heartiest gratitude to Eswar Reddy, UNITED SCHOOL OF
BUSINESS MANAGEMENT, and all the faculties of the MCA Department for their
encouraging support and guidance in carrying out this project.
I would like to express my heartiest gratitude to Subashis Mohapatra for his / her
encouraging support and guidance in carrying out this project.
I express my sincere thanks to United School Of Business Management for permitting
me to take this project work and for their instance of the good programming technique,
which helped us to design and develop a successful Online Quiz Test website
Finally, my sincere thanks to my project members my friends, mentor and all well-
wishers for their esteemed guidance, support, valuable suggestions, and constructive
criticism.
With sincere regards,

STITI ROUT
2105274109
MCA 4th Semester
CONTENTS
Page no.
1. Introduction
Introduction.................................................................7
Objective of the Project...............................................8
2. System Study
Existing System…………………………………...…10
Proposed System………………………………….…10
3. Requirement gathering & Analysis

Functional Requirements…………………………....11
Non Functional Requirements………...………….…11
4. Details of Hardware & Software used

Software used…………..……………………….….12
Hardware used.…….…………………………...…..12
5. System Design
Design Consideration………………………………14
Data Flow Diagram(DFD).…………………………16
Entity Relationship(ER) Diagram……...…….……..19
Class Diagram……………………………………....20
Sequence Diagram……………………………..……21
6. Implementation
HTML……………………………………………….23
CSS………………….……………………………....24
Java Script…………………………………………...25
PHP………………………………………………….26
My SQL …………….………………………………27
7. Module Specification………………………………………27
8. Methods used for Testing

Unit Testing…………………………………………33
Integration Testing………..….…………………...…35
Test Reports…………………………………………36
9. Source Code……………………………………………….37
10. Snapshots……………………………………………….….37
11. Conclusion………………………………………………....47
12. Future Scope……………………………………………....48

ABSTRACT
INTRODUCTION
OBJECTIVE OF THE PROJECT
At the current stage, with the corona virus pandemic going around, more and more students prefers to
study on the online learning management systems. So the main objective of the platform is to provide
various types of resources to different kinds of students/teachers /working person over the globe who
can need offend physical classes. The courses are free for all users.
E-Learning is a learning process with the combination of content that is both delivered digitally
and through face-to-face learning. eLearning contributes to the shifts from traditional face-to-face
learning to the use of web technological tools which enhances collaborative learning and presents
an entirely new learning platform for students. eLearning has also been the principal form of
distance education but now, it is also changing the instructions on higher education as it is now
becoming a global agent in higher education. Advancements in technology learning have
contributed to the enhancements of generations of face-to-face learning and generations of
distance education. As to it, when E-Learning develops, it has begun to use different approaches
to address diverse goals.
A flexible web-based learning experience allows you to go through a guided curriculum or choose
lessons on an as-needed basis. Following are the main objectives:-
 Ability to recall previously learned material – Students/learners can watch video courses as
many times as they need. If they forgot something during the course they can come back and
watch that specific part anytime.
 Free Cost – As nobody needs to travel or pay anything as it’s cost is free.
 Learn anytime from anywhere – Students/Learners can start learning anytime from anywhere
they just required internet connection with a compatible device.
 Improve course quality according to learner’s feedback – Tutor can improve their course as per
student’s feedback. It will help tutor to improve their ability to teach.
System Study
Traditional System:
Existing system is a manual one in which users are maintaining books to store the
information like Student Details, Instructor Details, Schedule Details and feedbacks
about students who attend classes as per schedule. It is very difficult to maintain
historical data.
Disadvantages:
The following drawbacks of existing system emphasize the need for computerization:
1. a lot of copies of study material have to be made.

2. a lot of internet work hence delay in giving the sufficient times to students.
3. a lot of tabulation work for each subject scheduling.
Proposed System:
 This application is used to conduct online classes.

 The students can sit at their houses and login to these website and start learning.
 The study material and videos have to be given to the students, they will appear
the examination so that they can test their efficiency by appearing exams.
 This application allows the administrator to add course, add, subject, add manage
videos and add questions.
 This application provides blogs, where a student can read those blogs for free.
REQUIREMENT GATHERING AND ANALYSIS
It may help collecting perfect management in details. In a very short time, the
collection will be obvious, simple and sensible. It will help a person to know the
management of passed year perfectly and vividly. It also helps in current all works
relative to E-learning Management System. It will be also reduced the cost of
collecting the management & collection procedure will go on smoothly.
Functional Requirements:
This application consisting of following modules.
1. Admin
2. Student
1. Admin Module: The administrator is the super user of this application. Only
admin have access into this admin page. Admin has all the information about all
the users (student) and about all course, videos, questions and exams.
2. Student Module: The student must be registered by the Administrator. A student

can login in this application, enter the token given by the Admin, learn courses and
test efficiency.
Non-functional Requirements:
Non-functional requirements are those requirements that don’t define the actual
working of the system. Non-functional requirements are used to judge the quality of
the system. Nonfunctional requirements cover all the remaining requirements which
are not covered by the functional requirements. They specify criteria that judge the
operation of a system, rather than specific behaviors.
Non-functional requirements in our project are:
1. Usability: Usability is a quality attribute used to access how easy the interface is to
use. Usability is ease of use. It tells how user friendly the interface is. It includes
memorability, learn ability, and satisfaction. Our software interface has all the above
quality. Any kind of user can easily understand the interface.
2. Integrity: Integrity means doing the right thing in a reliable way. Data integrity is a
fundamental component of security. In its broadcast use, “Data Integrity” refers to
the accuracy and consistency of data stored in a database, data mart or another
construct. Data integrity is the overall completeness, accuracy and consistency of
data.
3. Security: Security is how much the system is secured in different platforms. Only
Admin can create a specific password for different user which is used for candidate
for login. For appearing an examination, lecture can create specific token for each
student. Then tokens are used by the student to access the examination.
4. Performance: Performance is also a major non-functional requirement. Performance

Requirements about resources required, response time, transaction rate or anything
else having to do with performance.
Details of Hardware & Software used
Software Development Environment:
 Operating System: Windows 11
 Technology: PHP
 Web technologies: HTML, CSS, JavaScript
 IDE: Visual Studio Code
 Database: MySQL
 Web Server: Apache
Hardware Requirements:
 Processor: Intel Core i3
 RAM: 4 GB
System Design
Design Consideration:
Phases of Iterative waterfall model:
 Requirement gathering and analysis: All possible requirements of the system to be
developed are captured in this phase and documented in a requirement specification
doc .
 System design: The requirement specifications from first phase are studied in this
phase and system design is prepared. System Design helps in specifying hardware and
system requirements and also helps in defining overall system architecture.
 Implementation: With inputs from system design, the system is first developed in
small programs called units, which are integrated in the next phase. Each unit is
developed and tested for its functionality which is referred to as Unit Testing.
 Integration and testing: All the units developed in the implementation phase are
integrated into a system after testing of each unit. Post integration the entire system is
tested for any faults and failures.
 Deployment of system: Once the functional and non-functional testing is done, the
product is deployed in the customer environment or released into the market.
 Maintenance: There are some issues which come up in the client environment. To fix
those issues patches are released. Also, to enhance the product some better versions are
released. Maintenance is done to deliver these changes in the customer environment.
All these phases are cascaded to each other in which progress is seen as flowing steadily
downwards (like a waterfall) through the phases. The next phase is started only after the
defined set of goals are achieved for previous phase and it is signed off, so the name
"Waterfall Model". In this model phases do not overlap.
Reason for choosing Iterative Waterfall model:
The iterative waterfall model allows for departmentalization and control. A schedule
can be set with deadlines for each stage of development and a product can proceed
through the development process model phases one by one.
Development moves from concept, through design, implementation, testing, and end
up at operation and maintenance. Each phase of development proceeds in strict order.
Some other reasons for choosing the model are:
 Requirements are very well documented, clear and fixed.
 Product definition is stable.
 Technology is understood and is not dynamic.
 There are no ambiguous requirements.
 Ample resources with required expertise are available to support the product.
Data Flow Diagram:
Data flow diagram depicts the way data is processed by a system, the inputs and outputs with
a special focus on the information flow and storage.
Level – 0 DFD:
Level - 0 DFD is also known as context diagram. Its shows an abstract view of main
processes included in E-LEARNING WEBSITE.
Log in
Add Courses
Admin
Videos
Log out
E-Learning
Management
System
Log in
User id & pass Student

Log out
[ DATA FLOW DIAGRAM LEVEL 0 ]

Level – 1 DFD:
Level 1 DFD enumerates all of the major sub processes that comprise the entire system. It
also identifies the data store of the student record, which contains all of the student’s data,
which contains several master data used throughout the system, such as class data, videos
data, question data etc.
User Record
R/W
User login & Permission User User Info

User_id & password
Access Registration
management
New Subjects
and Topics
Skill Test
Watch Lectures
R/W
Learning
programming
Tutorials Pre Defined Data
Master data Exercise
Watch lectures
& videos

Level – 2 DFD:
DFD Level 2 should present the system specific components, database and flow of data
between the processes and actors of the Online Examination Management. Since the
DFD level 2 is the highest abstraction level, Online Examination Management System
processes must be detailed that is continuation of the DFD level 1.
Master data
R/W
Manage Courses &

Videos Record
User id & pass
Admin Login Add/Updated &
Delete R/W
Video &lecture.
Add Videos
Question Add/Update & Entry
Delete Course
Add id for Questions

Question
Entry
Courses
Entry
R/W
Master data

Entity Relationship Diagram:
Admin
Student Manage
Result Checks Answer
[ Entity Relationship Diagram

Of
Admin & User ]
Class diagram:
The Class diagram for E-LEARNING WEBSITE (E-Learning Management System) shows the
structures of information or data that will be handled in the system. These data or information will
be represented by classes.The arrows on them represents their relationships in each other.
Login
Class
- id: int
- username: string
- Course
password: string
Qus_id
+ add()
+ update()
Video Option-1
Option-2
Questions
User Skill Test Admin
Option-3
- username: string - username: string

Option-4
- password: string
- password: string
+ verify() Stores
+ add_user()
+ viewfile() + delete_user()
+ upload_file()
+ delete_file()
Topic File
- subject: string - subject:string

Student_id Subject_id Course_id Correct_ans
+ view_doc() Mark secured + upload_doc()

Subject_id Qus_id
+ view_video() + upload_video()
+ view_question() + upload_question()
[ Class diagram ]
Sequence Diagram:
User Sequence Diagram-

Admin Sequence Diagram-
The designed sequence diagram illustrates the series of events that occurs in E-LEARNING
WEBSITE (E-Learning Management System). In this illustration, the actors are represented by a
stick man and the classes are represented by objects. It will give you clear explanation about the
behavior of an E-Learning Management System in terms of processing the flow of instructions.
This designed sequence diagram is able to show programmers and readers about the sequence of
messages between the actor and the objects.
[ Sequence Diagram ]
IMPLEMENTATION
Programming Language Selection
There should have a clear purpose or goal in the mind before choosing a programming language
for a project. The choice of language heavily depends on the type of application. What kind of
application is going to build? Is it a web application or mobile application or its embedded
firmware etc.? This is the first and one of the biggest factors one should consider before choose
any programming language for a project.
Overview of Technologies used:
 HTML provides the basic structure of sites, which is enhanced and modified by other
technologies like CSS and JavaScript.
 CSS is used to control presentation , formatting and layout.
 JavaScript is used to control the behavior of different elements.
HTML:
Hypertext Markup Language (HTML) is the standard markup language for creating web pages
and web applications. With Cascading Style Sheets (CSS) and JavaScript, it forms a triad of
cornerstone technologies for the World Wide Web. Web browsers receive HTML documents
from a web server or from local storage and render the documents into multimedia web pages.
HTML describes the structure of a web page semantically and originally included cues for the
appearance of the document. HTML elements are the building blocks of HTML pages. With
HTML constructs, images and other objects such as interactive forms may be embedded into the
rendered page. HTML provides a means to create structured documents by denoting structural
semantics for text such as headings, paragraphs, lists, links, quotes and other items. HTML
elements are delineated by tags, written using angle brackets. Tags such as <img/> and <input/>
introduce content into the page. Other tags such as <p>…</p> surround and provide information
about document text and may include other tags as sub-elements. Browsers do not display the
HTML tags, but use them to interpret the content of the page.
HTML can embed programs written in a scripting language such as JavaScript which affects the
behaviour and content of web pages. Inclusion of CSS defines the look and layout of content.
The World Wide Web Consortium (W3C), maintainer of both the HTML and the CSS standards,
has encouraged the use of CSS over explicit presentational HTML since 1997.
CSS :
CSS Stands for "Cascading Style Sheet." Cascading style sheets are used to format the layout
of Web pages. They can be used to define text styles, table sizes, and other aspects of Web
pages that previously could only be defined in a page's HTML. CSS helps Web developers
create a uniform look across several pages of a Web site. Instead of defining the style of each
table and each block of text within a page's HTML, commonly used styles need to be defined
only once in a CSS document. Once the style is defined in cascading style sheet, it can be used
by any page that references the CSS file. Plus, CSS makes it easy to change styles across
several pages at once. For example, a Web developer may want to increase the default text size
from 10pt to 12pt for fifty pages of a Web site. If the pages all reference the same style sheet,
the text size only needs to be changed on the style sheet and all the pages will show the larger
text. While CSS is great for creating text styles, it is helpful for formatting other aspects of
Web page layout as well. For example, CSS can be used to define the cell padding of table
cells, the style, thickness, and color of a table's border, and the padding around images or other
objects. CSS gives Web developers more exact control over how Web pages will look than
HTML does. This is why most Web pages today incorporate cascading style sheets.
JavaScript:
JavaScript often abbreviated as JS, is a high-level, interpreted programming language. It is a

language which is also characterized as dynamic, weakly typed, prototype-based and multi
paradigm. Alongside HTML and CSS, JavaScript is one of the three core technologies of
World Wide Web content engineering. It is used to make dynamic web pages interactive and
provide online programs, including video games. The majority of websites employ it, and all
modern web browsers support it without the need for plug-ins by means of a built in JavaScript
engine. Each of the many JavaScript engines represent a different implementation of
JavaScript, all based on the ECMA Script specification, with some engines not supporting the
spec fully, and with many engines supporting additional features beyond ECMA.
As a multi-paradigm language, JavaScript supports event-driven, functional, and imperative

(including object-oriented and prototype-based) programming styles. It has an API for working
with text, arrays, dates, regular expressions, and basic manipulation of the DOM, but the
language itself does not include any I/O, such as networking, storage, or graphics facilities,
relying for these upon the host environment in which it is embedded. Initially only
implemented client-side in web browsers, JavaScript engines are now embedded in many other
types of host software, including server-side in web servers and databases, and in non-web
programs such as word processors and PDF software, and in runtime environments that make
JavaScript available for writing mobile and desktop applications, including desktop widgets.
Although there are strong outward similarities between JavaScript and Java, including language
name, syntax, and respective standard libraries, the two languages are distinct and differ greatly
in design; JavaScript was influenced by programming languages such as Self and Scheme.
What is Apache?
The Apache web server, more popular as simply Apache, represents an open-source web server
platform lying in the basis of most of the websites we see today on the World Wide Web.
Looking back at the time when it was introduced in mid 90's and gradually adopted as a
preferred server platform on the web, we could state that Apache acted as the main driving
force behind today's web expansion. As a web server 'pioneer', Apache has turned into a
standard for the development of other successful web server platforms. The Apache web server
is a work of the Apache Software Foundation open source community. Namely the fact that it
is backed up by the efforts of many supporters worldwide keeps it so well maintained and
regularly updated with new useful features and functionalities up to the latest quality and
security requirements in HTTP service delivery. Where does that strange name of the popular
server come from? There are two intriguing and radically different stories behind its origin. The
more popular one says that naming the server this way is a kind of a tribute to the Native
American Indian tribe Apache, known for its fighting strength and dauntless spirit. According
to the other story, the name ‘Apache server’ represents a sound analogue to ‘a patchy server’,
with 'patchy' referring to the bundle of patches that are attached to the codebase of NCSA
HTTP 1.3.
MySQL :
MySQL is a database management system that is used by WordPress to store and retrieve all
your blog information. Think of it this way. If your database is a filing cabinet that WordPress
uses to organize and store all the important data from your website (posts, pages, images, etc),
then MySQL is the company that created this special type of filing cabinet. MySQL is an open
source relational database management system. It runs as a server and allows multiple users to
manage and create numerous databases. It is a central component in the XAMPP stack of open
source web application software that is used to create websites.
XAMPP stands for X-operating system, Apache, MySQL, PHP and Perl scripting. Most
WordPress installations use the XAMPP stack because it is open source and works seamlessly
with WordPress. WordPress requires MySQL to store and retrieve all of its data including post
content, user profiles, and custom post types. Most web hosting providers already have MySQL
installed on their web servers as it is widely used in many open source web applications such as
WordPress. WordPress uses the PHP programming language to store and retrieve data from the
MySQL database. To retrieve data from the database, WordPress runs SQL queries to
dynamically generate content.
SQL stands for Structured Query Language and is the programming language typically used to
query databases. For users that are not comfortable writing their own PHP and SQL scripts, most
web hosting providers offer easy to use web applications to manage databases. One such web
application is phpMyAdmin which allows users to manage their database using a web based
graphical interface. You can manipulate your tables visually while phpMyAdmin runs the SQL
queries for you.
Out of the box MySQL doesn’t come with any graphical interface and advanced level users may
prefer to just manage their databases from the command line.
What is PHP?
PHP is a server side scripting language. that is used to develop Static websites or Dynamic
websites or Web applications. PHP stands for Hypertext Pre-processor, that earlier stood for
Personal Home Pages. PHP scripts can only be interpreted on a server that has PHP installed.
The client computers accessing the PHP scripts require a web browser only. A PHP file contains
PHP tags and ends with the extension ".php".
What does PHP stand for?
PHP means - Personal Home Page, but it now stands for the recursive backronym PHP:
Hypertext Preprocessor. PHP code may be embedded into HTML code, or it can be used in
combination with various web template systems, web content management system and web
frameworks.
Why we use PHP?
 PHP is open source and free.

 Short learning curve compared to other languages such as JSP, ASP etc.
 Large community document.
 Most web hosting servers support PHP by default unlike other languages such as ASP
that need IIS. This makes PHP a cost effective choice.
 PHP is regular updated to keep abreast with the latest technology trends.
 Other benefit that you get with PHP is that it’s a server side scripting language;
this means you only need to install it on the server and client computers requesting for
resources from the server do not need to have PHP installed; only a web browser would
be enough.
 PHP has in built support for working hand in hand with My SQL, PostgreSQL Oracle
etc.
 PHP is cross platform; this means you can deploy your application on a number of
different operating systems such as windows, Linux, Mac OS etc.
Module Specification & its Database
VARIOUS TABELS TO MAINTAIN INFORMATION-
E-Learning Management System Table from Database: All the tables related data are stored under this
database as following,
 Department: All the department related data are stored under this database as
following,
 Course: All the course related data and newly added course are stored under this
 Programming Languages: All the programming languages related data and
newly added programming languages are stored under this database as following,
 Video: All the video related data and newly added videos are stored under this
 Comment: All the Comments of different videos are stored under this
comment database as following.

 Questions: All the questions added by the Admin are stored under this database
as following,
 Question Answers: All the question results are stored under this database as
following,
 Total User: All the users informations who log-in are stored under this
 Log-In: All the users information like users id & password, admin id &
password are stored under this database as following,
TESTING
System testing is the essential step for the development of a reliable and error free
system. Testing is the process is the process of executing a program with the explicit intension of
finding error i.e. making the program fail and test case are derived with the purpose in mind. A
test case is the set of data item that the system process as normal input. A successful test is one
that find an error.
Requirement listed in SRS document were used as a baseline for testing to ensure that
the existing and new functionality are working. Test case is derived for each requirement as a
way of proving that the system or changes being implemented is ready for day to day business
use without error and/or adverse impact on the existing functionality. Requirement itself changed
from time to time and some become obsolete and to be removed together with the test case.
Test Environment:
 The software is tested with the required hardware and software requirements. The
software configuration is window 11.
 A testing strategy is decided for testing the system so that all modules are tested to fulfill
all user requirements. A test strategy is methodologies that describe the various steps that
need to be performed during testing and the time and effort required for performing them.
The following strategies are used for testing our application.
Unit Testing:
Unit testing is a white-box testing technique. The main consideration in the test is
verification of all modules of the software system. Each module is unit tested, as follows: Unit
testing the module to ensure that status is send to server. Unit testing the module to ensure
connection is established.
Unit testing the module to ensure data storage in Real-time Database when Connection
is established. Unit testing the module to ensure system security by verifying Admin. Unit
testing the module to ensure system security by verifying User. Unit testing the module to
Admin credentials Registration. Unit testing the module to manage Admin Logout. Unit testing
the module for View Complaint Details. Unit testing the module for Modify Worker
Information. Unit testing the module for viewing user meetings. Unit testing the module for user
complaints. Unit testing the module for adding new user. Unit testing the module for View user
profile. Unit testing the module for Update user password.
Integration Testing:
Integration testing is the technique for testing the interfaces of software components.
Each software components in unit tested, and all the components are integrated to perform
together. The test is conducted to ensure that the components are working properly after
interfacing.
All modules are integrated, and integration testing of the system is performed as follows:
Interface of the applications are integrated together and then tested. The Backend functionality is
then added and application is tested again. Following are the interfaces of the application:
Data transfer from web service to SQL Server (connection established)
 Admin/User(Login)
 Add different User
 Manage User Details
 Add Courses/Videos/Questions
 Manage Courses/Videos/Questions
 Give Efficiency test
 View Score
 Admin/User(Logout)
.
Test Report
Test case No. -1 Test case name: Verify the login page
Input set Expected output Actual output Remark/ Comment/ action
taken
A valid login logged in logged in Pass
name:admin
Invalid login name: Wrong username Wrong username Pass
user1122 or password or password
Test case No. -2 Test case name: Add new user who don’t have any account
taken
Add a new user name: logged in logged in Pass
newuser
Add an existing user id: Fail to login Wrong username or Pass
new password
...
Test case No. -3 Test case name: User Function Learn Courses
taken
Learn Programming Successfully Successfully Pass
Tutorials Redirected Redirected
Back to Homepage Successfully Successful Back Pass
Back to to Homepage
Homepage
Test case No. -4 Test case name: User Function Watch Videos
taken
Learn Programming Successfully Successfully Pass
Videos Redirected Redirected
Back to Homepage Back to Homepage Back to Homepage Pass
...
Test case No. -5 Test case name: User Function Exercise
Input set Expected output Actual output Remark/ Comment/
action taken
Practice Skill Test Successfully Successfully Pass
Redirected Redirected
Back To Homepage Successfully Successfully Pass
Back to Homepage Back to Homepage
Test case No. -6 Test case name: Admin Courses Function
action taken
Admin Add Courses Successfully Added Successfully Added Pass
Admin Update Courses Successfully Successfully Updated Pass

Updated
Admin Delete Courses Successfully Successfully Deleted Pass
Deleted
Test case No. -7 Test case name: Admin functions Videos/Lectures
action taken
Admin Add Videos Successfully Successfully Added Pass
Added
Admin Update Videos Successfully Successfully Updated Pass
Updated
Admin Delete Videos Successfully Successfully Deleted Pass

Deleted
Test case No. -8 Test case name: Admin Question function

action taken
Admin Add Question Successfully Successfully Added Pass
Added
Admin Update Question Successfully Successfully Pass
Updated Updated
Admin Delete Question Successfully Successfully Pass
Deleted Deleted
Source Code
Sign up:
<!DOCTYPE html>
<html>
<head>
<link href="https://fonts.googleapis.com/css?family=Aleo"
rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro"
rel="stylesheet">
<title>E-Learning Website</title>

<link href="https://fonts.googleapis.com/css?family=Lobster"
rel="stylesheet">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-
awesome/4.7.0/css/font-awesome.min.css">


<link rel="stylesheet" type="text/css" href="css/signupstyle.css">

<link rel="shortcut icon" type="text/css" href="img/mylogo.png">


<link rel="stylesheet"
href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">


<script
src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></
script>


<script
src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></
script>

</head>
<body>

<nav class="navbar navbar-inverse navbar-fixed-top">

<div class="container">
<div class="navbar-header">

<button type="button" class="navbar-toggle" data-
toggle="collapse" data-target="#navi">
<span class="icon-bar"></span>
</button>
<h1 style="color: white;margin-top: 10px;" id="myhead">E-

Learning Website</h1>
</div>
<div class="collapse navbar-collapse" id="navi">

<ul class="nav navbar-nav navbar-right">
<li> <a href="">Home</a></li>
<li> <a href="">Our Service</a></li>
<li> <a href="">Works</a></li>
<li> <a href="">Team</a></li>
<li> <a href="">About</a></li>
<li> <a href="">Carrier</a></li>
<li> <a href="" id="our-location" class="btn-success"
data-target="#mymodal" data-toggle="modal">Login/Signup</a></li>
</ul>

</div>
</div>
</nav>



<section class="slider text-center" id="slider">
<div class="modal-dialog ">
<div class="modal-content">
<h3 id="login-heading">SIGN UP</h3>
<div class="modal-body" >

<div class="left-box">
<form method="POST" action="registration.php">
<div class="form-group">
<label><i class="fa fa-user
fa-2x"></i>&nbspUsername :</label>
<input type="text" name="name" class="form-
control">
<label><i class="fa fa-lock

fa-2x"></i>&nbspPassword :</label>
<input type="text" name="password"
class="form-control" id="pwd">

fa-2x"></i>&nbspConfirm Password :</label>
<input type="text" name="confirm_password"
class="form-control" id="cpwd">

fa-2x"></i>&nbspEmail id :</label>
<input type="text" name="email" class="form-
control">
<div id="errorlabel"></div>
<button id="btn-login" type="submit">log
in</button>
</div>
</form>
</div>
<div class="right-box">
<span class="signinwith">Sign in With <br> Social
Networks</span>
<button class="social facebook">Log in with

Facebook</button>
<button class="social twitter">Log in with
twitter</button>
<button class="social google">Log in with
gmail</button>
</div>
</div>
<button id="btn-signup"><a id="sign"

href="index.php">Sign up</a></button>
</div>
</div>
</section>


<script type="text/javascript">
$(document).ready(function(){
$('#cpwd').keyup(function(){
var pwd=$('#pwd').val();
var cpwd=$('#cpwd').val();
if (cpwd!=pwd)
{
$('#errorlabel').html('**password are not matched');
$('#errorlabel').css('color','red');
return false;
}
else
{
$('#errorlabel').html('');
return true;
}
});
});
</script>

<script src="js/jquery.ripples-min.js" type="text/javascript"></script>

<script src="js/typed.min.js" type="text/javascript"></script>
</body>
</html>
Css style:
body {
background: #91a716;
display: flex;
justify-content: center;
align-items: center;
height: 100vh;
flex-direction: column;
*{
font-family: cursive;
box-sizing: padding-box;
form {
width: 1000px;
border: 3px solid rgb(177, 142, 142);
padding: 20px;
background: rgb(85, 54, 54);
border-radius: 20px;
h2 {
text-align: center;
margin-bottom: 40px;
}
input {
display: block;
border: 2px solid #ccc;
width: 95%;
padding: 10px;
margin: 10px auto;
border-radius: 5px;
label {
color: #888;
font-size: 18px;
padding: 10px;
button {
float: right;
padding: 10px 15px;
color: #fff;
border-radius: 5px;
margin-right: 10px;
border: none;
button:hover{
opacity: .10;
.error {
background: #F2DEDE;
color: #0c0101;
padding: 10px;
width: 95%;
border-radius: 5px;
margin: 20px auto;
h1 {
text-align: center;
color: rgb(134, 3, 3);
a {
float: right;
padding: 10px 15px;
color: #fff;
border-radius: 10px;
margin-right: 10px;
border: none;
text-decoration: none;
a:hover{
opacity: .7;
Validation PHP:
<?php
session_start();
$con=mysqli_connect('localhost','root');
if ($con)
{
echo "connection successful";
}
else
{
echo "no connection";
}
mysqli_select_db($con,'e-learning');
$name=$_POST['name'];
$pass=$_POST['password'];
$email=$_POST['email'];
$q="select * from login where username='$name' && password='$pass'";
$result=mysqli_query($con,$q);
$res=mysqli_fetch_assoc($result);
$num=mysqli_num_rows($result);
if ($num==1)
{
if ($res['username']=='admin')
{
header("location:admin/admin_main.php");
}
else
{
$_SESSION['username']=$name;
header('location:index.php');
}
}
else
{
$_SESSION['error']="error";
header('location:login.php');
?>
Registration PHP:
<?php
session_start();
if ($con)
{
echo "connection successful";
}
else
{
echo "no connection";
}
$name=$_POST['name'];
$pass=$_POST['password'];
$email=$_POST['email'];
$q="select * from login where username='$name' && password='$pass'";
$result=mysqli_query($con,$q);
$num=mysqli_num_rows($result);
if ($num==1)
{
"duplicate data";
header('location:signup.html');
}
else
{
$qy="insert into login(username,password,email)
values('$name','$pass','$email')";
mysqli_query($con,$qy);
echo "inserted";
}
?>
Sample HTML:
<!DOCTYPE html>
<html>
<head>
<title></title>

<script
script>


<script
src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js
"></script>

<script
script>
</head>
<body>
<div class="navbar bg-info h-50" style="height: 50px !important;">
<div >
<ul style="display: inline;" class="navbar-nav d-inline">
<li class="nav-item">
<a href="" class="nav-">HOME</a>
</li>
</li>
</li>
</ul>
</div>
</div>
<div class="row">
<div class="card">
<div class="card-header">
this is header
</div>
<div class="card-body">
<div class="card-img">
<img src="img/work1.png" class="img-thumbnail img-fluid"
height="400px" width="200px;">
</div>
this is card bosy

</div>
<div class="card-title">
this is title
</div>
</div>
</div>
<div class="row">
<table class="table table-bordered table-hover">
<thead>
<tr>
<th>username</th>
<th>password</th>
</tr>
</thead>
<tbody>
<tr>
<td>
sunil
</td>
<td>1234</td>
</tr>
<tr>
<td>mangesh</td>
<td>4562</td>
</tr>
</tbody>
</div>
</table>
<form>
<input type="text" name="" class="form-control">
</div>
<input type="text" name="" class="form-control">
</div>
</form>
</div>
</div>
JQuery(document).ready(function()
{
$(".slider").ripples({
})
);
</body>
</html>
Programming demo:
<?php
session_start();
?>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" type="text/css" href="css/programming.css">


<script
script>
<script
script>

rel="stylesheet">
<style type="text/css">
.context-dark, .bg-gray-dark, .bg-primary {
color: rgba(255, 255, 255, 0.8);
}
.footer-classic a, .footer-classic a:focus, .footer-classic a:active {

color: #ffffff;
}
.nav-list li {
padding-top: 5px;
padding-bottom: 5px;
}
.nav-list li a:hover:before {
margin-left: 0;
opacity: 1;
visibility: visible;
}
ul, ol {
list-style: none;
padding: 0;
margin: 0;
}
.social-inner {
display: flex;
flex-direction: column;
align-items: center;
width: 100%;
padding: 23px;
font: 900 13px/1 "Lato", -apple-system, BlinkMacSystemFont, "Segoe UI",
Roboto, "Helvetica Neue", Arial, sans-serif;
text-transform: uppercase;
color: rgba(255, 255, 255, 0.5);
}
.social-container .col {
border: 1px solid rgba(255, 255, 255, 0.1);
display: inline-block;
}
.nav-list li a:before {
content: "\f14f";
font: 400 21px/1 "Material Design Icons";
color: #4d6de6;
display: inline-block;
vertical-align: baseline;
margin-left: -28px;
margin-right: 7px;
opacity: 0;
visibility: hidden;
transition: .22s ease;
}
.div1 /* for title image*/

{
margin-top: 10%;
position: relative;
height: 500px;
width: 1263px;
background:url(uploadimg/programming_image.png);
}
</style>
</head>
<body>

</button>

</div>
<li> <a href="index.php">Home</a></li>
<li> <a href="" id="our-location" class="btn-success" ><?
php echo $_SESSION['username']; ?></a></li>
</ul>
</div>
</div>
</nav>
<div class="container-fluid div1">
</div>


<br><br><br><br><br>
<section class="latest-news-area" id="latest">
<div class="row">
<div class="col-xs-12">
<div class="section-title text-center">
<h2><b>PROGRAMMING LANGUAGES</b></h2>
<div class="sub-heading">
Following are the available programming
languages <br>
Start learning today
</div>
</div>
</div>
</div>
<br>
<?php
// session_start();
$q="select * from programming_languages";

$query=mysqli_query($con,$q);
while ($res=mysqli_fetch_array($query)) {
?>
<div class="col-md-4 col-sm-6 col-xs-12 content-border"

style="margin-bottom: 10px;">
<div class="latest-news-wrap">
<div class="news-img">
<img src=<?php echo
$res['language_image']; ?> class="img-responsive">
<div class="deat">
<span><?php echo
$res['language_name']; ?></span>
</div>
</div>
<div class="news-content">
<p>
<?php echo
$res['language_description']; ?>
</p><br>
<a
href="programming/java/java_programming.php?course_name=<?php echo
$res['language_name'] ?>">Start Reading...</a>
</div>
</div>
</div>
<?php } ?>
</div>
</section>


<br><br><br><br>
<footer class="section footer-classic context-dark bg-image"

style="background: #2d3246;">
<div class="row row-30">
<div class="col-md-4 col-xl-5">
<div class="pr-xl-4"><a class="brand" href="index.html"><img
class="brand-logo-light" src="images/agency/logo-inverse-140x37.png" alt=""
width="140" height="37" srcset="images/agency/logo-retina-inverse-280x74.png
2x"></a>
<p>E-Learning Website is an excellent learning hub, dedicated
to the programmer who want to explore.</p>

<p class="rights"><span>© </span><span class="copyright-
year">2023</span><span> </span><span>E-Learning
Website</span><span>. </span><span>All Rights Reserved.</span></p>
</div>
</div>
<div class="col-md-4">
<h5>Contacts</h5>
<dl class="contact-list">
<dt>Address:</dt>
<dd>Infocity Road, patia, Bhubaneswar 754024</dd>
</dl>
<dt>email:</dt>
<dd><a href="mailto:#">[email protected]</a></dd>
</dl>
<dt>phones:</dt>
<dd><a href="tel:#">+91 8260955669</a> <span>or</span> <a
href="tel:#">+91 8847841860</a>
</dd>
</dl>
</div>
<div class="col-md-4 col-xl-3">
<h5>Links</h5>
<ul class="nav-list">
<li><a href="#">About</a></li>
<li><a href="#">Projects</a></li>
<li><a href="#">Blog</a></li>
<li><a href="#">Contacts</a></li>
<li><a href="#">Pricing</a></li>
</ul>
</div>
</div>
</div>
<div class="row no-gutters social-container">
<div class="col"><a class="social-inner" href="#"><span class="icon
mdi mdi-facebook"></span><span>Facebook</span></a></div>
mdi mdi-instagram"></span><span>instagram</span></a></div>
mdi mdi-twitter"></span><span>twitter</span></a></div>
mdi mdi-youtube-play"></span><span>google</span></a></div>
</div>
</footer>

</body>
</html>
Programming HTML:
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" type="text/css" href="css/programming.css">


<script
script>
<script
script>

rel="stylesheet">
.bgcolor
{
background: rgba(0,0,0,0.1);
body
{
background: #FC354C; /* fallback for old browsers */
background: -webkit-linear-gradient(to right, #0ABFBC, #FC354C); /* Chrome
10-25, Safari 5.1-6 */
background: linear-gradient(to right, #0ABFBC, #FC354C); /* W3C, IE 10+/ Edge,
Firefox 16+, Chrome 26+, Opera 12+, Safari 7+ */
color: white;
}
.navbar
{
background: #C04848; /* fallback for old browsers */
background: -webkit-linear-gradient(to right, #480048, #C04848); /* Chrome
10-25, Safari 5.1-6 */
background: linear-gradient(to right, #480048, #C04848); /* W3C, IE 10+/ Edge,
Firefox 16+, Chrome 26+, Opera 12+, Safari 7+ */
}
</style>
</head>
<body>

</button>

</div>
<li> <a href="index.php">Home</a></li>
data-target="#mymodal" data-toggle="modal">Add New Course</a></li>
</ul>
</div>
</div>
</nav>

<br><br><br><br><br>
<section class="latest-news-area" id="latest">
<div class="row">
<h2><b>PROGRAMMING LANGUAGES</b></h2>
Following are the available programming
languages <br>
Start learning today
</div>
</div>
</div>
</div>
<br>
<div class="row">
<div class="news-active">
<div class="col-md-4 col-sm-6 col-xs-12 content-
border" >
<div class="bgcolor latest-news-wrap " >
<img src="img/JAVA.png" class="img-
responsive">
<div class="deat">
<span>JAVA</span>
</div>
</div>
<p>
Python is a scripting language
like PHP, Perl, Ruby and so much more. It can be used for web programming
</p><br>
<a
href="http://localhost/MyResponsiveWebsite/programming/java/java_programming.h
tml">Start Reading...</a>
</div>
</div>
</div>

border">
<div class="bgcolor latest-news-wrap">
<img src="img/PYTHON.png" class="img-
responsive">
<div class="deat">
<span>PYTHON</span>
</div>
</div>
<p>
</p><br>
<a
href="http://localhost/MyResponsiveWebsite/programming/python/python_home.html
">Start Reading...</a>
</div>
</div>
</div>

border">
<div class="bgcolor latest-news-wrap">
<img src="img/ANDROID.png" class="img-
responsive">
<div class="deat">
<span>ANDROID</span>
</div>
</div>
<p>
</p><br>
<a
href="http://localhost/MyResponsiveWebsite/programming/android/android_home.ht
ml">Start Reading...</a>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
</body></html>
Logout PHP:
<?php
session_start();
session_destroy();
?>
Login page HTML:
<!DOCTYPE html>
<html>
<head>
<title>LOGIN</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<header><div></div>
<h1> home </h1>
</header>
<section>
<form action="login.php" method="post">
<h2>LOGIN</h2>
<?php if (isset($_GET['error'])) { ?>
<p class="error"><?php echo $_GET['error']; ?></p>
<?php } ?>
<label>User Name</label>
<input type="text" name="uname" placeholder="User
Name"><br>
<label>Password</label>
<input type="password" name="password"

placeholder="Password"><br>
<button type="submit">Login</button>
</form>
</section>
</body>
</html>
Login PHP:
<?php
session_start();
?>
<!DOCTYPE html>
<html>
<head>
rel="stylesheet">
rel="stylesheet">
rel="stylesheet">

<link rel="stylesheet" type="text/css" href="css/login.css">



<script
script>

<script
script>

<meta name="google-signin-client_id" content="808976312783-

k901nr0n50did222qa275k0umvn4rpi1.apps.googleusercontent.com">


<script src="https://apis.google.com/js/platform.js" async defer></script>


<script type="text/javascript" src="js/google_signin.js"></script>

<script type="text/css">
</script>
</head>
<body>

</button>

</div>
data-target="#mymodal" data-toggle="modal">Login/Signup</a></li>
</ul>
</div>
</div>
</nav>


<h3 id="login-heading">Login</h3>

<form method="POST" action="validation.php"
onsubmit="return validation()">
fa-2x"></i>Username :</label>
<input type="text" autocomplete="off"
name="name" class="form-control" id="username" onkeypress="clear()">

fa-2x"></i>Password :</label>
<input type="password" autocomplete="off"
name="password" class="form-control" id="password">
<span id="perror"><?php
if(isset($_SESSION['error']))
{
echo "wrong username or password";
}
else{ echo " ";}
?>
</span>
<button id="btn-login"
type="submit">Login</button>
</div>
<div class="register">
<h2>Don't have an account?&nbsp<span
id="create-account"><a href="signup.html">Create</span></a> </h2>
</div>
</form>
</div>
Networks</span>
Facebook</button>
twitter</button>
<button type="submit" class="social google g-signin2"
data-onsuccess="onSignIn()">Log in with gmail</button>
</div>
</div>
</div>
</div>
</section>
function validation() {
var username=document.getElementById('username').value;
var password=document.getElementById('password').value;
if ((username=="") ||( password==""))

{
document.getElementById('perror').innerHTML="please fill the details";
return false;
}
}
function clear() {
document.getElementById('perror').innerHTML="ksdfisdhfg";
}
</script>


</body>
</html>
Image upload HTML:
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<form method="POST" action='imgdemo.php' enctype="multipart/form-data">
<label><i class="fa fa-user fa-2x"></i>Language Name :</label>
<input type="text" name="languagename" class="form-control">
<label><i class="fa fa-lock fa-2x"></i>Language Image :</label>

<input type="file" name="languageimg" class="form-control">
<label><i class="fa fa-lock fa-2x"></i>Language Description :</label>

<input type="text" name="languagedesc" class="form-control">
<button id="btnlogin" type="submit">Add Course</button>
</div>
<h2>Don't have an account?&nbsp<span id="create-account"><a
href="signup.html">Create</span></a> </h2>
</div>
</form>
</body>
</html>
Demo HTML:
<!DOCTYPE html>
<html>
<head>
<script
script>
<script
script>
</head>
<body>
<div class="row">
<div class="col-md-4 col-sm-6 col-xs-12">
<div class="card" style="width: 18rem;">
<img src="img/1logo.png" class="card-img-top" alt="...">
<h5 class="card-title">Card title</h5>
<p class="card-text">Some quick example text to build on
the card title and make up the bulk of the card's content.</p>
<a href="#" class="btn btn-primary">Go somewhere</a>
</div>
</div>
</div>

</div>
</div>
</div>

</div>
</div>
</div>
</div>
</div>
</body>
</html>
Index PHP:
<?php
session_start();
if (!isset($_SESSION['username'])) {
# code...
?>
<!DOCTYPE html>
<html>
<head>
rel="stylesheet">
rel="stylesheet">

<link rel="stylesheet" type="text/css" href="css/magnific-popup.css">


<link rel="stylesheet" type="text/css" href="css/owl.carousel.min.css">
<link rel="stylesheet" type="text/css"
href="css/owl.theme.default.min.css">
rel="stylesheet">
<link rel="stylesheet" type="text/css" href="css/style.css">
<script
script>
<script type="text/javascript"
src="js/jquery.magnific-popup.min.js"></script>
<script type="text/javascript" src="js/owl.carousel.min.js"></script>
<script type="text/javascript" src="js/owl.carousel.js"></script>
<script
script>
.servicebody
{
html
{
scroll-behavior: smooth;
}
</style>
</head>
<body onload="myfunction()">
<div id="loading"></div>

\
</button>
</div>
<li> <a href="#myservice_section">Our Service</a></li>
<li> <a href="#work">Works</a></li>
<li> <a href="#myfaq">FAQs</a></li>

<li> <a href="logout.php" id="our-location" class="btn-
success" ><?php echo $_SESSION['username']; ?></a></li>
</ul>
</div>
</div>
</nav>
<div class="slider-overlay">
<div class="slider-content">
<div class="icons">
<i class="fa fa-apple"></i>

<i class="fa fa-android"></i>
<i class="fa fa-windows"></i>
</div>
<br>
<div class="text"> 
</div>
<div class="cta-div">
<a href="" class="btn1">CONTACT US</a>
<a href="#myservice_section"
class="btn2">LEARN TODAY</a>
</div>
<br><br>
<div class="social-networks">
<a href="https://www.facebook/com-
282626055790378/?modal=admin_todo_tour" class="fa fa-facebook"></a>
<a href="https://twitter.com/" class="fa fa-
twitter"></a>
<a href="https://www.instagram.com" class="fa
fa-instagram"></a>
<a href="" class="fa fa-reddit"></a>
<a href="https://www.linkedin.com/in/sunil-
yadav-70b3bb181/" class="fa fa-linkedin"></a>
<a href="" class="fa fa-cog"></a>
</div>
</div>
</div>
</section>
<div class="modal fade modal-dialog-centered" id="mymodal">

<h3 id="login-heading">Login</h3>

<form method="POST" action="validation.php">
fa-2x"></i>Username :</label>
<input type="text" name="name" class="form-
control">

fa-2x"></i>Password :</label>
<input type="password" name="password"
class="form-control">
<button id="btn-login"
type="submit">Login</button>
</div>
<h2>Don't have an account?&nbsp<span
id="create-account"><a href="signup.html">Create</span></a> </h2>
</div>
</form>
</div>
Networks</span>

Facebook</button>
twitter</button>
<button class="social google">Log in with
gmail</button>
</div>
</div>
</div>
</div>
</div>
<br><br>
<div class="container-fluid servicebody" id="myservice_section">
<div class="service-are" id="service">
<div class="row">
<h2><b>SERVICES</b></h2>
<p>
</p>
</div>
</div>
</div>
<div class="row">
<div class="service-wrap text-center">
<div class="service-icon">
<i class="fa fa-leaf"></i>
</div>
<h3><a href="programmingdemo.php">PROGRAMMING</a></h3>
<p>
</p>
</div>
</div>

<i class="fa fa-laptop"></i>
</div>
<h3><a href="video tutorials\java\
display_video_courses.php">VIDEO TUTORIALS</a></h3>
<p>
Here you will find all the videos tutorials
related to programming languages
like JAVA,PYTHON,ANDROID etc
</p>
</div>
</div>

<i class="fa fa-laptop"></i>
</div>
<h3><a
href="online_quize/quizhome.php">EXERCISE</a></h3>
</p>
</div>
</div>
</div>
</div>
</div>
<section class="work" id="work"><br>

<h2 id="work-heading" class="text-center" style="font-weight:
bold;">OUR WORK</h2>
<p class="text-center">join us to improve your works join us
to improve your works</p>
<div class="container-fluid">

<div class="row no-gutters">
<div class="img-wrapper">
<a href="img/work1.png" title="this is a sky
image">
<img src="img/work1.png" class="img-
responsive">
</a>
</div>
</div>

image">
responsive">
</a>
</div>
</div>

image">
responsive">
</a>
</div>
</div>

image">
responsive">
</a>
</div>
</div>

image">
responsive">
</a>
</div>
</div>

image">
responsive">
</a>
</div>
</div>

image">
responsive">
</a>
</div>
</div>

image">
responsive">
</a>
</div>
</div>
</div>
</section>
<br><br><br>
<section class="faq" id="myfaq">
<div class="row">
<div class="col-md-12 text-center">
<h2><b>GENERAL FAQs</b></h2>
<p>
you can ask the regarding the issues.we
will <br>solve that together for sure
</p>
</div>
</div>
</div>
</div> <br><br><br>
<div class="row">
<div class="col-md-7">
<div class="panel-group" id="accordian">
<?php
if (!$con) {
die('connection
failed'.mysqli_connect_error());
}
$sql="select * from faq";

$result=mysqli_query($con,$sql);
while ($row=mysqli_fetch_array($result))
{
?>
<div class="panel panel-default">

<div class="panel-heading"
id="headingOne">
<h4 class="panel-title">
<a href="#<?php echo $row['id']; ?
>" data-toggle="collapse" class="collapse" data-parent="#accordian"><?php echo
$row['faq_title']; ?></a>
</h4>
</div>
<div id="<?php echo $row['id']; ?>"
class="panel-collapse collapse " aria-labelledby="headingOne">
<div class="panel-body">
<p>
<?php echo
$row['faq_description']; ?>
</p>
</div>
</div>
</div>
<?php } ?>
<div class="panel panel-default">

<div class="panel-heading"
id="headingTwo">
<h4 class="panel-title">
<a href="#collapseTwo"
class="collapsed" data-toggle="collapse" data-parent="#accordian">How does it
works ?</a>
</h4>
</div>
<div id="collapseTwo" class="panel-
collapse collapse" aria-labelledby="headingTwo">
<div class="panel-body">
<p>
E-Learning Website is an
online E-learning website <br>
here you can learn programming
languages,Tech News and improve your coding skill
</p>
</div>
</div>
</div>
</div>
</div>
<div class="freeimage" id="meimg">

<div class="col-md-2 col-md-offset">
<img src="img/faq1.png">
</div>
</div>
</div>
</div>
</section>
<div class="row text-center">

<h2><b>CONTACT US</b></h2><br><br>
<center>
<div class="card-body border-info">
<form>
<label for="exampleInputEmail1">Email address</label>
<input type="email" class="form-control" aria-describedby="emailHelp"
placeholder="Enter email">
<small id="emailHelp" class="form-text text-muted">We'll never share your
email with anyone else.</small>
</div>
<label for="exampleInputPassword1">message</label>
<input type="password" class="form-control" placeholder="enter your
message">
</div>
<button type="submit" class="btn btn-primary">Submit</button>

</form>
</div>
</div></center>
</div>
var preloader=document.getElementById('loading');
function myfunction()
{
preloader.style.display='none';
}
function addButton() {
var body=document.getElementsByTagName('body')[0];
var myfaq1=document.getElementById('myfaq');
var btn=document.createElement('button');
btn.innerHTML='sunil';
myfaq1.appendChild(btn);
body.appendChild(myfaq);
}
</script>

<script src="js/main.js" type="text/javascript"></script>
</body>
</html>
E Learning SQL:
-- phpMyAdmin SQL Dump

-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 22, 2021 at 07:36 AM
-- Server version: 10.3.16-MariaDB
-- PHP Version: 7.1.30
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
--
-- Database: ùniquedeveloper`
--
-- --------------------------------------------------------
--
-- Table structure for table ànswers`
--
CREATE TABLE ànswers` (

àid` int(255) NOT NULL,
ànswer` varchar(255) DEFAULT NULL,
àns_id` int(250) DEFAULT NULL,
`course_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table ànswers`
--
INSERT INTO ànswers` (àid`, ànswer`, àns_id`, `course_name`) VALUES

(1, 'Home Tool Markup Language', 1, 'html'),
(2, 'Hyperlinks and Text Markup Language', 1, 'html'),
(3, ' Hyper Text Markup Language', 1, 'html'),
(4, ' Hyper Train Markup Language', 1, 'html'),
(5, ' Mozilla', 2, 'html'),
(6, ' Google', 2, 'html'),
(7, 'Microsoft', 2, 'html'),
(8, 'W3C', 2, 'html'),
(9, '<head>', 3, 'html'),
(10, '<heading>', 3, 'html'),
(11, '<h6>', 3, 'html'),
(12, '<h1>', 3, 'html'),
(13, '<lb>', 4, 'html'),
(14, '<br>', 4, 'html'),
(15, '<break>', 4, 'html'),
(16, '<bk>', 4, 'html'),
(17, 'programming language', 5, 'java'),
(18, 'web designing language', 5, 'java'),
(19, 'OOPS language', 5, 'java'),
(20, 'general purpose language', 5, 'java');
-- --------------------------------------------------------
--
-- Table structure for table `category`
--
CREATE TABLE `category` (

ìd` int(4) NOT NULL,
`cat_name` varchar(100) NOT NULL
--
-- Dumping data for table `category`
--
INSERT INTO `category` (ìd`, `cat_name`) VALUES

(1, 'php'),
(2, 'java'),
(3, 'javascript'),
(4, 'python'),
(5, 'android'),
(6, 'jQuery'),
(8, 'IR'),
(9, 'hadoop'),
(10, 'hadoop'),
(11, 'comedy nights'),
(12, 'css'),
(13, 'spring');
-- --------------------------------------------------------
--
-- Table structure for table `commentsection`
--
CREATE TABLE `commentsection` (

`cid` int(11) NOT NULL,
ùid` varchar(120) NOT NULL,
`date` datetime NOT NULL,
`message` text NOT NULL,
`video_id` int(255) NOT NULL,
`video_path` varchar(255) NOT NULL
--
-- Dumping data for table `commentsection`
--
INSERT INTO `commentsection` (`cid`, ùid`, `date`, `message`, `video_id`,

`video_path`) VALUES
(153, 'sunil yadav', '2019-04-15 19:05:17', '5', 50, 'comedy knights'),
(155, 'sunil', '2021-03-13 15:50:57', 'very helpful', 51, '');
-- --------------------------------------------------------
--
-- Table structure for table `courses`
--
CREATE TABLE `courses` (

`topic_name` varchar(255) NOT NULL,
`description` text NOT NULL,
`course_name` varchar(255) NOT NULL
--
-- Dumping data for table `courses`
--
INSERT INTO `courses` (ìd`, `topic_name`, `description`, `course_name`)

VALUES
(51, 'C-Variable', '<p>vavriab;e</p>\r\n', 'C'),

(52, 'android-variable', '<p>android variables are statically typed</p>\r\n',
'Android'),
(53, 'java-static', '<p>sdfzf</p>\r\n', 'java'),
(54, 'CSS Variable', '<p>CSS VAriabel demo.</p>\r\n', 'css'),
(55, 'CSS style tag', '<p>it is a description</p>\r\n', 'css');
-- --------------------------------------------------------
--
-- Table structure for table `faq`
--
CREATE TABLE `faq` (

`faq_title` varchar(255) NOT NULL,
`faq_description` varchar(255) NOT NULL
--
-- Dumping data for table `faq`
--
INSERT INTO `faq` (ìd`, `faq_title`, `faq_description`) VALUES

(1, 'what is your website is about ?', 'this website is a free TV shows
ratting website'),
(2, 'How to rate the videos ?', 'Go to view videos section and select your
favourite TV show and give ratting there'),
(3, 'how to log in ?', 'goto bingeflix.com/login and from there you can
login');
-- --------------------------------------------------------
--
-- Table structure for table ìmage`
--
CREATE TABLE ìmage` (

ìmg` varchar(255) NOT NULL
--
-- Dumping data for table ìmage`
--
INSERT INTO ìmage` (ìmg`) VALUES

('uploadimg/4.png'),
('uploadimg/4.png'),
('uploadimg/3logo.png');
-- --------------------------------------------------------
--
-- Table structure for table `login`
--
CREATE TABLE `login` (

ùsername` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
èmail` varchar(255) DEFAULT NULL
--
-- Dumping data for table `login`
--
INSERT INTO `login` (ìd`, ùsername`, `password`, èmail`) VALUES
(1, 'sunil yadav', '1234', '[email protected]'),
(3, 'sunil ', '1234', '[email protected]'),
(8, 'deepak', '5687', 'ndvnkvjks'),
(11, 'deepak y', '258', 'lsnzbbv'),
(12, 'deepa', '520', 'sam8rt7gnailvnnvngkjf'),
(19, 'ghf', 'rtat', ''),
(20, 'deepak', '7896', 'osdbfas@ukhsvdfb'),
(21, 'mahesh', '258', '[email protected]'),
(22, 'mahesh', 'mahesh', 'sanmsnksd@,zxv'),
(23, 'mangesh', '2589', 'sbdjchjsdc'),
(24, 'rahul', '123', 'bdjkbdasb'),
(25, 'mangesh tiwari', '123', 'jfdvfsdvdf'),
(26, 'sunil yadav', '12345', 'jbsadjvb'),
(27, 'hg', '', ''),
(28, 'admin', 'admin', 'samndjdsfadg'),
(29, 'deepak yadav', '123456789', ''),
(30, '', '', ''),
(32, 'mahesh', 'singh', '12345'),
(33, 'mangesh', '12345678', 'jdvzhfds'),
(34, 'deepak', 'deepak123', '[email protected]');
-- --------------------------------------------------------
--
-- Table structure for table `mytable`
--
CREATE TABLE `mytable` (

`video_path` varchar(255) NOT NULL,
`video_name` varchar(255) NOT NULL,
--
-- Dumping data for table `mytable`
--
INSERT INTO `mytable` (ìd`, `video_path`, `video_name`, ìmg`) VALUES

(1, 'path1', 'myvideo', 'httpvideo'),
(2, 'path2', 'myvideo2', 'httpvideo2');
-- --------------------------------------------------------
--
-- Table structure for table `programming_languages`
--
CREATE TABLE `programming_languages` (

`language_name` varchar(255) DEFAULT NULL,
`language_image` varchar(255) DEFAULT NULL,
`language_description` varchar(255) DEFAULT NULL
--
-- Dumping data for table `programming_languages`
--
INSERT INTO `programming_languages` (ìd`, `language_name`, `language_image`,

`language_description`) VALUES
(0, 'java', 'uploadimg/JAVA.png', ''),
(3, 'Android', 'uploadimg/ANDROID.png', 'its an android course'),
(9, 'python', 'uploadimg/PYTHON.png', '');
-- --------------------------------------------------------
--
-- Table structure for table `questions`
--
CREATE TABLE `questions` (

`qid` int(250) NOT NULL,
`question` varchar(255) DEFAULT NULL,
àns_id` int(255) DEFAULT NULL,
`course_name` varchar(255) DEFAULT NULL
--
-- Dumping data for table `questions`
--
INSERT INTO `questions` (`qid`, `question`, àns_id`, `course_name`) VALUES

(1, 'what does html stands for', 1, 'html'),
(2, ' Who is making the Web standards?', 5, 'html'),
(3, ' Choose the correct HTML element for the largest heading:', 9, 'html'),
(4, 'What is the correct HTML element for inserting a line break?', 13,
'html'),
(5, 'what is java ?', 17, 'java');
-- --------------------------------------------------------
--
-- Table structure for table `question_test`
--
CREATE TABLE `question_test` (

`question` varchar(255) NOT NULL,
òpt1` varchar(255) NOT NULL,
ànswer` int(100) NOT NULL,
`course_id` int(255) NOT NULL
--
-- Dumping data for table `question_test`
--
INSERT INTO `question_test` (ìd`, `question`, òpt1`, òpt2`, òpt3`, òpt4`,

ànswer`, `course_id`) VALUES
(1, 'What does PHP stand for?', 'PHP: Hypertext Preprocessor', 'Private Home
Page', 'Personal Hypertext Processor', 'i dont know', 0, 1),
(2, 'How do you write \"Hello World\" in PHP', ' Document.Write(\"Hello
World\")', ' echo \"Hello World\"', '\"Hello World\"', 'i dont know', 1, 1),
(14, 'what is haddop', 'i dont know', 'whatever ', 'bigdata soluntion',
'bigdata', 2, 9),
(15, 'The practice of creating objects based on predefined classes is often
referred to as..', ' class creation', 'object creation', 'object
instantiation', 'class instantiation', 3, 1),
(19, '', '', '', '', '', 0, 0),
(20, 'question 1', 'option 1', 'option 2', 'option 3', 'option 4 ', 1, 13),
(21, '', '', '', '', '', 0, 0),
(22, 'question 1', 'option 1', 'option 2', 'option 3', 'option 4 ', 1, 14),
(23, '', '', '', '', '', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table ùser`
--
CREATE TABLE ùser` (

ùid` int(255) NOT NULL,
ùsername` varchar(255) DEFAULT NULL,
`totalques` int(255) DEFAULT NULL,
ànswerscorrect` int(255) DEFAULT NULL
--
-- Dumping data for table ùser`
--
INSERT INTO ùser` (ùid`, ùsername`, `totalques`, ànswerscorrect`) VALUES

(1, 'sunil yadav', 5, 4),
(10, 'sunil yadav', 5, 0),
(11, 'sunil yadav', 5, 0),
(12, 'sunil yadav', 5, 0),
(13, 'sunil yadav', 5, 0),
(14, 'sunil yadav', 5, 0),
(15, 'sunil yadav', 5, 0),
(16, 'sunil yadav', 5, 0),
(17, 'sunil yadav', 5, 0),
(18, 'sunil yadav', 5, 0),
(19, 'sunil yadav', 5, 3),
(20, 'sunil yadav', 5, 3),
(21, 'sunil yadav', 5, 0),
(22, 'sunil yadav', 5, 2),
(23, 'sunil yadav', 5, 2),
(24, 'sunil yadav', 5, 5),
(25, 'sunil yadav', 5, 1),
(26, 'sunil yadav', 5, 0),
(27, 'sunil yadav', 5, 1),
(28, 'sunil yadav', 5, 1),
(29, 'sunil yadav', 5, 1),
(30, 'sunil yadav', 5, 0),
(31, 'sunil yadav', 5, 0),
(32, 'sunil yadav', 5, 0),
(33, 'sunil yadav', 5, 0),
(34, 'sunil yadav', 5, 0),
(35, 'sunil yadav', 5, 0);
-- --------------------------------------------------------
--
-- Table structure for table ùsers`
--
CREATE TABLE ùsers` (

`name` varchar(255) NOT NULL,
`password` int(255) NOT NULL,
èmail` varchar(255) NOT NULL,
--
-- Dumping data for table ùsers`
--
INSERT INTO ùsers` (ìd`, `name`, `password`, èmail`, ìmg`) VALUES

(15, 'sunil yadav', 2365, '[email protected]', 'img1.jpg'),
(19, 'sunil yadav', 5641, '[email protected]', 'ANDROID.png'),
(20, 'sunil yadav', 856412, '[email protected]', 'danish.jpg'),
(21, 'sunil yadav', 56441, '[email protected]', 'javalogo.png');
-- --------------------------------------------------------
--
-- Table structure for table `videos`
--
CREATE TABLE `videos` (

`video_id` int(255) NOT NULL,
`video_path` varchar(255) NOT NULL,
`video_name` varchar(255) NOT NULL,
`course_name` varchar(255) NOT NULL,
`video_image` varchar(255) NOT NULL
--
-- Dumping data for table `videos`
--
INSERT INTO `videos` (`video_id`, `video_path`, `video_name`, `course_name`,
`video_image`) VALUES
(51, 'https://www.youtube.com/embed/LGKniBZoxvc', 'How to download jcalender
in Netbeans | Hindi', 'java', '../../uploadimg/4.png'),
(52, 'https://www.youtube.com/embed/QmKJrnt4rQg', 'How to download jcalender
in Netbeans | Hindi', 'java', '../../uploadimg/v.png'),
(54, 'https://www.youtube.com/embed/9vIi56spxo8', 'How to do this', 'java',
'../../uploadimg/ANDROID.png'),
(56, 'https://www.youtube.com/embed/VEQYRJkoRBY', 'this is a python video',
'python', '../../uploadimg/2.png');
-- --------------------------------------------------------
--
-- Table structure for table `videos_demo`
--
CREATE TABLE `videos_demo` (

`name` varchar(255) NOT NULL
-- --------------------------------------------------------
--
-- Table structure for table `video_info`
--
CREATE TABLE `video_info` (

`course_id` int(255) NOT NULL,
ìmage` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`course_name` varchar(255) NOT NULL
--
-- Dumping data for table `video_info`
--
INSERT INTO `video_info` (`course_id`, ìmage`, `description`, `course_name`)

VALUES
(20, '../../uploadimg/java_online.png', 'its a complete java tutorial',
'java');
--
-- Indexes for dumped tables
--
--
-- Indexes for table ànswers`
--
ALTER TABLE ànswers`
ADD PRIMARY KEY (àid`);
--
-- Indexes for table `category`
--
ALTER TABLE `category`
ADD PRIMARY KEY (ìd`);
--
-- Indexes for table `commentsection`
--
ALTER TABLE `commentsection`
ADD PRIMARY KEY (`cid`);
--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
--
-- Indexes for table `faq`
--
ALTER TABLE `faq`
--
-- Indexes for table `login`
--
ALTER TABLE `login`
--
-- Indexes for table `mytable`
--
ALTER TABLE `mytable`
--
-- Indexes for table `programming_languages`
--
ALTER TABLE `programming_languages`
--
-- Indexes for table `questions`
--
ALTER TABLE `questions`
ADD PRIMARY KEY (`qid`);
--
-- Indexes for table `question_test`
--
ALTER TABLE `question_test`
--
-- Indexes for table ùser`
--
ALTER TABLE ùser`
ADD PRIMARY KEY (ùid`);
--
-- Indexes for table ùsers`
--
ALTER TABLE ùsers`
--
-- Indexes for table `videos`
--
ALTER TABLE `videos`
ADD PRIMARY KEY (`video_id`);
--
-- Indexes for table `videos_demo`
--
ALTER TABLE `videos_demo`
--
-- Indexes for table `video_info`
--
ALTER TABLE `video_info`
ADD PRIMARY KEY (`course_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table ànswers`
--
ALTER TABLE ànswers`
MODIFY àid` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
MODIFY ìd` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `commentsection`
--
ALTER TABLE `commentsection`
MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=159;
--
-- AUTO_INCREMENT for table `courses`
--
ALTER TABLE `courses`
--
-- AUTO_INCREMENT for table `faq`
--
ALTER TABLE `faq`
--
-- AUTO_INCREMENT for table `login`
--
ALTER TABLE `login`
--
-- AUTO_INCREMENT for table `mytable`
--
ALTER TABLE `mytable`
--
-- AUTO_INCREMENT for table `programming_languages`
--
ALTER TABLE `programming_languages`
--
-- AUTO_INCREMENT for table `questions`
--
ALTER TABLE `questions`
MODIFY `qid` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `question_test`
--
ALTER TABLE `question_test`
--
-- AUTO_INCREMENT for table ùser`
--
ALTER TABLE ùser`
MODIFY ùid` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT for table ùsers`
--
ALTER TABLE ùsers`
--
-- AUTO_INCREMENT for table `videos`
--
ALTER TABLE `videos`
MODIFY `video_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;
--
-- AUTO_INCREMENT for table `videos_demo`
--
ALTER TABLE `videos_demo`
--
-- AUTO_INCREMENT for table `video_info`
--
S
MODIFY `course_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
COMMIT;
Snapshots
E-LEARNING WEBSITE Home Page:
Admin Dashboard Page:

Manage Courses Page:
Edit Topic Page:

Add new Topic Page:
Update Topic Page:
Manage Videos Page:

Manage Video Page:
Add new Video Page:
Admin Manage Quiz Page:

User Home Page:
Services and Work Page:

Programming Languages Page:
Study Material Page:
Video Tutorials Page:

Watch videos Page:
Exercise Page:
View Test Result Page:
Conclusion
The E-LEARNING WEBSITE (E-Learning Management System) has been computed successfully and
was also tested successfully by taking "Test Cases". It is user friendly, and has required options, which
can be utilized by the user to perform the desired operations.
The Software is developed using HTML, CSS, JS as front end and PHP, MySql as back end in
windows environment.
The goals that are achieved by the software are:
 Simplification of the operations.

 Less processing time and getting required information.
 User friendly.
 Portable and flexible for further enhancement.
 Updating of information becomes so easier.
 It gives appropriate access to the authorized users depending on their permissions.
 System security, data security and reliability are the striking features
FUTURE SCOPE
E-LEARNING WEBSITE can be used in various sectors, schools, colleges, tuition centres,
or individual tutors. There is no doubt that the E-LEARNING WEBSITE is not perfect yet,
but students are really get benefit from them from their own pace. Our application will be
adding more free educational videos in future keeping in eyes for of lower standard students.
Content will be made more user-friendly so that each student will understand the concepts
more easily.
The Most important future scope from the development of the project is:-
 Live Class can be added.

 A user can give exam and get report.
 Users can interact with tutors and can solve their problems through live classes.
 More than one tutor can be added.

ONLINE QUIZ TEST-3

Uploaded by

Copyright:

Available Formats

ONLINE QUIZ TEST-3

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

ONLINE QUIZ TEST-3

Uploaded by

Copyright:

Available Formats

A

UNDER THE GUIDANCE OF:

DEPARTMENT OF MASTER IN COMPUTER

Head of the Department Principal

Internal Examiner External Examiner

I hereby declare that the project report entitled “submitted by me to UNITED

Place: Bhubaneswar Signature of the Candidate

With sincere regards,

3. Requirement gathering & Analysis

4. Details of Hardware & Software used

8. Methods used for Testing

12. Future Scope……………………………………………....48

OBJECTIVE OF THE PROJECT

1. a lot of copies of study material have to be made.

 This application is used to conduct online classes.

This application consisting of following modules.

2. Student Module: The student must be registered by the Administrator. A student

Non-functional requirements in our project are:

4. Performance: Performance is also a major non-functional requirement. Performance

Software Development Environment:

 Operating System: Windows 11

 Web technologies: HTML, CSS, JavaScript

 IDE: Visual Studio Code

 Web Server: Apache

 Processor: Intel Core i3

User id & pass Student

[ DATA FLOW DIAGRAM LEVEL 0 ]

User login & Permission User User Info

[ DATA FLOW DIAGRAM LEVEL 1 ]

Manage Courses &

Add id for Questions

[ DATA FLOW DIAGRAM LEVEL 2 ]

Result Checks Answer

[ Entity Relationship Diagram

- username: string - username: string

- subject: string - subject:string

+ view_doc() Mark secured + upload_doc()

User Sequence Diagram-

Programming Language Selection

JavaScript often abbreviated as JS, is a high-level, interpreted programming language. It is a

As a multi-paradigm language, JavaScript supports event-driven, functional, and imperative

What does PHP stand for?

Why we use PHP?

 PHP is open source and free.

VARIOUS TABELS TO MAINTAIN INFORMATION-

Data transfer from web service to SQL Server (connection established)

Admin Update Courses Successfully Successfully Updated Pass

Admin Delete Videos Successfully Successfully Deleted Pass

Test case No. -8 Test case name: Admin Question function

<link rel="stylesheet" type="text/css" href="css/signupstyle.css">

<nav class="navbar navbar-inverse navbar-fixed-top">

<h1 style="color: white;margin-top: 10px;" id="myhead">E-

<div class="modal-body" >

<label><i class="fa fa-lock

<label><i class="fa fa-user