· 7 years ago · Sep 28, 2018, 03:22 AM
1<?php
2require('File.Class.php');
3
4Class lotto{
5
6 public function init(){
7 $dbName = "lotto";
8
9 try {
10 $dbh = new PDO('mysql:localhost:3306', 'root', '');
11 }
12 catch (PDOException $e) {
13 echo 'Connection failed: ' . $e->getMessage();
14 }
15
16 //create the database
17 try{
18 $sth = $dbh->prepare("CREATE DATABASE IF NOT EXISTS $dbName");
19 $sth->execute();
20 }
21 catch (PDOException $e) {
22 die("Creating Database Error: ". $e->getMessage());
23 }
24
25 //create the pick3 table
26 try{
27 $dbh->exec("USE $dbName;");
28 $dbh->exec("CREATE TABLE IF NOT EXISTS pick3 (
29 date DATE NOT NULL,
30 pick3 INT(3),
31 PRIMARY KEY (date));");
32 }
33 catch (PDOException $e) {
34 die("Creating Table Error: ". $e->getMessage());
35 }
36
37 //create the pick4 table
38 try{
39 $dbh->exec("USE $dbName;");
40 $dbh->exec("CREATE TABLE IF NOT EXISTS pick4 (
41 date DATE NOT NULL,
42 pick3 INT(4),
43 PRIMARY KEY (date));");
44 }
45 catch (PDOException $e) {
46 die("Creating Table Error: ". $e->getMessage());
47 }
48
49 //create the mega table
50 try{
51 $dbh->exec("USE $dbName;");
52 $dbh->exec("CREATE TABLE IF NOT EXISTS mega (
53 date DATE NOT NULL,
54 b1 INT(2),
55 b2 INT(2),
56 b3 INT(2),
57 b4 INT(2),
58 b5 INT(2),
59 mb INT(2),
60 mp INT(1),
61 PRIMARY KEY (date));");
62 }
63 catch (PDOException $e) {
64 die("Creating Table Error: ". $e->getMessage());
65 }
66
67 //create the powerball table
68 try{
69 $dbh->exec("USE $dbName;");
70 $dbh->exec("CREATE TABLE IF NOT EXISTS powerball (
71 date DATE NOT NULL,
72 b1 INT(2),
73 b2 INT(2),
74 b3 INT(2),
75 b4 INT(2),
76 b5 INT(2),
77 pb INT(2),
78 pp INT(1),
79 PRIMARY KEY (date));");
80 }
81 catch (PDOException $e) {
82 die("Creating Table Error: ". $e->getMessage());
83 }
84
85 //create the classic ohio table
86 try{
87 $dbh->exec("USE $dbName;");
88 $dbh->exec("CREATE TABLE IF NOT EXISTS classic (
89 date DATE NOT NULL,
90 b1 INT(2),
91 b2 INT(2),
92 b3 INT(2),
93 b4 INT(2),
94 b5 INT(2),
95 b6 INT(2),
96 PRIMARY KEY (date));");
97 }
98 catch (PDOException $e) {
99 die("Creating Table Error: ". $e->getMessage());
100 }
101
102 //create the ten-OH table
103 try{
104 $dbh->exec("USE $dbName;");
105 $dbh->exec("CREATE TABLE IF NOT EXISTS tenoh (
106 date DATE NOT NULL,
107 db1 INT(2),
108 db2 INT(2),
109 db3 INT(2),
110 db4 INT(2),
111 db5 INT(2),
112 db6 INT(2),
113 db7 INT(2),
114 db8 INT(2),
115 db9 INT(2),
116 db10 INT(2),
117 db11 INT(2),
118 db12 INT(2),
119 db13 INT(2),
120 db14 INT(2),
121 db15 INT(2),
122 db16 INT(2),
123 db17 INT(2),
124 db18 INT(2),
125 db19 INT(2),
126 db20 INT(2),
127
128 nb1 INT(2),
129 nb2 INT(2),
130 nb3 INT(2),
131 nb4 INT(2),
132 nb5 INT(2),
133 nb6 INT(2),
134 nb7 INT(2),
135 nb8 INT(2),
136 nb9 INT(2),
137 nb10 INT(2),
138 nb11 INT(2),
139 nb12 INT(2),
140 nb13 INT(2),
141 nb14 INT(2),
142 nb15 INT(2),
143 nb16 INT(2),
144 nb17 INT(2),
145 nb18 INT(2),
146 nb19 INT(2),
147 nb20 INT(2),
148 PRIMARY KEY (date));");
149 }
150 catch (PDOException $e) {
151 die("Creating Table Error: ". $e->getMessage());
152 }
153
154 //create the rolling cash 5 table
155 try{
156 $dbh->exec("USE $dbName;");
157 $dbh->exec("CREATE TABLE IF NOT EXISTS rollingfive (
158 date DATE NOT NULL,
159 b1 INT(2),
160 b2 INT(2),
161 b3 INT(2),
162 b4 INT(2),
163 b5 INT(2),
164 PRIMARY KEY (date));");
165 }
166 catch (PDOException $e) {
167 die("Creating Table Error: ". $e->getMessage());
168 }
169 }
170
171 public function printpick3(){
172 $dbName = "lotto";
173
174 //create a PDO object to interface with the database
175 try {
176 $dbh = new PDO('mysql:localhost:3306', 'root', '6148914178');
177 }
178 catch (PDOException $e) {
179 echo 'Connection failed: ' . $e->getMessage();
180 }
181
182 if (isset($_GET['date']))
183 $datesort = !$_GET['date'];
184 else
185 $datesort = 'TRUE';
186
187 if($datesort)
188 $sort = 'DESC';
189 else
190 $sort = 'ASC';
191
192 try{
193 $dbh->exec("USE $dbName;");
194 $sth = $dbh->prepare("SELECT * FROM pick3 ORDER BY date $sort");
195 $sth->execute();
196 $result = $sth->fetchAll(PDO::FETCH_ASSOC);
197 }
198 catch (PDOException $e) {
199 die("Printing Data Error: ". $e->getMessage());
200 }
201
202 echo "<table><tr><th><a name=date href='?date=".$datesort."'>Date</a></th><th><a name=nums href='#'>Pick 3</a></th><th></th></tr>";
203 foreach($result as $r){
204 echo "<tr><td>".$r[date]."</td><td>".$r[pick3]."</td>";}
205 echo "</table>";
206 }
207
208 public function parse($filename)
209 {
210 // Get the rows of data
211 $data = array_map('trim', explode("\n", file_get_contents($filename)));
212
213 // array('date' => array('pick1' => val, 'pick2' => val, ...))
214 $picks = array();
215
216 // Get the names of each of the different picks
217 $pick_names = array_slice(explode(',', array_shift($data)), 1);
218
219 foreach ($data as $pick_row)
220 {
221 $pick_data = explode(',', $pick_row);
222
223 // Get the date the picks happend
224 $date = array_shift($pick_data);
225
226 // Combine the pick data and pick names into an assoicative array.
227 // Also use array filter to ignore empty values
228 $values = array_filter(array_combine($pick_names, $pick_data));
229
230 // If there are NO picks for this date, just skip it
231 if (empty($values))
232 continue;
233
234 // Add the date to the array with the pick name and value
235 $picks[$date] = $values;
236 }
237
238 return $picks;
239 }
240}