-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathadd_batter.php
128 lines (115 loc) · 3.83 KB
/
add_batter.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
<?php
$db = new PDO('mysql:host=localhost;dbname=baseball;charset=utf8', 'root', '');
if (htmlspecialchars($_GET["sent"])) {
$_player = $_GET["player"];
$_pa = $_GET["pa"];
$_h = $_GET["h"];
$_bb = $_GET["bb"];
$_so = $_GET["so"];
$_hbp = $_GET["hbp"];
$_2b = $_GET["2b"];
$_3b = $_GET["3b"];
$_hr = $_GET["hr"];
$_rbi = $_GET["rbi"];
$_sac = $_GET["sac"];
$_r = $_GET["r"];
$_sb = $_GET["sb"];
$_cs = $_GET["cs"];
$_ob = $_GET["ob"];
//Process player if it matches one already in the database.
$stmt = $db->prepare('SELECT * FROM batting WHERE player = ?');
if ($stmt->execute(array($_GET['player'])) && $stmt->rowCount()) {
while ($player = $stmt->fetch()) {
$_pa += $player['pa'];
$_h += $player['h'];
$_bb += $player['bb'];
$_so += $player['so'];
$_hbp += $player['hbp'];
$_2b += $player['2b'];
$_3b += $player['3b'];
$_hr += $player['hr'];
$_rbi += $player['rbi'];
$_sac += $player['sac'];
$_r += $player['r'];
$_sb += $player['sb'];
$_cs += $player['cs'];
$_ob += $player['ob'];
$clearold = $db->prepare("DELETE FROM `batting` WHERE `player` = ? AND `pa` = ?");
$clearold->execute(array($player['player'], $player['pa']));
$stmt2 = $db->prepare("INSERT INTO batting (player, pa, h, bb, so, hbp, 2b, 3b, hr, rbi, sac, r, sb, cs, ob) VALUES (:player, :pa, :h, :bb, :so, :hbp, :2b, :3b, :hr, :rbi, :sac, :r, :sb, :cs, :ob)");
$stmt2->bindParam(':player', $_player);
$stmt2->bindParam(':pa', $_pa);
$stmt2->bindParam(':h', $_h);
$stmt2->bindParam(':bb', $_bb);
$stmt2->bindParam(':so', $_so);
$stmt2->bindParam(':hbp', $_hbp);
$stmt2->bindParam(':2b', $_2b);
$stmt2->bindParam(':3b', $_3b);
$stmt2->bindParam(':hr', $_hr);
$stmt2->bindParam(':rbi', $_rbi);
$stmt2->bindParam(':sac', $_sac);
$stmt2->bindParam(':r', $_r);
$stmt2->bindParam(':sb', $_sb);
$stmt2->bindParam(':cs', $_cs);
$stmt2->bindParam(':ob', $_ob);
$stmt2->execute();
echo "Existing.";
}
} else {
$stmt2 = $db->prepare("INSERT INTO batting (player, pa, h, bb, so, hbp, 2b, 3b, hr, rbi, sac, r, sb, cs, ob) VALUES (:player, :pa, :h, :bb, :so, :hbp, :2b, :3b, :hr, :rbi, :sac, :r, :sb, :cs, :ob)");
$stmt2->bindParam(':player', $_player);
$stmt2->bindParam(':pa', $_pa);
$stmt2->bindParam(':h', $_h);
$stmt2->bindParam(':bb', $_bb);
$stmt2->bindParam(':so', $_so);
$stmt2->bindParam(':hbp', $_hbp);
$stmt2->bindParam(':2b', $_2b);
$stmt2->bindParam(':3b', $_3b);
$stmt2->bindParam(':hr', $_hr);
$stmt2->bindParam(':rbi', $_rbi);
$stmt2->bindParam(':sac', $_sac);
$stmt2->bindParam(':r', $_r);
$stmt2->bindParam(':sb', $_sb);
$stmt2->bindParam(':cs', $_cs);
$stmt2->bindParam(':ob', $_ob);
$stmt2->execute();
echo "New Player";
}
echo "<br /><span style='color:#0a0;font-weight:900;text-size:18px;'>Player stats added.</span><br />";
}
?>
<h1>Add a Batter's Statistics</h1>
<form action="add_batter.php" method="get">
Player Name: <br />
<input type="text" name="player" /><br />
Plate Appearances: <br />
<input type="text" name="pa" /><br />
Hits: <br />
<input type="text" name="h" /><br />
Walks: <br />
<input type="text" name="bb" /><br />
Strikeouts: <br />
<input type="text" name="so" /><br />
Hit by Pitch: <br />
<input type="text" name="hbp" /><br />
Doubles: <br />
<input type="text" name="2b" /><br />
Triples: <br />
<input type="text" name="3b" /><br />
Homeruns: <br />
<input type="text" name="hr" /><br />
RBI: <br />
<input type="text" name="rbi" /><br />
Sacrifices: <br />
<input type="text" name="sac" /><br />
Runs: <br />
<input type="text" name="r" /><br />
Stolen Bases: <br />
<input type="text" name="sb" /><br />
Caught Stealing: <br />
<input type="text" name="cs" /><br />
Times on Base: <br />
<input type="text" name="ob" /><br />
<input type="hidden" name="sent" value="1" />
<input type="submit" />
</form>