· 7 years ago · Sep 27, 2018, 08:12 PM
1<?php
2
3Class lotto{
4
5require('File.Class.php');
6
7 function init(){
8 $dbName = lotto;
9
10 try {
11 $dbh = new PDO('mysql:localhost:3306', 'root', '');
12 }
13 catch (PDOException $e) {
14 echo 'Connection failed: ' . $e->getMessage();
15 }
16
17 //create the database
18 try{
19 $sth = $dbh->prepare("CREATE DATABASE IF NOT EXISTS $dbName");
20 $sth->execute();
21 }
22 catch (PDOException $e) {
23 die("Creating Database Error: ". $e->getMessage());
24 }
25
26 //create the pick3 table
27 try{
28 $dbh->exec("USE $dbName;");
29 $dbh->exec("CREATE TABLE IF NOT EXISTS pick3 (
30 date DATE NOT NULL,
31 pick3 INT(3),
32 PRIMARY KEY (date));");
33 }
34 catch (PDOException $e) {
35 die("Creating Table Error: ". $e->getMessage());
36 }
37
38 //create the pick4 table
39 try{
40 $dbh->exec("USE $dbName;");
41 $dbh->exec("CREATE TABLE IF NOT EXISTS pick4 (
42 date DATE NOT NULL,
43 pick3 INT(4),
44 PRIMARY KEY (date));");
45 }
46 catch (PDOException $e) {
47 die("Creating Table Error: ". $e->getMessage());
48 }
49
50 //create the mega table
51 try{
52 $dbh->exec("USE $dbName;");
53 $dbh->exec("CREATE TABLE IF NOT EXISTS mega (
54 date DATE NOT NULL,
55 b1 INT(2),
56 b2 INT(2),
57 b3 INT(2),
58 b4 INT(2),
59 b5 INT(2),
60 mb INT(2),
61 mp INT(1),
62 PRIMARY KEY (date));");
63 }
64 catch (PDOException $e) {
65 die("Creating Table Error: ". $e->getMessage());
66 }
67
68 //create the powerball table
69 try{
70 $dbh->exec("USE $dbName;");
71 $dbh->exec("CREATE TABLE IF NOT EXISTS powerball (
72 date DATE NOT NULL,
73 b1 INT(2),
74 b2 INT(2),
75 b3 INT(2),
76 b4 INT(2),
77 b5 INT(2),
78 pb INT(2),
79 pp INT(1),
80 PRIMARY KEY (date));");
81 }
82 catch (PDOException $e) {
83 die("Creating Table Error: ". $e->getMessage());
84 }
85
86 //create the classic ohio table
87 try{
88 $dbh->exec("USE $dbName;");
89 $dbh->exec("CREATE TABLE IF NOT EXISTS classic (
90 date DATE NOT NULL,
91 b1 INT(2),
92 b2 INT(2),
93 b3 INT(2),
94 b4 INT(2),
95 b5 INT(2),
96 b6 INT(2),
97 PRIMARY KEY (date));");
98 }
99 catch (PDOException $e) {
100 die("Creating Table Error: ". $e->getMessage());
101 }
102
103 //create the ten-OH table
104 try{
105 $dbh->exec("USE $dbName;");
106 $dbh->exec("CREATE TABLE IF NOT EXISTS tenoh (
107 date DATE NOT NULL,
108 db1 INT(2),
109 db2 INT(2),
110 db3 INT(2),
111 db4 INT(2),
112 db5 INT(2),
113 db6 INT(2),
114 db7 INT(2),
115 db8 INT(2),
116 db9 INT(2),
117 db10 INT(2),
118 db11 INT(2),
119 db12 INT(2),
120 db13 INT(2),
121 db14 INT(2),
122 db15 INT(2),
123 db16 INT(2),
124 db17 INT(2),
125 db18 INT(2),
126 db19 INT(2),
127 db20 INT(2),
128
129 nb1 INT(2),
130 nb2 INT(2),
131 nb3 INT(2),
132 nb4 INT(2),
133 nb5 INT(2),
134 nb6 INT(2),
135 nb7 INT(2),
136 nb8 INT(2),
137 nb9 INT(2),
138 nb10 INT(2),
139 nb11 INT(2),
140 nb12 INT(2),
141 nb13 INT(2),
142 nb14 INT(2),
143 nb15 INT(2),
144 nb16 INT(2),
145 nb17 INT(2),
146 nb18 INT(2),
147 nb19 INT(2),
148 nb20 INT(2),
149 PRIMARY KEY (date));");
150 }
151 catch (PDOException $e) {
152 die("Creating Table Error: ". $e->getMessage());
153 }
154
155 //create the rolling cash 5 table
156 try{
157 $dbh->exec("USE $dbName;");
158 $dbh->exec("CREATE TABLE IF NOT EXISTS rollingfive (
159 date DATE NOT NULL,
160 b1 INT(2),
161 b2 INT(2),
162 b3 INT(2),
163 b4 INT(2),
164 b5 INT(2),
165 PRIMARY KEY (date));");
166 }
167 catch (PDOException $e) {
168 die("Creating Table Error: ". $e->getMessage());
169 }
170 }
171
172 function printpick3(){
173 $dbName = lotto;
174
175 //create a PDO object to interface with the database
176 try {
177 $dbh = new PDO('mysql:localhost:3306', 'root', '');
178 }
179 catch (PDOException $e) {
180 echo 'Connection failed: ' . $e->getMessage();
181 }
182
183 if (isset($_GET['date']))
184 $datesort = !$_GET['date'];
185 else
186 $datesort = 'TRUE';
187
188 if($datesort)
189 $sort = 'DESC';
190 else
191 $sort = 'ASC';
192
193 try{
194 $dbh->exec("USE $dbName;");
195 $sth = $dbh->prepare("SELECT * FROM pick3 ORDER BY date $sort");
196 $sth->execute();
197 $result = $sth->fetchAll(PDO::FETCH_ASSOC);
198 }
199 catch (PDOException $e) {
200 die("Printing Data Error: ". $e->getMessage());
201 }
202
203 echo '<link href="common/style.css" rel="stylesheet" type="text/css" />';
204 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>";
205 foreach($result as $r){
206 echo "<tr><td>".$r[date]."</td><td>".$r[pick3]."</td>";}
207 echo "</table>";
208 }
209}
210
211?>