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