Mazhar P.r.o.ject

COSMETICS AND BEAUTY PRODUCTS WEBSITE
A PROJECT REPORT
Submitted By
Md Mazhar Alam (2001292206)
In partial fulfillment of the award of the degree of

of
BACHELORS IN TECHNOLOGY
IN
ELECTRONICS AND COMMUNICATION ENGINEERING
GANDHI ENGINEERING COLLEGE, BHUBANESWAR

BIJUPATTNAIK UNIVERSITY OF TECHNOLOGY
APRIL 2024
Page | 0
Department Of
Electronics and Communication Engineering
GANDHI ENGINEERING COLLEGE, BHUBANESWAR
Approved by AICTE, New Delhi and affiliated to BPUT, Rourkela
CERTIFICATE
This is to certify that the Mr. Md Mazhar Alam bearing university
registration No. 2001292206 is a bonafide student of the department of
Electronics and Communication Engineering, Gandhi Engineering
College, Bhubaneswar. He has successfully completed the project work
entitled Cosmetics and beauty products website as per the curriculum
of the BPUT, Rourkela in partial fulfillment of the requirement for the
degree of bachelor of technology.
Prof. Himanshu Bhusan Mohapatra

HEAD OF THE DEPARTMENT
ECE
EXTERNAL EXAMINER
Page | 1
ACKNOWLEDGEMENT
Our sincere thanks to Prof. Himanshu Bhusan Mohapatra, Professor and Head of the
Department of Electronics and Communication Engineering, Gandhi Engineering
College (GEC), Bhubaneswar, for his encouragement and valuable suggestions during
the period of our Project work. No words would suffice to express my regards and
gratitude to Prof. Himanshu Bhusan Mohapatra, Department of Electronics and
Communication Engineering, for his inspiring guidance and constant encouragement,
immense support and help during the project work. Additionally, we appreciate the
guidance and support provided by our mentors throughout the project. Lastly, we extend
our thanks to the research community for sharing valuable insights and resources that
helped shape this work.
DATE: Md Mazhar Alam

PLACE: Bhubaneshwar 2001292206
Page | 2
ABSTRACT
All the modules of Cosmetic system had developed already but the ― Cosmetic and
Beauty Products Shop Management System ‖ is still working manually. I want to
computerize it.Cosmetic Shop Management system is a complete solution for
managing a shop, in other words,an enhanced tool that assists in organizing the
day-to-day activites if a Shop.There is a need of an application for efficient
management and handling customer orders.This Cosmetic Shop Management
system keeps every record which is required for Staff, Admin,Stock and Customer
of that Shop and by reducing paperwork. This application is used forkeeping the
information of Admin, Dealer, Customer, Purchasing and Stock. These records
arestored in the databasebwith security.Your data be a secure and onlu authorized
person can take the copy of data.This Project is developed in PHP using MySQL
Server.
Page | 3
CONTENTS
Title Pg No.
Chapter 1: Introduction
1.1. Introduction to Project 5
1.2. Objective
1.3. About Project 6
1.4. Advantages of the Project
Chapter 2: Requirement Analysis and System 7

Specification
Chapter 3: System Design

3.1. Case Diagram 8
3.2. 0 - Level Data Flow Diagram 9
3.3. Entities And Attributes 10
3.4. Entities – Relation Diagram 11
Chapter 4: Implementation, Testing, and Maintenance

4.1. Project Modules 12
4.2. Gantt Chart
Chapter 5: Results and Discussions

5.1. Snapshots(Admin Side) 13-18
5.2. Snapshots(Client Side) 19-25
5.3. Snapshots of Database Tables 25-28
5.4. Back Ends Representation(PHP) 29-39
5.5. Back Ends Representation(CSS & JS) 40
5.6. Back Ends Representation(MySQL) 41-46
Chapter 6: Future Scope 47-48
Chapter 7: References 49
Page | 4
CHAPTER 1
1.1. INTRODUCTION TO THE PROJECT

This project is entitled Cosmetics and Beauty Product Online Store. This
project was written in PHP/OOP and data are stored in a MySQL Database. It is
a web-based application that serves as an Online Platform for the Cosmetics and
Beauty Products Business. This application provides the customers of the said
business industry to explore, browser, and buy their products. This has lots of
features and functionalities including Online Payment using PayPal API. This
has a pleasant user interface using the Bootstrap Framework and the Admin
LTE Template. It has user-friendly features and functionalities.
1.2. OBJECTIVE OF PROJECT
The aim of this project is to develop a software for the effective management of
a cosmetics store. Maintaining correct database by providing an option to
update the products in stock. To provide optimal cosmetic inventory by
monitoring the products movement in the current market. To ensure that there
exists a level of restricted access based on functionality and role. To ensure that
the system is user friendly.
Page | 5
1.3. ABOUT THE COSMETICS AND BEAUTY PRODUCT
The Cosmetics and Beauty Product Online Store Project has 2 user interfaces.
Ones are for the management which is the Admin Panel of the system. This side
of the system can be accessed by the management. The Admin is in charge of
managing all the important lists or data in the system such as the list of products
and orders. The Admin can also manage the stocks of the products according to
their variant. The other side is for the client-side. This side is accessible to all
but some of the features are visible and working for registered clients only. The
possible clients can simply register their account in order to order their desired
products. The system can generate a printable date-wise sales report. The online
payment feature only supports using PayPal API.
1.4. ADVANTAGES OF PROPOSED SYSTEM

The aim of proposed system is to develop a software with improved facilities
which can overcome the limitations of existing system in the following ways.
Security of Data
Ensure accuracy of Data
Minimize manual paper work
Minimize the need for various processing
Greater efficiency
Better service
User friendly and interactive
Minimize time required
Page | 6
CHAPTER 2
SOFTWARE REQUIREMENT
I developed this project using the following:
XAMPP v3.3.0 as my local webserver that has a PHP Version 8.0.7

PHP Language, MySQL Database, HTML, CSS, JavaScript, JQuery, Ajax,
Bootstrap, AdminLTE
FEATURES
Secure Login and Logout
Dashboard
Display the summary of lists.
Brand Management
Add New Brand, List All Brands, View Brand, Update Brand, Delete
Brand
Category Management
Add New Category, List All Categories, View Category, Update
Category, Delete Category
Product Management
Add New Product, List All Products, Update Product, Delete Product
Inventory Management
Add New Stock, List All Stocks, Update Stock, Delete Stock
Order Management
List All Order, View Order Details, Update Order Status, Mark Order as
Paid, Delete Order
Manage Account Details/Credentials
Client-Side
Secure Login and Registration
Read 'About Us' Content
Home Page
Product List
Product List per Categories
Filter Product Per Brand
Search Product
View Product
Shopping Cart
Place Order
View Order Details
Cancel Pending Order
Manage Account Details/Credentials
Logout
Page | 7
CHAPTER 3
3.1. CASE DIAGRAM

Client-Side
The use case diagrams are usually referred to as behaviour diagram used to
describe the actions of all user in a system.
Page | 8
3.2. 0 - LEVEL DATA FLOW DIAGRAM
It comes with incoming/outgoing indicators showing input and output data.
Page | 9
3.3. ENTITIES AND ATTRIBUTES
Page | 10
3.4. ENTITIES – RELATION DIAGRAM
Page | 11
CHAPTER - 4
4.1. PROJECT MODULES

Register Module: Provide a username and password which Customer will use
to login to the system.
Login Module: Gives access to the system.
Cosmetics Stock Module: Store the information about the cosmetics price,
amount and the expiry date of products.
Sales Module: Used for managing the sales report.
Suppliers Module: Used for managing the details of suppliers and their rates.
Product List Module: Displays the details of product present in the store.
Invoices Module: Generates and prints the invoice for the customer.
Dashboard Module: Displays the Customer’s details and the shop’s overall
detail as well.
4.2. GANTT CHART
Page | 12
CHAPTER 5
5.1. SCREENSHOTS
Admin Side
Login Page
Dashboard
Page | 13
Product List
Inventory List
Page | 14
Order List
Client List
Page | 15
Sales Report
Brand List
Page | 16
Category List
Settings
Page | 17
Admin Details
Page | 18
5.2. SCREENSHOTS
Client Side
Home Page
Login
Page | 19
New Account
Product Category Example: Skin Care
Page | 20
All Product Categories Detail
Product Sample
Page | 21
Related Product Suggestion
Option: Add to Cart
Page | 22
Cart List
Payment Checkout
Page | 23
Order List
Account Details
Page | 24
5.3. SCREENSHOTS
MySQL
Database: Brands
Database: Categories
Page | 25
Database: Clients
Database: Inventory
Page | 26
Database: Order List
Database: Products
Page | 27
Database: Sales
Database: System Info
Page | 28
5.4. Back Ends Representation
Coding in PHP
Footer
<script>
$(document).ready(function(){
window.viewer_modal = function($src = ''){
start_loader()
var t = $src.split('.')
t = t[1]
if(t =='mp4'){
var view = $("<video src='"+$src+"' controls autoplay></video>")
}else{
var view = $("<img src='"+$src+"' />")
}
$('#viewer_modal .modal-content video,#viewer_modal .modal-content
img').remove()
$('#viewer_modal .modal-content').append(view)
$('#viewer_modal').modal({
show:true,
backdrop:'static',
keyboard:false,
focus:true
})
end_loader()
}
window.uni_modal = function($title = '' , $url='',$size=""){
start_loader()
$.ajax({
url:$url,
error:err=>{
console.log()
alert("An error occured")
},
success:function(resp){
if(resp){
$('#uni_modal .modal-title').html($title)
$('#uni_modal .modal-body').html(resp)
if($size != ''){
Page | 29
$('#uni_modal .modal-dialog').addClass($size+' modal-dialog-
centered')
}else{
$('#uni_modal .modal-
dialog').removeAttr("class").addClass("modal-dialog modal-md modal-dialog-
centered")
}
$('#uni_modal').modal({
show:true,
backdrop:'static',
keyboard:false,
focus:true
})
end_loader()
}
}
})
}
window._conf = function($msg='',$func='',$params = []){
$('#confirm_modal
#confirm').attr('onclick',$func+"("+$params.join(',')+")")
$('#confirm_modal .modal-body').html($msg)
$('#confirm_modal').modal('show')
}
})
</script>
<footer class="main-footer text-sm">
<strong>Batch 2020-24, Gandhi Engineering College <?php echo date('Y')
?>.

</strong>
All rights reserved.
<div class="float-right d-none d-sm-inline-block">
<b><?php echo $_settings->info('short_name') ?> (by: <a
href="https://www.instagram.com/un.b.10.sam/" target="blank">Ghulam
Modassir</a> )</b> v1.0
</div>
</footer>
</div>



<script>
Page | 30
Header
<?php
require_once('sess_auth.php');
?>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title><?php echo $_settings->info('title') != false ? $_settings-
>info('title').' | ' : '' ?><?php echo $_settings->info('name') ?></title>
<link rel="icon" href="<?php echo validate_image($_settings->info('logo'))
?>" />



<link rel="stylesheet" href="<?php echo base_url ?>plugins/fontawesome-
free/css/all.min.css">


<link rel="stylesheet" href="<?php echo base_url ?>plugins/tempusdominus-
bootstrap-4/css/tempusdominus-bootstrap-4.min.css">

<link rel="stylesheet" href="<?php echo base_url ?>plugins/datatables-
bs4/css/dataTables.bootstrap4.min.css">
responsive/css/responsive.bootstrap4.min.css">
buttons/css/buttons.bootstrap4.min.css">

<link rel="stylesheet" href="<?php echo base_url
?>plugins/select2/css/select2.min.css">
<link rel="stylesheet" href="<?php echo base_url ?>plugins/select2-
bootstrap4-theme/select2-bootstrap4.min.css">

<link rel="stylesheet" href="<?php echo base_url ?>plugins/icheck-
</head>
Page | 31
Navigation
</style>

<aside class="main-sidebar sidebar-dark-pink elevation-4 sidebar-no-
expand">

<a href="<?php echo base_url ?>admin" class="brand-link bg-gradient-
pink text-sm">
<img src="<?php echo validate_image($_settings->info('logo'))?>"
alt="Store Logo" class="brand-image img-circle elevation-3" style="opacity:
.8;width: 1.5rem;height: 1.5rem;max-height: unset">
<span class="brand-text font-weight-light"><?php echo $_settings-
>info('short_name') ?></span>
</a>

<div class="sidebar os-host os-theme-light os-host-overflow os-host-
overflow-y os-host-resize-disabled os-host-transition os-host-scrollbar-
horizontal-hidden">
<div class="os-resize-observer-host observed">
<div class="os-resize-observer" style="left: 0px; right: auto;"></div>
</div>
<div class="os-size-auto-observer observed" style="height: calc(100% +
1px); float: left;">
<div class="os-resize-observer"></div>
</div>
<div class="os-content-glue" style="margin: 0px -8px; width: 249px;
height: 646px;"></div>
<div class="os-padding">
<div class="os-viewport os-viewport-native-scrollbars-invisible"
style="overflow-y: scroll;">
<div class="os-content" style="padding: 0px 8px; height: 100%; width:
100%;">

<div class="clearfix"></div>

<nav class="mt-4">
<ul class="nav nav-pills nav-sidebar flex-column text-sm nav-
compact nav-flat nav-child-indent nav-collapse-hide-child" data-
<script>
Page | 32
Client Index
<?php if($_settings->chk_flashdata('success')): ?>

<script>
alert_toast("<?php echo $_settings->flashdata('success') ?>",'success')
</script>
<?php endif;?>
<div class="card card-outline card-primary">
<div class="card-header">
<h3 class="card-title">List of Clients</h3>
</div>
<div class="card-body">
<div class="container-fluid">
<table class="table table-hover table-striped" id="list">
<colgroup>
<col width="5%">
<col width="15%">
<col width="35%">
<col width="20%">
<col width="10%">
<col width="15%">
</colgroup>
<thead>
<tr>
<th>#</th>
<th>Date Created</th>
<th>Name</th>
<th>Email</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$qry = $conn->query("SELECT
</script>
Page | 33
Coding in PHP
Admin Side
Sales Index
<style>
table td,table th{
padding: 3px !important;
}
</style>
<?php
$date_start = isset($_GET['date_start']) ? $_GET['date_start'] : date("Y-m-
d",strtotime(date("Y-m-d")." -7 days")) ;
$date_end = isset($_GET['date_end']) ? $_GET['date_end'] : date("Y-m-d") ;
?>
<div class="card card-primary card-outline">
<h5 class="card-title">Sales Report</h5>
</div>
<form id="filter-form">
<div class="row align-items-end">
<div class="form-group col-md-3">
<label for="date_start">Date Start</label>
<input type="date" class="form-control form-control-sm"
name="date_start" value="<?php echo date("Y-m-d",strtotime($date_start))
?>">
</div>
<label for="date_start">Date End</label>
<input type="date" class="form-control form-control-sm"
name="date_end" value="<?php echo date("Y-m-d",strtotime($date_end)) ?>">
</div>
<button class="btn btn-flat btn-block btn-primary btn-sm"><i
class="fa fa-filter"></i> Filter</button>
</div>
<button class="btn btn-flat btn-block btn-success btn-sm"
type="button" id="printBTN"><i class="fa fa-print"></i> Print</button>
</div>
</div>
</form>
<hr>
Page | 34
<div id="printable">
<div class="row row-cols-2 justify-content-center align-items-center"
id="print_header" style="display:none">
<div class="col-1">
<img src="<?php echo validate_image($_settings->info('logo')) ?>"
alt="<?php echo $_settings->info('short_name') ?>" width="75px"
heigth="75px">
</div>
<div class="col-7">
<h4 class="text-center m-0"><?php echo $_settings->info('name')
?></h4>
<h3 class="text-center m-0"><b>Sales Report</b></h3>
</script>
Page | 35
System Info Index

<script>
</script>
<?php endif;?>
<style>
img#cimg{
height: 15vh;
width: 15vh;
object-fit: cover;
border-radius: 100% 100%;
}
img#cimg2{
height: 50vh;
width: 100%;
object-fit: contain;
/* border-radius: 100% 100%; */
}
</style>
<div class="col-lg-12">
<h5 class="card-title">System Information</h5>

</div>
</script>
Page | 36
User Index
<?php
$user = $conn->query("SELECT * FROM users where id ='".$_settings-
>userdata('id')."'");
foreach($user->fetch_array() as $k =>$v){
$meta[$k] = $v;
}
?>
<script>
</script>
<?php endif;?>
<div id="msg"></div>
<form action="" id="manage-user">
<input type="hidden" name="id" value="<?php echo
$_settings->userdata('id') ?>">
<div class="form-group">
<label for="name">First Name</label>
<input type="text" name="firstname"
id="firstname" class="form-control" value="<?php echo
isset($meta['firstname']) ? $meta['firstname']: '' ?>" required>
</div>
<label for="name">Last Name</label>
<input type="text" name="lastname"
id="lastname" class="form-control" value="<?php echo isset($meta['lastname'])
? $meta['lastname']: '' ?>" required>
</div>
<label for="username">Username</label>
<input type="text" name="username"
id="username" class="form-control" value="<?php echo
isset($meta['username']) ? $meta['username']: '' ?>" required
autocomplete="off">
</div>
<label for="password">Password</label>
Page | 37
<input type="password" name="password"
id="password" class="form-control" value="" autocomplete="off">
<small><i>Leave this blank if you dont want to
change the password.</i></small>
</div>
<label for="" class="control-
label">Avatar</label>
<div class="custom-file">
<input type="file" class="custom-file-input rounded-
circle" id="customFile" name="img" onchange="displayImg(this,$(this))"
accept="image/png, image/jpeg">
<label class="custom-file-label"
for="customFile">Choose file</label>
</div>
</div>
<div class="form-group d-flex justify-content-
center">
<img src="<?php echo
validate_image(isset($meta['avatar']) ? $meta['avatar'] :'') ?>" alt="" id="cimg"
class="img-fluid img-thumbnail">
</div>
</form>
</div>
</div>
<div class="card-footer">
<div class="col-md-12">
<div class="row">
<button class="btn btn-sm btn-primary"
form="manage-user">Update</button>
</div>
</div>
</div>
</div>
<style>
img#cimg{
height: 15vh;
width: 15vh;
object-fit: cover;
border-radius: 100% 100%;
}
</style>
<script>
Page | 38
Login
<style>
#uni_modal .modal-content>.modal-footer,#uni_modal .modal-
content>.modal-header{
display:none;
}
</style>
<div class="row">
<h3 class="float-right">
<button type="button" class="close" data-dismiss="modal" aria-
label="Close">
<span aria-hidden="true">×</span>
</button>
</h3>
<div class="col-lg-12">
<h3 class="text-center">Login</h3>
<hr>
<form action="" id="login-form">
<label for="" class="control-label">Email</label>
<input type="email" class="form-control form" name="email"
required>
</div>
<label for="" class="control-label">Password</label>
<input type="password" class="form-control form"
name="password" required>
</div>
<div class="form-group d-flex justify-content-between">
<a href="javascript:void()" id="create_account">Create
Account</a>
<button class="btn btn-primary btn-flat">Login</button>
</div>
</form>
</div> </div> </div>
<script>
Page | 39
Coding in CSS & JS

Assests
Styles
@charset "UTF-8";
/*!
* Start Bootstrap - Shop Homepage v5.0.1
(https://startbootstrap.com/template/shop-homepage)
* Copyright 2013-2021 Start Bootstrap
* Licensed under MIT (https://github.com/StartBootstrap/startbootstrap-shop-
homepage/blob/master/LICENSE)
*/
/*!
* Bootstrap v5.0.1 (https://getbootstrap.com/)
* Copyright 2011-2021 The Bootstrap Authors
* Copyright 2011-2021 Twitter, Inc.
* Licensed under MIT
(https://github.com/twbs/bootstrap/blob/main/LICENSE)
*/
:root {
--bs-blue: #0d6efd;
--bs-indigo: #6610f2;
--bs-purple: #6f42c1;
--bs-pink: #d63384;
--bs-red: #dc3545;
--bs-orange: #fd7e14;
--bs-yellow: #ffc107;
--bs-green: #198754;
--bs-teal: #20c997;
--bs-cyan: #0dcaf0;
--bs-white: #fff;
--bs-gray: #6c757d;
--bs-gray-dark: #343a40;
Full Code Link below

https://drive.google.com/file/d/11JTCj3NY7LB0BXiAmsd83sp4399gG7ve/vie
w?usp=drivesdk
Page | 40
Coding in MySQL
Backend
Database
-- phpMyAdmin SQL Dump

-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 17, 2022 at 09:47 AM
-- Server version: 10.4.19-MariaDB
-- PHP Version: 8.0.7
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS
*/;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION
*/;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `cbpos_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `brands`
--
CREATE TABLE `brands` (

ìd` int(30) NOT NULL,
`name` varchar(250) NOT NULL,
`description` text DEFAULT NULL,
Page | 41
ìmage_path` text DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1,
`delete_flag` tinyint(1) NOT NULL DEFAULT 0,
`date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `brands`
--
INSERT INTO `brands` (ìd`, `name`, `description`, ìmage_path`, `status`,

`delete_flag`, `date_created`) VALUES
(1, 'L’Oreal', 'L’Oreal manufactures and markets a wide range of skincare,
makeup, fragrance, and hair care products',
'uploads/brands/1.jpg?v=1645066502', 1, 0, '2022-02-17 10:55:02'),
(2, 'test', 'test', NULL, 1, 1, '2022-02-17 10:57:41'),
(3, 'Nivea', 'Nivea manufactures and markets skin, sun, lip and deodorant
products', 'uploads/brands/3.jpg?v=1645066772', 1, 0, '2022-02-17 10:59:32'),
(4, 'Olay', 'Olay manufactures and markets face and skin care products',
'uploads/brands/4.jpg?v=1645066818', 1, 0, '2022-02-17 11:00:18'),
(5, 'LUX', 'A global personal care brand by Unilever, Lux product categories
include soaps, shower gels, bath products, shampoos, and conditioners. Lux is a
strong advocate of sustainable causes and is sold in more than 100 countries
worldwide.', 'uploads/brands/5.jpg?v=1645066872', 1, 0, '2022-02-17
11:01:12'),
(6, 'AVON', 'Avon is a direct sales company operating in the skin, body,
fragrance, make-up, sun care and fashion markets. A leading company within
the direct sales market, Avon has millions of beauty advisors worldwide and
recently moved its headquarters from the U.S. to the UK.',
'uploads/brands/6.jpg?v=1645066909', 1, 0, '2022-02-17 11:01:49');
-- --------------------------------------------------------
--
-- Table structure for table `cart`
--
CREATE TABLE `cart` (

`client_id` int(30) NOT NULL,
ìnventory_id` int(30) NOT NULL,
`price` double NOT NULL,
`quantity` int(30) NOT NULL,
Page | 42
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (

`category` varchar(250) NOT NULL,
`description` text DEFAULT NULL,
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` (ìd`, `category`, `description`, `status`,

`delete_flag`, `date_created`) VALUES
--
-- Table structure for table `clients`
--
CREATE TABLE `clients` (

`firstname` varchar(250) NOT NULL,
`lastname` varchar(250) NOT NULL,
`gender` varchar(20) NOT NULL,
`contact` varchar(15) NOT NULL,
èmail` varchar(250) NOT NULL,
`password` text NOT NULL,
`default_delivery_address` text NOT NULL,
--
Page | 43
-- Dumping data for table `clients`
--
INSERT INTO `clients` (ìd`, `firstname`, `lastname`, `gender`, `contact`,

èmail`, `password`, `default_delivery_address`, `status`, `delete_flag`,
`date_created`) VALUES
(2, 'Samantha Jane', 'Miller', 'Female', '09123456789', 'sam23@sample.com',
'45bff2a14658fc9b21c6e5e9bf75186b', 'Sample Address', 1, 0, '2022-02-17
14:24:00');
-- --------------------------------------------------------
--
-- Table structure for table ìnventory`
--
CREATE TABLE ìnventory` (

`variant` text NOT NULL,
`product_id` int(30) NOT NULL,
`quantity` double NOT NULL,
`price` float NOT NULL,
`date_created` datetime NOT NULL DEFAULT current_timestamp(),
`date_updated` datetime DEFAULT NULL ON UPDATE current_timestamp()
--
-- Dumping data for table ìnventory`
--
INSERT INTO ìnventory` (ìd`, `variant`, `product_id`, `quantity`, `price`,

`date_created`, `date_updated`) VALUES
(1, 'Variant 1', 1, 10, 155, '2022-02-17 11:57:52', NULL),
(2, 'Variant 2', 1, 5, 200, '2022-02-17 12:01:15', NULL),
(3, 'Variant 3', 1, 10, 1055.58, '2022-02-17 12:04:15', NULL),
(4, 'Variant 1', 3, 25, 250, '2022-02-17 13:22:54', NULL),
(5, 'Variant 2', 3, 25, 300, '2022-02-17 13:23:05', NULL),
(6, 'Variant 1', 4, 100, 350, '2022-02-17 16:28:14', NULL);
-- --------------------------------------------------------
--
-- Table structure for table òrders`
Page | 44
--
CREATE TABLE òrders` (

`ref_code` varchar(100) NOT NULL,
`client_id` int(30) NOT NULL,
`delivery_address` text NOT NULL,
`payment_method` varchar(100) NOT NULL,
òrder_type` tinyint(1) NOT NULL COMMENT '1= pickup,2= deliver',
àmount` double NOT NULL,
`status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '0 = pending,\r\n1=
Packed,\r\n2 = Out for Delivery,\r\n3=Delivered,\r\n4=cancelled',
`paid` tinyint(1) NOT NULL DEFAULT 0,
`date_created` datetime NOT NULL DEFAULT current_timestamp(),
`date_updated` datetime DEFAULT NULL ON UPDATE current_timestamp()
--
-- Dumping data for table òrders`
--
INSERT INTO òrders` (ìd`, `ref_code`, `client_id`, `delivery_address`,

`payment_method`, òrder_type`, àmount`, `status`, `paid`, `date_created`,
`date_updated`) VALUES
(3, '20220200001', 2, 'Sample Address', 'cod', 0, 900, 4, 0, '2022-02-17
14:51:58', '2022-02-17 15:04:38'),
(4, '20220200002', 2, 'Sample Address', 'Online Payment', 0, 1800, 3, 1, '2022-
02-17 15:26:17', '2022-02-17 15:35:45'),
(5, '20220200003', 2, 'Sample Address', 'cod', 0, 500, 3, 1, '2022-02-17
15:32:52', '2022-02-17 15:35:32');
-- --------------------------------------------------------
--
-- Table structure for table òrder_list`
--
CREATE TABLE òrder_list` (

òrder_id` int(30) NOT NULL,
ìnventory_id` int(30) NOT NULL,
`quantity` int(30) NOT NULL,
`price` double NOT NULL,
Page | 45
`total` double NOT NULL
--
-- Dumping data for table òrder_list`
--
INSERT INTO òrder_list` (ìd`, òrder_id`, ìnventory_id`, `quantity`, `price`,

`total`) VALUES
(4, 3, 3, 3, 300, 900),
(5, 4, 3, 4, 300, 1200),
(6, 4, 1, 3, 200, 600),
(7, 5, 3, 2, 250, 500);
CREATE TABLE `products` (

`brand_id` int(30) NOT NULL,
`category_id` int(30) NOT NULL,
`name` varchar(250) NOT NULL,
`specs` text NOT NULL,
-- Dumping data for table `products`

-- --------------------------------------------------------
ALTER TABLE òrders`
ADD CONSTRAINT òrders_ibfk_1` FOREIGN KEY (`client_id`)
REFERENCES `clients` (ìd`) ON DELETE CASCADE;
--
-- Constraints for table òrder_list`
--
ALTER TABLE òrder_list`
ADD CONSTRAINT òrder_list_ibfk_1` FOREIGN KEY (òrder_id`)
REFERENCES òrders` (ìd`) ON DELETE CASCADE,
ADD CONSTRAINT òrder_list_ibfk_2` FOREIGN KEY (ìnventory_id`)
REFERENCES ìnventory` (ìd`) ON DELETE CASCADE;
Page | 46
CHAPTER 6
Conclusion & Future Scope
The future of Indian cosmetics industry

Recommendations for newcomers
For many years, the Indian beauty industry has been one of the fastest-growing
markets in the world. With over a billion people and rising disposable income,
India is considered one of the most promising markets for global companies
looking to expand their reach.
However, despite this growth, there are still challenges facing Indian companies
seeking to enter this market. For example, there has been a significant amount
of consolidation in the Indian beauty industry over recent years as large
multinational corporations have attempted to take advantage of the lucrative
market. This has resulted in an increasingly competitive landscape where many
smaller players struggle to remain competitive and continue to grow their
businesses.
To help navigate this increasingly competitive landscape, this article will

outline some key recommendations for newcomers looking to enter or expand
their presence within the Indian beauty industry.
The future of Indian cosmetics industry is bright, but it’s up to new entrants to
make sure they get a fair shot at success.
A few years ago, the Indian beauty market was dominated by multinationals,
but that’s changing.
Start small—think big but start small.
Don’t be afraid to experiment—try something new!
Focus on the quality of your product—the best way to stand out is through
superior quality.
The Indian cosmetics industry is growing at an alarming rate, thanks to the

country’s growing middle class. However, this growth has come with a price:
the industry is plagued by problems that include low production value, poor
product quality, and a lack of transparency.
Page | 47
As a result of these problems, many newcomers have been put off from entering
the industry. But as we see with other industries in India—such as software or
engineering—there are ways for new players to make an impact on the market
without investing significant amounts of money. In this article, we’ll give you
some recommendations for newcomers interested in entering the Indian
cosmetics industry.
Focus on local brands: India is not like other countries where most people are
used to Western brands and don’t know how to find local ones.
The Indian cosmetics industry is going to be one of the most exciting industries
to watch over the next few years. With a rapidly growing population and a
growing middle class, India’s cosmetics market will continue to grow at an
astounding rate.
But this growth comes with challenges as well. There is a lot of competition out
there, and it’s difficult for new entrants to make their mark on this market.
That’s where we come in—we’ve got some recommendations for what you can
do if you’re interested in getting involved in the Indian makeup industry.
First of all, if you want to take advantage of the huge opportunity that’s coming
up, you need to get your products into stores as soon as possible. The best way
to do this is by starting an online store or buying from other online retailers like
Amazon. This will allow you to reach more consumers and sell more products
at lower prices than if you try selling directly from your own website or store.
It also helps if your products are cruelty-free, which means they don’t contain
any animal products or byproducts like test tubes or animal hair.
There aren’t many barriers to entry when it comes to starting
India is one of the largest markets for cosmetics. The industry is expected to
grow at a CAGR of 6.7% over the next five years, according to Euromonitor
International. This growth has been driven by increasing consumer spending
power, rising disposable income levels and growing awareness about skin care
products.
In fact, the cosmetics industry in India is expected to show strong signs of

expansion during the next five years. The market size is expected to reach $1
billion by 2024 .
The cosmetics market in India is currently dominated by foreign brands but due
to its huge population base; it has also attracted domestic brands
Page | 48
CHAPTER 7
References
1. Dr. K.M. Tajne et.al. (2014), ―Beauty Product Website‖, International Journal of
Innovative Research in Science, Engineering and Technology, Vol. 3, Issue 11, pp
17632-17634.
2. Eng. Pshtiwan N. Shakor et.al. (2011), ―Glass Fiber Reinforced Concrete Use in
Construction‖, International Journal of Technology and Engineering System,
Vol.2. No.2.
3. Yogesh Iyer Murthy et. al. (2012), ―Performance of Glass Fiber Reinforced
Concrete‖, International Journal of Engineering and Innovative Technology, Vol-1,
Issue 6, pp. 246- 248.
4. Wakchaure M. R. et. al. (2014), ―Comparison of compressive strength and flexural
shear strength for hybrid fibre reinforced with the controlled concrete‖,
International Journal of Engineering and Technical Research, Volume-02, Issue-09,
pp 172-175.
5. ―Glass Fibre Reinforced Concrete‖ http://www.engineeringcivil.com/glass-fibre
reinforced-concrete.html
6. Komal Chawla et.al. (2013), ―Studies on Glass Fiber Reinforced Concrete
composites‖, International journal of structural and civil engineering research, Vol.
2, No. 3,pp 176-182.
7. Preetha V. et. al. (2014), ―Strength properties of steel fiber and glass fiber
composites‖, International journal of civil engineering and technology, Volume 5,
Issue 12, pp. 188-193.
8. Liaqat A. Qureshi et.al. (2013), ―An Investigation On Strength Properties Of Glass
Fiber Reinforced Concrete‖, International Journal of Engineering Research &
Technology, Vol.2 Issue 4, pp 2567- 2572.
9. V. Muthukrishnan et. al. (2013), ―Mechanical Properties of Hybrid Fiber
Reinforced Concrete With Steel And Synthetic Fiber‖, International Journal of
Engineering Sciences & Research Technology, pp 899-902.
10. IS 8112-1989, ―43 Grade Ordinary Portland Cement‖, Bureau of Indian Standard,
New Delhi.
11. IS 10262-2009, ―Code for Concrete Mix Proportioning‖, Bureau of Indian
Standard, NewDelhi.
12. IS 456-2000, ―Plain and Reinforced Concrete Code or Practice‖ (Fourth Revision),
Bureauof Indian Standard, New Delhi.
13. IS 383-1970, ―Specification for Coarse and Fine Aggregate from Natural Sources
for Concrete‖ (Second Revision), Bureau of Indian Standard, New Delhi.
14. IS 9103-1999, ―Indian Standard Concrete Admixture Specification‖, Bureau of
Indian Standard, New Delhi.
15. Shetty M. S., (2012), ―Concrete Technology‖, S. Chand & Company ltd. New Delhi.
16. IS 516-1959, ―Methods of Tests for Strength of Concrete‖, Bureau of Indian
Standard, New Delhi.
Page | 49

Mazhar P.r.o.ject

Uploaded by

Copyright:

Available Formats

Mazhar P.r.o.ject

Uploaded by

Document Information

Original Title

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

Mazhar P.r.o.ject

Uploaded by

Copyright:

Available Formats

COSMETICS AND BEAUTY PRODUCTS WEBSITE

Md Mazhar Alam (2001292206)

In partial fulfillment of the award of the degree of

GANDHI ENGINEERING COLLEGE, BHUBANESWAR

Prof. Himanshu Bhusan Mohapatra

DATE: Md Mazhar Alam

Chapter 2: Requirement Analysis and System 7

Chapter 3: System Design

Chapter 4: Implementation, Testing, and Maintenance

Chapter 5: Results and Discussions

Chapter 6: Future Scope 47-48

1.1. INTRODUCTION TO THE PROJECT

1.2. OBJECTIVE OF PROJECT

1.4. ADVANTAGES OF PROPOSED SYSTEM

XAMPP v3.3.0 as my local webserver that has a PHP Version 8.0.7

3.1. CASE DIAGRAM

4.1. PROJECT MODULES

4.2. GANTT CHART

Product Category Example: Skin Care

Option: Add to Cart

Database: System Info

<?php if($_settings->chk_flashdata('success')): ?>

<?php if($_settings->chk_flashdata('success')): ?>

Coding in CSS & JS

Full Code Link below

-- phpMyAdmin SQL Dump

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE `brands` (

INSERT INTO `brands` (`id`, `name`, `description`, `image_path`, `status`,

CREATE TABLE `cart` (

CREATE TABLE `categories` (

INSERT INTO `categories` (`id`, `category`, `description`, `status`,

CREATE TABLE `clients` (

INSERT INTO `clients` (`id`, `firstname`, `lastname`, `gender`, `contact`,

CREATE TABLE `inventory` (

INSERT INTO `inventory` (`id`, `variant`, `product_id`, `quantity`, `price`,

CREATE TABLE `orders` (

INSERT INTO `orders` (`id`, `ref_code`, `client_id`, `delivery_address`,

CREATE TABLE `order_list` (

INSERT INTO òrder_list` (ìd`, òrder_id`, ìnventory_id`, `quantity`, `price`,

CREATE TABLE `products` (

-- Dumping data for table `products`

Conclusion & Future Scope

The future of Indian cosmetics industry

To help navigate this increasingly competitive landscape, this article will

Start small—think big but start small.

Don’t be afraid to experiment—try something new!

The Indian cosmetics industry is growing at an alarming rate, thanks to the

There aren’t many barriers to entry when it comes to starting

In fact, the cosmetics industry in India is expected to show strong signs of

You might also like