Your All-in-One AI-Powered Toolkit for Academic Success.

+13062052269

info@desklib.com

Available 24*7 on WhatsApp / Email

Company

Tools

Support

E-Commerce Website Invoice Generation

Verified

Added on 2019/10/16

AI Summary

This is an ecommerce website that allows users to view their cart and order history. It includes a table to display the products, prices, quantities, and subtotal for each product in the cart. The total cost is also displayed at the bottom of the page. The website uses PHP sessions to store user data and calculates the total cost based on the quantity and price of each product.

Contribute Materials

Your contribution can guide someone’s learning journey. Share your documents today.

Garden Center

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.

💎 Get Pro

Contents
1. Implementation Discussion
2. Code Snippets
3. Limitations
4. References

Implementation:
The garden enter online shopping website is built using the technologies like HTML, CSS, PHP,
JavaScript. The SQLite is used to store the data of plants like the price size and description of
each plant. The solution ha 3 pages catalog, cart, invoice.
Catalog:
The catalog page is used to display the listing of plants retrieved from database.The catalog
listing includes the name, description , price , size and image of each plant with add to cart
button which adds the product to the current shopping basket. Each product has three sizes.
Cart:
The cart page shows the list of products added to the cart . te cart page also allows to add or
remove the quantity of products. We can also use multiple currencies to buy the product. The
cart uses the session global variable of the PHP in order to persist the cart data.
Invoice:
The invoice page shows the list of products we have purchased from the website including the
email of the customer. To purchase the customer have submit the email.
Currency:
The three currency option is given to the user to select in the cart page.
Database:
Two database table is created in the database to store the catalog data.
 Plants :
Plants table is used to store the plant name , description and image.
 Plant Sizes:
Plant sizes table store the plant_is, price and size of the plant.

Code Snippets:
DB.php
<?php
Class DB {
private $dbpath = 'plants.db';
private $con;
const PATH_TO_SQLITE_FILE = '../plants.db';
public function __construct(){
$this->con = new PDO("sqlite:". $this->dbpath); //initializing
mysql db conection
//var_dump($d =$this->con->query("SELECT * FROM
plants")->fetchAll(PDO::FETCH_ASSOC));exit;
}
public function getProducts(){
// for getting all saved products from db
$query="SELECT * , plant_sizes.id as size_id FROM plants
LEFT OUTER JOIN plant_sizes ON plants.id=plant_sizes.plant_id";
$q = $this->con->prepare($query);

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

💎 Try AI Paraphraser

$q->execute();
$data = $q->fetchAll(PDO::FETCH_ASSOC);
return $data;
}
}
Footer.php
<footer style="position: absolute; bottom: 0; width: 100%; height:
50px; background-color:#7979ff">
<div class="container">
<span style="text-align: center; padding: 10px; color: white;">
© Garden Center – All Rights Reserved
</span>
<span class="pull-right" style="text-align: center; color:
white;font-size:32px;">
<i class="fa fa-envelope"></i>
<i class="fa fa-twitter"></i>
<i class="fa fa-facebook"></i>

<i class="fa fa-youtube"></i>
</span>
</div>
</footer>
<script src="./js/jquery-2.2.4.min.js"></script>
<script src="./js/bootstrap.min.js" type="text/javascript"></script>
<script src="./js/scripts.js"></script>
</body>
</html>
Header.php
<?php
include './DB.php';
$obj = new DB;
//$categories = $obj->getCategories();
//$sub_categories = $obj->getSubCategories();
?>
<!DOCTYPE html>
<html lang="en" style="position: relative; min-height: 100%;">
<head>

<title>Garden Center</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-
scale=1">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/font-
awesome/4.7.0/css/font-awesome.min.css">
<link href="./css/bootstrap.min.css" rel="stylesheet" type="text/css"/>
<link href="https://fonts.googleapis.com/css?family=Gentium+Basic|
Merienda|Gudea" rel="stylesheet">
<style>
body{
font-family: 'Gudea', sans-serif;
}
.logo-text {
font-family: 'Merienda', cursive;
color: #fff;
font-size: 32px;
margin-top: 5px;
}
a{
font-weight:bold;
}

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.

💎 Get Pro

</style>
</head>
<body style="padding-top: 50px; margin-bottom: 60px;">
<nav class="navbar navbar-default navbar-fixed-top navbar-inverse">
<div class="container-fluid">

<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-
toggle="collapse"
data-target="#bs-example-navbar-collapse-1"
aria-expanded="false">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" style="padding: 10px" href="/">
<p class="logo-text">Garden Center</p>
</a>
</div>
<div class="collapse navbar-collapse" id="bs-example-navbar-
collapse-1">

<ul class="nav navbar-nav">
<li class="active"><a href="index.php" > <i class="fa fa-
cubes"></i> Catalog</a></li>
<li><a href="cart.php"> <i class="fa
fa-shopping-cart"></i> Cart</a></li>
</ul>
</div>
</div>
</nav>
Index.php
<?php
session_start();
include 'include/Header.php' ;
$products=[];
$products = $obj->getProducts();
?>
<section class="col-sm-10 col-sm-offset-1 col-xs-12">
<div class="row">
<div class="col-sm-12">
<h3> Plants Catalog</h3>

</div>
<div class="col-md-12">
<?php
if(!empty($products)):
foreach ($products as $key => $pro) :
?>
<div class="col-sm-6 col-md-4">
<div class="thumbnail" >
<h2 class="text-center"><span class="label label-info"><?=$pro['name']?
></span></h2>
<img src="<?=$pro['image']?>" class="img-responsive centered col-sm-6">
<div class="caption">
<div class="row">
<div class="col-md-6 col-xs-6">
<h5><?=$pro['desc']?></h5>
</div>
<div class="col-md-6 col-xs-6 price">
<h3>
<label>£<?=$pro['price']?></label></h3>
</div>
</div>
<p> <h2> <strong>Size:</strong> <?=$pro['size']?> </h2> </p>
<div class="row">
<div class="col-md-12">

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

💎 Try AI Paraphraser

</div>
</section>
<?php
include 'include/Footer.php' ;
?>
Cart.php
<?php
session_start();
if(!isset($_SESSION['cart'])){
$_SESSION['cart'] = [];
$_SESSION['currencies']=[
'Euro' => ['sign'=>'€', 'rate'=>'1.16'],
'USD' => ['sign'=>'$', 'rate'=>'1.30'],
'Pound' => ['sign'=>'£', 'rate'=>'1']
];
$_SESSION['currency'] = 'Pound';
}
if(isset($_GET['currency'])){
$_SESSION['currency'] = $_GET['currency'];
}
foreach ($_SESSION['currencies'] as $key => $currency) {
if($key == $_SESSION['currency']){

$symbol = $currency['sign'];
$rate = $currency['rate'];
}
}
if(isset($_POST['size_id'])){
$cart = $_SESSION['cart'];
$exist = false;
foreach ($cart as $key => $value) {
if ($value['size_id'] == $_POST['size_id']) {
$cart[$key]['qty']++;
$exist = true;
}
}
if(!$exist){
$product = $_POST;
$product['qty']=1;
$cart[] = $product; // pushing product to cart
}
$_SESSION['cart']=$cart;
}
if(isset($_REQUEST['action']) && isset($_REQUEST['size_id'])){
$action=$_REQUEST['action'];
$size = $_REQUEST['size_id'];

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.

💎 Get Pro

$cart = $_SESSION['cart'];
if($action == 'add'){
foreach ($cart as $key => $item) {
if($item['size_id'] == $size){
$cart[$key]['qty']++;
}
}
} elseif($action == 'sub'){
foreach ($cart as $key => $item) {
if($item['size_id'] == $size){
if($item['qty'] == 1){
unset($cart[$key]);
}
else
$cart[$key]['qty']--;
}
}
}elseif($action == 'del'){
foreach ($cart as $key => $item) {
if($item['size_id'] == $size){
unset($cart[$key]);
}
}
}

$_SESSION['cart'] = $cart;
header('loctaion: cart.php');
}
include 'include/Header.php' ;
$products = $_SESSION['cart'];
?>
<section class="col-sm-10 col-sm-offset-1 col-xs-12">
<div class="row">
<div class="col-sm-12">
<h3> Shopping Cart </h3>
</div>
<div class="col-md-12">
<table id="cart" class="table table-hover table-condensed">
<thead>
<tr>
<th style="width:50%">Product</th>
<th style="width:10%">Price</th>
<th style="width:8%">Qty</th>
<th style="width:22%" class="text-center">Subtotal</th>
<th style="width:10%"></th>
</tr>

</thead>
<tbody>
<?php
$total =0;
if(!empty($products)):
foreach ($products as $key => $pro) :
?>
<tr>
<td data-th="Product">
<div class="row">
<div class="col-sm-2 hidden-xs"><img src="<?=$pro['image']?>" alt="..."
class="img-responsive"/></div>
<div class="col-sm-10">
<h4 class="nomargin"><?=$pro['name']?>
<small><?=$pro['size']?></small></h4>
<p><?=$pro['desc']?></p>
</div>
</div>
</td>
<td data-th="Price"> <strong> <?= $symbol .( $pro['price'] * $rate)?>
</strong> </td>
<td data-th="Quantity">
<a href="cart.php?action=sub&size_id=<?=$pro['size_id']?>" class="btn
btn-success">-</a>
<strong><?=$pro['qty']?></strong>

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

💎 Try AI Paraphraser

<a href="cart.php?action=add&size_id=<?=$pro['size_id']?>" class="btn
btn-success">+</a>
<?php
$total += $pro['qty'] * $pro['price'];
?>
</td>
<td data-th="Subtotal" class="text-center">
<strong>
<?php
$total += $pro['qty'] * $pro['price'] * $rate;
echo $symbol;
echo $pro['qty'] * $pro['price'] * $rate;
?>
</strong>
</td>
<td class="actions" data-th="">
<button class="btn btn-info btn-sm"><i class="fa fa-refresh"></i></button>
<a href="cart.php?action=del&size_id=<?=$pro['size_id']?>" class="btn btn-
danger"><i class="fa fa-trash-o"></i></a>
</td>
</tr>
</tbody>
<?php
endforeach;
endif;
?>

<tfoot>
<tr class="visible-xs">
<td class="text-center"><strong>Total <?= $symbol . ' '.
$total?></strong></td>
</tr>
<tr>
<td><a href="index.php" class="btn btn-warning"><i class="fa fa-angle-
left"></i> Continue Shopping</a></td>
<td colspan="2" class="hidden-xs"></td>
<td class="hidden-xs text-center"><strong>Total <?= $symbol . ' '.
$total?></strong></td>
<td>
</td>
</tr>
<tr>
<td></td>
<td colspan="2" class="hidden-xs">
<a href="#" class="btn btn-warning"></i> <strong>Currency</strong> </a>
<?php
foreach ($_SESSION['currencies'] as $key => $cur) {
echo '<a href="cart.php?currency='.$key.'" class="btn btn-primary">'.
$cur['sign'] .'</a>';
}
?>
</td>
<td class="hidden-xs text-center"><strong></td>
<td></td>

</tr>
<tr>
<form action="invoice.php" method="post">
<td></td>
<td colspan="2" class="hidden-xs">
<strong>Email:</strong>
<input type="email" class="form-control" name="email" id="" required>
</td>
<td class="hidden-xs text-center"></td>
<td>
<button type="submit" href="#" class="btn btn-success btn-
block">Checkout <i class="fa fa-angle-right"></i></button>
</td>
</form>
</tr>
</tfoot>
</table>
</div>
</div>
</section>

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.

💎 Get Pro

<?php
include 'include/Footer.php' ;
?>
Invoice.php
<?php
session_start();
if(!isset($_SESSION['cart']) || empty($_SESSION['cart'] || !isset($_POST['email']))){
header('location:cart.php');
}
foreach ($_SESSION['currencies'] as $key => $currency) {
if($key == $_SESSION['currency']){
$symbol = $currency['sign'];
$rate = $currency['rate'];
}
}
include 'include/Header.php' ;
$products = $_SESSION['cart'];

?>
<section class="col-sm-10 col-sm-offset-1 col-xs-12">
<div class="row">
<div class="col-sm-12">
<h2> Thanks for Shopping with us</h2>
</div>
<div class="col-md-12">
<table id="cart" class="table table-hover table-condensed">
<thead>
<tr>
<th style="width:50%">Email : <?=$_POST['email']?></th>
<th style="width:10%"></th>
<th style="width:8%"></th>
<th style="width:22%" class="text-center"></th>
</tr>
<tr>
<th style="width:50%">Product</th>
<th style="width:10%">Price</th>
<th style="width:8%">Qty</th>
<th style="width:22%" class="text-center">Subtotal</th>
</tr>
</thead>
<tbody>
<?php

$total =0;
if(!empty($products)):
foreach ($products as $key => $pro) :
?>
<tr>
<td data-th="Product">
<div class="row">
<div class="col-sm-2 hidden-xs"><img src="<?=$pro['image']?>" alt="..."
class="img-responsive"/></div>
<div class="col-sm-10">
<h4 class="nomargin"><?=$pro['name']?>
<small><?=$pro['size']?></small></h4>
<p><?=$pro['desc']?></p>
</div>
</div>
</td>
<td data-th="Price"><?= $symbol .( $pro['price'] * $rate)?></td>
<td data-th="Quantity">
<strong><?=$pro['qty']?></strong>
</td>
<td data-th="Subtotal" class="text-center"><?php
$total += $pro['qty'] * $pro['price'] * $rate;
echo $pro['qty'] * $pro['price'] * $rate;
?></td>

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

💎 Try AI Paraphraser

</tr>
</tbody>
<?php
endforeach;
endif;
?>
<tfoot>
<tr class="visible-xs">
<td class="text-center"><strong>Total <?= $symbol . ' '.
$total?></strong></td>
</tr>
<tr>
<td></td>
<td colspan="2" class="hidden-xs"></td>
<td class="hidden-xs text-center"><strong>Total <?= $symbol . ' '.
$total?></strong></td>
</tr>
</tfoot>
</table>
</div>
</div>
</section>
<?php

include 'include/Footer.php' ;
session_destroy();
?>
Limitations:
The website is a very basic version of an ecommerce website. It doenot have proper login and
registration.
No Payment facility available.
No safe for secure transactions of payments
No wish list section.
Design of the site can be improved.
References:
Rhsplants.co.uk. (2019). RHS Plants. [online] Available at: http://www.rhsplants.co.uk/ [Accessed 7 Apr.
2019].

1 out of 24

+13062052269

info@desklib.com

E-Commerce Website Invoice Generation

Contribute Materials

Secure Best Marks with AI Grader

Paraphrase This Document

Secure Best Marks with AI Grader

Paraphrase This Document

Secure Best Marks with AI Grader

Paraphrase This Document

Secure Best Marks with AI Grader

Paraphrase This Document

Related Documents

Result Page with Polls and Questions Count

Desklib - Online Library for Study Material with Solved Assignments, Essays, Dissertations