Wa0136.
Wa0136.
Wa0136.
Pandi project
Submitted by
RAMAR.P
(2022J0858)
Under the guidance of
Mrs.PRIYA DHARSHINI, M.SC., M.Phil., (Ph.D)..
SNMV
(Shri Nehru Maha Vidyalaya)
(Affliated to Bharathiar University).
Shri Gambhirmal Bafna Nagar,
Malumachampatti
Coimbatore-641 050
APRIL-2023
CERTIFICATE
____________________ ______________________
Head of the department Principal
__________________ _____________________
Internal Examiner External Examiner
DECLARATION
Place: COIMBATORE
Date: 10/04/2023
RAMAR.P
(2022J0858)
Acknowledgement
ACKNOWLEDGEMENT
Synopsis
1 INTRODUCTOIN
1.1 About The Project
1.2 System Specification
1.2.1 Hardware Configuration
1.2.2 Software Specification
2 SYSTEM STUDY
2.1 Existing System
2.1.1 Drawbacks
2.2 Proposed System
2.2.1 Features
5 CONCLUSION
Bibliography
Appendices
A. Data Flow Diagram
B. Table Structure
C. Sample Coding
D. Sample Input
E. Sample Output
SYNOPSIS:
This simple project is entitled Mobile Comparison Website. This is a
simple web-based application that was developed using PHP and MySQL
Database. This project is a simple Content Management System (CMS) that
allow the users to compare the specification of the smartphones. The contents in
the system are dynamic which means they can be managed or modified in the
front-end. This has a pleasant user interface using the Bootstrap and AdminLTE
Template. Also, it has user-friendly features and functionalities.
1. INTRODUCTION
The Simple Mobile Comparison is a web based system that is made up of PHP,
MySQL for the database. This Simple Mobile Comparison that allow the user to
compare the soecification of the smartphones. This has a pleasant user interface
usind he Booststrap and Admin Template,Also,it has user-friendly features and
functionalities.
Backend : My SQL
Welcome to motor pump shop since their establishment in 1990, Mr. Radha
Krishnan was founded it has gained a no of clients as their valued customers.
Motor pump shop is supplying of monoblock, open-well, self-priming,
submersible.
Which is a well established motor pump shop in coimbatore . They provide high
quality products cable and panel board other household motor can buy with best
price. Our Unique is warranty service and replacement of motor pump products
with best offers .
Platform : Windows 7
Ram : 2 GB
2. SYSTEM ANALYSIS
Lack of privacy
Risk in the management of the data.
Less Security
Less User-friendly
Accuracy not guaranteed
Not in reach of distant users.
10
11
FRONT END
PHP
SERVER-SIDESCRIPTING
This server-side scripting is the most traditional and main target field for
PHP. Programmer needs three things to make this work. Programmer need to
run the web server, with a connected PHP installation. Programmer can access
the PHP program output with a web browser, viewing the PHP page through the
server.
12
usage is ideal for scripts regularly executed using croon (on*nix or Linux) or
Task Scheduler (on Windows). These scripts can also be used for simple text
processing tasks.
FEATURES OF PHP
BACK END
MySQL
13
Open source means that it is possible for anyone to use modify the
software. Anybody can download the MYSQL software uses the GPL (GNU
General Public License), to define what we may and may not use do with the
software.
14
easy to store, update and access data. One of the most powerful SQL servers out
there is called MySQL and surprisingly enough, it’s free.
SQL COMPATIBILITY
As before said SQL is a standardized language for querying and updating data
and for the administration of a database. Through the configuration setting sol-
mode we can make the MySQL server behave for the most part compatibly with
various database systems.
STORED PROCEDURES
Stored procedures (SPs for short) are generally used to simplify steps
such as inserting or deleting a data record.
TRIGGERS
Triggers are SQL commands that are automatically executed by the server
in certain database operations INSERT, UPDATE, and DELETE, MYSQL has
supported triggers.
15
REPLICATION
PLATFORM INDEPENDENCE
SPEED
16
3.SYSTEM DESIGN
Control redundancy
Easy of learning and use
Data independency
Input design is one of the most important phase of the system design.
Input design is the process where the input received in the system are planned
and designed, so as to get necessary information from the user, eliminating the
information that is not required. The aim of the input design is to ensure the
maximum possible levels of accuracy and also ensures that the input is
17
accessible that understood by the user. The input design is the part of overall
system design, which requires very careful attention. if the data going into the
system is incorrect then the processing and output will magnify the errors.
3.5.1 MODULE :
Module:
Admin-Side
Categories Management
Update Category
View Category
Delete Category
19
Fields Management
Update Field
View Field
Public-Side:
20
Module description:
Admin login:
o It has an admin account that controls the whole system. Admin has
the control to give access to employee in the system.
Comparison system:
o It compares the two cars features and characteristics as asked by
user.
Accessories option:
o It also provides varieties of accessories available with the cars.
Feedback form:
o User can provide reviews and feedback for particular car.
Enquiry form:
o If user has some confusion he can query the same in enquiry form.
The form is then sent to admin.
4.1SYSTEM TESTING
UNIT TESTING
21
INTEGRATION TESTING
The performance of user interactive testing is actually the user show. The
user gives live data and checks whether software is giving specified outputs.
User acceptance test of a system is the factor for the success of the system. The
system under consideration was listed for user acceptance by keeping constant
touch with the perspective user of the system at the time of design, development
and making changes whenever required for unit testing.The requirements of the
customer are gathered at regular intervals at the developing site itself.
FUNCTIONAL TESTING
with an eye to check all the validations. All the validations are clearly notified
to the user regarding jobseekers reg, new client reg, job order, job providers,
and job search preparation etc.
SYSTEM MAINTENANCE
23
The maintenance phase of the software life cycle is the time period in
which a software product performs useful work. For maintaining this system
properly the following points are to be followed strictly. The executable file of
forms and repots are given to the end users. Also the backup should be taken in
order to safe guard the system. Maintenance activities involve making
enhancement to software products, adapting products to new environment and
correction problems. Software product enhancement may involve providing
new functional capabilities, improving use displays and modes of interaction,
upgrading external documents and internal documentation or upgrading the
performance characteristics of a system.
24
5.1 CONCLUSION
System helps to store all the data about the customer order in computer
and there is no need to do paper work.
Data is going to be preserved carefully for longer period hence proper
backup is required otherwise there is chance of losing entries or data.
25
6.BIBLIOGRAPHY
REFERENCE BOOKS
Ian Lloyd, “Build Your Own Website the Right Way Using HTML & CSS”,
3rd Edition, Site Point, 2011.
WEBSITES
26
www.w3schools.com/PHP/
www.computerhope.com/starthtm.htm
www.webdesign.about.com/od/webdesignbasics/u/webdesignbasics.h.
www.w3schools.com/php/php_mysql_intro.asp
APPENDCIES
LEVEL 0
Mobile
Comparison
Admin Field_list_db
Website
Login
27
LEVEL 1
Admin
Manage
Users user_db
Manage
Category_db
Category
List
Enquiry
28
Manage
Mobile_db
Mobile
list
Enquiry
u- Pro-pri
a-id name Pro-
Pwd
ava
U- Pro-name
B-name
name Admin
Ct- Pro-
U- no Pro-
img3
id id
User Manag Product
m-
e 1
pwd
Add e-id Pro- charg
r Pro-rev-id quality img1 e
Pro-
Pro- des
productid
img2
Price Pro-pri-bef
Product reviews
summary searc
value h
30
B.TABLE STRUCTURE:
31
varchar
mobile_id Mobile id
(11)
varchar
field_id Field id
(11)
varchar
meta_value Meta value
(25)
32
C. SAMPLE CODING
<?php
session_start();
error_reporting(0);
include("include/config.php");
if(isset($_POST['submit']))
{
$username=$_POST['username'];
$password=md5($_POST['password']);
33
<!DOCTYPE html>
<html lang="en">
<head>
34
35
</ul>
</div><!-- /.nav-collapse -->
</div>
</div><!-- /navbar-inner -->
</div><!-- /navbar -->
<div class="wrapper">
<div class="container">
<div class="row">
<div class="module module-login span4 offset4">
<form class="form-vertical" method="post">
<div class="module-head">
<h3>Sign In</h3>
</div>
<span style="color:red;" ><?php echo htmlentities($_SESSION['errmsg']); ?
><?php echo htmlentities($_SESSION['errmsg']="");?></span>
<div class="module-body">
<div class="control-group">
<div class="controls row-fluid">
<input class="span12" type="text" id="inputEmail" name="username"
placeholder="Username">
</div>
</div>
<div class="control-group">
<div class="controls row-fluid">
<input class="span12" type="password" id="inputPassword" name="password"
placeholder="Password">
<div class="module-foot">
<div class="control-group">
<div class="controls clearfix">
36
37