forked from jackengledow/Scouting-System-2017
/
sql.php
142 lines (130 loc) · 3.65 KB
/
sql.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
<!DOCTYPE html>
<html>
<head>
<meta http-equiv = "refresh" content = "1.5; url = scouting.html">
<title>SQL</title>
</head>
<body>
<center><h2 style= "font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Successfully Submitted</h2></center>
<?php
function getValue($key, $defVal){
if(isset($_POST[$key]) && !empty($_POST[$key])){
return $_POST[$key];
}
return $defVal;
}
function getString($key, $defVal){
return "'" . getValue($key, $defVal) . "'";
}
$host = "localhost";
$user = "root";
$pass = file_get_contents(".db-password");
$dbname = "techHounds";
$con = new mysqli($host,$user,$pass,$dbname);
if($con->connect_errno) {
echo "Connection failed: " . $con->connect_error;
}
$teamNumber = getValue('teamNumber', 0);
$matchNumber = getValue('matchNumber', 0);
$startFuel = getValue('startFuel', "FALSE");
$startGears = getValue('startGears', "FALSE");
$baseline = getValue('baseline', "FALSE");
$scoreGear = getValue('scoreGear', "FALSE");
$autonHigh = getValue('autonHigh', 0);
$speed = getValue('speed', "0");
$disabled = getValue('disabled', "FALSE");
$collectsFuel = getValue('collectsFuel', "FALSE");
$useHopper = getValue('useHopper', "FALSE");
$collectsGear = getValue('collectsGear', "FALSE");
$teleopGears = getValue('teleopGears', 0);
$climb = getValue('climb', '0');
$teleopHigh = getValue('teleopHigh', 0);
$fouls = getValue('fouls', "0");
$technicals = getValue('technicals', 0);
$yellows = getValue('yellows', "FALSE");
$reds = getValue('reds', "TRUE");
$ejections = getValue('ejections', "FALSE");
$notes = getString('notes', '');
if($startFuel=="on") {
$startFuel="TRUE";
} else {
$startFuel="FALSE";
}
if($startGears=="on") {
$startGears="TRUE";
} else {
$startGears="FALSE";
}
if($baseline=="on") {
$baseline="TRUE";
} else {
$baseline="FALSE";
}
if($scoreGear=="on") {
$scoreGear="TRUE";
} else {
$scoreGear="FALSE";
}
if($disabled=="on") {
$disabled="TRUE";
} else {
$disabled="FALSE";
}
if($collectsFuel=="on") {
$collectsFuel="TRUE";
} else {
$collectsFuel="FALSE";
}
if($useHopper=="on") {
$useHopper="TRUE";
} else {
$useHopper="FALSE";
}
if($collectsGear=="on") {
$collectsGear="TRUE";
} else {
$collectsGear="FALSE";
}
if($yellows == "on"){
$yellows = "TRUE";
} else {
$yellows = "FALSE";
}
if($reds == "on"){
$reds = "TRUE";
} else {
$reds = "FALSE";
}
if($ejections == "on"){
$ejections = "TRUE";
} else {
$ejections = "FALSE";
}
$query = "INSERT INTO generic(teamNumber,matchNumber,startFuel,startGears,baseline,scoreGear,autonHigh,speed,disabled,collectsFuel,useHopper,collectsGear,teleopGears,teleopHigh,climb,fouls,technicals,yellows,reds,ejections,notes) VALUES($teamNumber,$matchNumber,$startFuel,$startGears,$baseline,$scoreGear,$autonHigh,$speed,$disabled,$collectsFuel,$useHopper,$collectsGear,$teleopGears,$teleopHigh,$climb,$fouls,$technicals,$yellows,$reds,$ejections,$notes);";
$con->query($query);
/*
echo "$teamNumber\n";
echo "$matchNumber\n";
echo "$startFuel\n";
echo "$startGears\n";
echo "$baseline\n";
echo "$scoreGear\n";
echo "$autonHigh\n";
echo "$speed\n";
echo "$disabled\n";
echo "$collectsFuel\n";
echo "$useHopper\n";
echo "$collectsGear\n";
echo "$teleopGears\n";
echo "$climb\n";
echo "$teleopHigh\n";
echo "$fouls\n";
echo "$technicals\n";
echo "$yellows\n";
echo "$reds\n";
echo "$ejections\n";
echo "$notes\n";*/
mysqli_close($con);
?>
</body>
</html>