-
Notifications
You must be signed in to change notification settings - Fork 0
/
select.php
148 lines (146 loc) · 6.28 KB
/
select.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
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
<?php
if(isset($_POST["asin"]))
{
$output = '';
$connect = mysqli_connect("amz-profit-calculator.cupbdaodf4ns.ap-northeast-1.rds.amazonaws.com", "jwire", "intern_jw!re", "amz_pc_prod","3306");
$query = "SELECT * FROM datainfo WHERE asin = '".$_POST["asin"]."'";
$result = mysqli_query($connect, $query);
echo '
<div class="table-responsive">
<table class="table table-bordered">';
while($row = mysqli_fetch_array($result))
{
echo '
<tr>
<td width="30%"><label>Amazon-order-id</label></td>
<td width="70%">'.$row["amazon-order-id"].'</td>
</tr>
<tr>
<td width="30%"><label>Merchant-order-id</label></td>
<td width="70%">'.$row["merchant-order-id"].'</td>
</tr>
<tr>
<td width="30%"><label>Purchase_date</label></td>
<td width="70%">'.$row["purchase_date"].'</td>
</tr>
<tr>
<td width="30%"><label>Last-updated-date</label></td>
<td width="70%">'.$row["last-updated-date"].'</td>
</tr>
<tr>
<td width="30%"><label>Order-status</label></td>
<td width="70%">'.$row["order-status"].'</td>
</tr>
<tr>
<td width="30%"><label>Fulfillment-channel</label></td>
<td width="70%">'.$row["fulfillment-channel"].'</td>
</tr>
<tr>
<td width="30%"><label>Sales-channel</label></td>
<td width="70%">'.$row["sales-channel"].'</td>
</tr>
<tr>
<td width="30%"><label>Order-channel</label></td>
<td width="70%">'.$row["order-channel"].'</td>
</tr>
<tr>
<td width="30%"><label>Url</label></td>
<td width="70%">'.$row["url"].'</td>
</tr>
<tr>
<td width="30%"><label>Ship-service-level</label></td>
<td width="70%">'.$row["ship-service-level"].'</td>
</tr>
<tr>
<td width="30%"><label>Product-name</label></td>
<td width="70%">'.$row["product-name"].'</td>
</tr>
<tr>
<td width="30%"><label>Sku</label></td>
<td width="70%">'.$row["sku"].'</td>
</tr>
<tr>
<td width="30%"><label>Asin</label></td>
<td width="70%">'.$row["asin"].'</td>
</tr>
<tr>
<td width="30%"><label>Item-status</label></td>
<td width="70%">'.$row["item-status"].'</td>
</tr>
<tr>
<td width="30%"><label>Quantity</label></td>
<td width="70%">'.$row["quantity"].'</td>
</tr>
<tr>
<td width="30%"><label>Currency</label></td>
<td width="70%">'.$row["currency"].'</td>
</tr>
<tr>
<td width="30%"><label>Item-price</label></td>
<td width="70%">'.$row["item-price"].'</td>
</tr>
<tr>
<td width="30%"><label>Item-tax</label></td>
<td width="70%">'.$row["item-tax"].'</td>
</tr>
<tr>
<td width="30%"><label>Shipping-price</label></td>
<td width="70%">'.$row["shipping-price"].'</td>
</tr>
<tr>
<td width="30%"><label>Shipping-tax</label></td>
<td width="70%">'.$row["shipping-tax"].'</td>
</tr>
<tr>
<td width="30%"><label>Gift-wrap-price</label></td>
<td width="70%">'.$row["gift-wrap-price"].'</td>
</tr>
<tr>
<td width="30%"><label>Gift-wrap-tax</label></td>
<td width="70%">'.$row["gift-wrap-tax"].'</td>
</tr>
<tr>
<td width="30%"><label>Item-promotion-discount</label></td>
<td width="70%">'.$row["item-promotion-discount"].'</td>
</tr>
<tr>
<td width="30%"><label>Ship-promotion-discount</label></td>
<td width="70%">'.$row["ship-promotion-discount"].'</td>
</tr>
<tr>
<td width="30%"><label>Ship-city</label></td>
<td width="70%">'.$row["ship-city"].'</td>
</tr>
<tr>
<td width="30%"><label>Ship-state</label></td>
<td width="70%">'.$row["ship-state"].'</td>
</tr>
<tr>
<td width="30%"><label>Ship-postal-code</label></td>
<td width="70%">'.$row["ship-postal-code"].'</td>
</tr>
<tr>
<td width="30%"><label>Ship-country</label></td>
<td width="70%">'.$row["ship-country"].'</td>
</tr>
<tr>
<td width="30%"><label>Promotion-ids</label></td>
<td width="70%">'.$row["promotion-ids"].'</td>
</tr>
<tr>
<td width="30%"><label>Is-business-order</label></td>
<td width="70%">'.$row["is-business-order"].'</td>
</tr>
<tr>
<td width="30%"><label>Purchase-order-number</label></td>
<td width="70%">'.$row["purchase-order-number"].'</td>
</tr>
<tr>
<td width="30%"><label>Price-designation</label></td>
<td width="70%">'.$row["price-designation"].'</td>
</tr>
';
}
echo "</table></div>";
}
?>