forked from choiyounji/bigdataproject
-
Notifications
You must be signed in to change notification settings - Fork 0
/
yearsEstablished.php
106 lines (104 loc) · 5.15 KB
/
yearsEstablished.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
<!-- 김주연 -->
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<link rel="stylesheet" href="result.css">
</head>
<body>
<header>
<a href="select.php">
<svg xmlns="http://www.w3.org/2000/svg" class="ionicon" width="30px" height="30px" ViewBox="0 0 512 512">
<path d="M80 212v236a16 16 0 0016 16h96V328a24 24 0 0124-24h80a24 24 0 0124 24v136h96a16 16 0 0016-16V212" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round" stroke-width="32"/>
<path d="M480 256L266.89 52c-5-5.28-16.69-5.34-21.78 0L32 256M400 179V64h-48v69" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round" stroke-width="32"/>
</svg>
HOME
</a>
</header>
<div class="title">Sales information based on Years Outlet was Established </div>
<table>
<th>Years Established</th>
<th>Average Sales</th>
<?php
header('Content-Type: text/html; charset=UTF-8');
$mysqli=mysqli_connect("localhost","team21","team21","team21");
session_start();
//echo "Session 값 : ".$_SESSION['checked']."<br/>";
if(mysqli_connect_errno()){
printf("Connect failed: %s\n", mysqli_error($mysqli));
exit();
}
else{
if(isset($_POST["showValues"])){
if($_POST["showValues"] == 13){
$showValues = "(13)";
}
elseif($_POST["showValues"] == 15){
$showValues = "(15)";
}
elseif($_POST["showValues"] == 18){
$showValues = "(18)";
}
elseif($_POST["showValues"] == 20){
$showValues = "(20)";
}
elseif($_POST["showValues"] == 23){
$showValues = "(23)";
}
elseif($_POST["showValues"] == 24){
$showValues = "(24)";
}
elseif($_POST["showValues"] == 25){
$showValues = "(25)";
}
elseif($_POST["showValues"] == 35){
$showValues = "(35)";
}
elseif($_POST["showValues"] == 37){
$showValues = "(37)";
}
else{
$showValues = "(13,15,18,20,23,24,25,35,37)";
}
}
else{
$showValues = "(13,15,18,20,23,24,25,35,37)";
}
$sql = "select oYearsEstablished, AVG(iOutletSales) as avgSales
from yearsEstablishedSales
WHERE oYearsEstablished in ".$showValues."
GROUP BY oYearsEstablished;";
$res = mysqli_query($mysqli, $sql);
if($res){
while($newArray=mysqli_fetch_array($res, MYSQLI_ASSOC)){
$oYearsEstablished=$newArray['oYearsEstablished'];
$avgSales=$newArray['avgSales'];
echo "<tr><td>".$oYearsEstablished."</td> <td>".$avgSales."</td> </tr>";
}
}
else{
printf("Could not retrieve records : %s\n", mysqli_error($mysqli));
}
mysqli_free_result($res);
mysqli_close($mysqli);
}
?>
</table>
<div class="radios">
<form action="yearsEstablished.php" method="POST">
<p><div class="show"> Years: </div></br>
<label><input type= "radio" name = "showValues" value="All"<?php if($_SESSION['checked']=="All"){echo "checked";}?>> All</label></br>
<label><input type= "radio" name = "showValues" value="13"<?php if($showValues ==="(13)"){echo "checked";}?>>13<label></br>
<label><input type= "radio" name = "showValues" value="15"<?php if($showValues ==="(15)"){echo "checked";}?>>15<label></br>
<label><input type= "radio" name = "showValues" value="18"<?php if($showValues ==="(18)"){echo "checked";}?>>18<label></br>
<label><input type= "radio" name = "showValues" value="20"<?php if($showValues ==="(20)"){echo "checked";}?>>20<label></br>
<label><input type= "radio" name = "showValues" value="23"<?php if($showValues ==="(23)"){echo "checked";}?>>23<label></br>
<label><input type= "radio" name = "showValues" value="24"<?php if($showValues ==="(24)"){echo "checked";}?>>24<label></br>
<label><input type= "radio" name = "showValues" value="25"<?php if($showValues ==="(25)"){echo "checked";}?>>25<label></br>
<label><input type= "radio" name = "showValues" value="35"<?php if($showValues ==="(35)"){echo "checked";}?>>35<label></br>
<label><input type= "radio" name = "showValues" value="37"<?php if($showValues ==="(37)"){echo "checked";}?>>37<label></br>
<input type="submit" name="submit" value="Run Analysis">
</p>
</div>
</body>
</html>