Git-Project1/cart.php at master · Jaideep-97/Git-Project1 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106

<?php

require 'includes/common.php';

?>
/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

 <html>
    <head>

        <title>cart</title>
        <link href="style.css" rel="stylesheet" type="text/css"/>
        <style>
            body{
                width: 100%;
                height: 100%;
                margin: 0;
            }
            a{
                text-decoration: none;
                background-color: transparent;
                color: #ededed
            }
            td{
                text-align: center;
            }
            th{
                text-align: center;
            }
        </style>
        <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.2.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
    </head>
    <body>
        <?php
       include '/includes/header.php';
       ?>
        <?php
         ?>
        <table class="table table-hover">
                <tr>
                    <td class="text-danger"><b>Item Number</b></td>
                    <td class="text-danger"><b>Item Name</b></td>
                    <td class="text-danger"><b>Price</b></td>
                <td></td>
                </tr>
  <?php
        if(!isset($_SESSION['email']))
{
    header('Location:index.php');

}

else
{
    $user_id=$_SESSION['id'];
    $select_query="Select * from users_items where users_id='$user_id'";
    $select_query_1="Select * from items i inner join users_items ui on i.id=ui.items_id where users_id='$user_id'";
    $select_query_2="Select *from users u inner join users_items ui on u.id=ui.users_id";
    $select_query_res=mysqli_query($con,$select_query_1) or die(mysqli_error($con));
    $no_of_rows= mysqli_num_rows($select_query_res);
    if($no_of_rows==0)
    {
        ?>
        <br />
        <br />
        <?php
        echo "<h3>Add items to Cart first</h3>";
    }
    else{
        $sum=0;
        $c=0;

        while($row= mysqli_fetch_array($select_query_res))
    {
        $sum=$sum+$row[2];
        $id="$id"."$row[0]".",";
        $c+=1;
        ?>

                <tr>
                    <td><?php echo $c; ?></td>
                    <td><?php echo $row[1]; ?></td>
                    <td><?php echo $row[2];   ?></td>
    <td> <a href='cart-remove.php?id=<?php echo $row[0]?>' class='remove_item_link'> Remove</a><?php } ?></td>
                </tr>
                <tr>
                    <td></td>
                    <td>Total</td>
                <td><?php echo $sum; } } ?></td>
                    <td><input type="button" class="btn btn-primary" onclick="location.href='success.php'" value="Confirm Order"></button></td>

                </tr>
            </table>
        <?php
        include 'includes/footer.php';
        ?>
    </body>
 </html>