-
Notifications
You must be signed in to change notification settings - Fork 1
/
newhello.php
135 lines (95 loc) · 7.86 KB
/
newhello.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
<script src="https://code.jquery.com/jquery-3.7.0.min.js"></script>
<script src="../dataValue1.js"></script>
<script src="../dataValue2.js"></script>
<?php
include_once 'db.php';
$value1 = $_COOKIE["value1"];
$value2 = $_COOKIE["value2"];
$value3 = $_COOKIE["value3"];
$value4 = $_COOKIE["value4"];
$value5 = $_COOKIE["value5"];
$value6 = $_COOKIE["value6"];
$value7 = $_COOKIE["value7"];
$char1 = $_COOKIE["value8"];
$value9 = $_COOKIE["value9"];
$value10 = $_COOKIE["value10"];
$value11 = $_COOKIE["value11"];
$value12 = $_COOKIE["value12"];
$value13 = $_COOKIE["value13"];
$value14 = $_COOKIE["value14"];
$value15 = $_COOKIE["value15"] * pow(10,-6) - 90;
$value16 = $_COOKIE["value16"] * pow(10,-6) - 180;
switch ( $char1 ) {
case 1 :
$sql = "INSERT INTO MQ135 (CO, Alcohol, CO2, Toluen, NH4, Aceton, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value5 . "', '" . $value6 . "', '" . $value7 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 2 :
$sql = "INSERT INTO MQ2 (H2, LPG, CO, Alcohol, Propane, CH4, Smoke, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value5 . "', '" . $value6 . "', '" . $value7 . "', '" . (98*$value13+200) . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 3 :
$sql = "INSERT INTO MQ3 (LPG, CH4, CO, Alcohol, Benzene, Hexane, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value5 . "', '" . $value6 . "', '" . $value7 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 4 :
$sql = "INSERT INTO MQ4 (H2, LPG, CH4, CO, Alcohol, Smoke, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value5 . "', '" . $value6 . "', '" . $value7 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 5 :
$sql = "INSERT INTO MQ5 (H2, LPG, CH4, CO, Alcohol, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value5 . "', '" . $value6 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 6 :
$sql = "INSERT INTO MQ6 (H2, LPG, CH4, CO, Alcohol, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value5 . "', '" . $value6 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 7 :
$sql = "INSERT INTO MQ7 (H2, LPG, CH4, CO, Alcohol, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value5 . "', '" . $value6 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 8 :
$sql = "INSERT INTO MQ8 (H2, LPG, CH4, CO, Alcohol, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value5 . "', '" . $value6 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 9 :
$sql = "INSERT INTO MQ9 (LPG, CH4, CO, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 10 :
$sql = "INSERT INTO MQ131 (NOx, CL2, O3, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 11 :
$sql = "INSERT INTO MQ136 (H2S, NH4, CO, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 12 :
$sql = "INSERT INTO MQ137 (CO, Ethanol, NH3, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 13 :
$value4 = $value4 / 100;
$sql = "INSERT INTO MQ303A (Isobutane, Hydrogen, Ethanol, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 14 :
$sql = "INSERT INTO MQ307A (CO, H2, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
case 15 :
$sql = "INSERT INTO MQ309A (H2, CH4, CO, Alcohol, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value5 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
default:
$sql = "INSERT INTO MQ135 (CO, Alcohol, CO2, Toluen, NH4, Aceton, Air, usvhr, Avg1, sdCPM, CPMCount, SpaceData100, SpaceData200, lat, lng)
VALUES ('" . $value1 . "', '" . $value2 . "', '" . $value3 . "', '" . $value4 . "', '" . $value5 . "', '" . $value6 . "', '" . $value7 . "', '" . $value9 . "', '" . $value10 . "', '" . $value11 . "', '" . $value12 . "', '" . $value13 . "', '" . $value14 . "', '" . $value15 . "', '" . $value16 . "')";
break;
}
if ($conn->query($sql) === TRUE) {
}
else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>