-
Notifications
You must be signed in to change notification settings - Fork 0
/
retailorderproduct.php
120 lines (80 loc) · 3.12 KB
/
retailorderproduct.php
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
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<?php
ob_start();
session_start();
include 'css/style.css';
include 'connection1.php';
include 'userheader.php';
$s21 = $_SESSION['login'];
$sql = "select * from orders where name ='$s21'";
$result = $conn->query($sql);
?>
<html>
<head>
<title>products </title>
<style>.material-icons.md-48 { font-size: 48px; }
</style>
<link rel="icon" href="test.png" sizes="96x96" type="image/png">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
</head>
<body>
<h1>
<a href="userhome.php"><h3> <font color="#0000FF" > <i class="material-icons md-48" >arrow_circle_left</i></font></h3></a>
</h1>
<div class="div-center"><font color="#0000FF"><b><h1>My Orders</h1></b></font></div>
<div class="div-center">
<div class="col-md-12">
<table class="table table-hover" id="list">
<tr>
<th>Product Name </th>
<th>Quantity </th>
<th>Total Amount </th>
<th>action </th>
</tr>
<tr >
<?php
if($result->num_rows > 0){
while($row=$result->fetch_assoc()){
?>
<td><?php echo $row['productname']; ?></td>
<td><?php echo $row['quantity']; ?></td>
<td>₹<?php echo $row['total']; ?></td>
<td >
<div class="btn-group-vertical">
<form method="post">
<button class="btn btn-danger btn-xs" type="submit" name='prescribe1'><i class="material-icons">delete</i></button>
<input type='hidden' name='prescribe1' value="<?php echo $row['id'];?>" >
<?php if(isset($_POST['prescribe1'])){
$sl=$_POST['prescribe1'];
//echo $sl;
$_SESSION['sl']= $sl;
$sql= "delete from orders where id ='$sl' ";
$result1 = $conn->query($sql);
if($result1){
header("Location:retailorderproduct.php");
}
}
?>
</form>
</td>
</tr>
</div>
<?php
}
}
if(isset($_POST['delete'])){
$id = $_POST['delete'];
$sql2 = "delete from tbl_containment where id= '$id' ";
$result = $conn->query($sql2);
if($result){
header("Location:staff_view_containment.php");
echo 'Data Deleted';
}
}
?>
</table>
</div>
</body>
</html>