· 8 years ago · Jan 31, 2018, 07:12 AM
1<html>
2<head>
3 <title>Search the Database</title>
4</head>
5
6<body>
7
8<form action="search.php" method="post">
9 Search:
10 <input type="text" name="num1" />,
11 <input type="text" name="num2" />,
12 <input type="text" name="num3" />,
13 <input type="text" name="num4" />,
14 <input type="text" name="num5" />,
15 <input type="text" name="num6" />,
16 <input type="text" name="num7" />,
17 <input type="text" name="num8" />,
18 <input type="text" name="num9" />,
19 <input type="text" name="num10" />,
20 <input type="text" name="num11" />,
21 <input type="text" name="num12" />,<br />
22<input type="submit" name="submit" value="Submit" />
23</form>
24
25
26</body>
27
28<html>
29<head>
30 <title>Search the Database</title>
31</head>
32
33<body>
34
35<form action="search.php" method="post">
36 Search:
37 <input type="text" name="num1" />,
38 <input type="text" name="num2" />,
39 <input type="text" name="num3" />,
40 <input type="text" name="num4" />,
41 <input type="text" name="num5" />,
42 <input type="text" name="num6" />,
43 <input type="text" name="num7" />,
44 <input type="text" name="num8" />,
45 <input type="text" name="num9" />,
46 <input type="text" name="num10" />,
47 <input type="text" name="num11" />,
48 <input type="text" name="num12" />,<br />
49<input type="submit" name="submit" value="Submit" />
50</form>
51
52
53</body>
54
55id number
563 1
573 4
583 6
593 7
603 8
613 9
623 10
633 11
643 12
653 14
663 16
673 17
683 20
693 23
703 24
71
72select id
73from lotto_table
74where number in (1,4,6,7,8,9,10,11,12,14,16,17)
75group by id
76having count(*) = 12
77
78(1, 2, 3, 5, 6, 9, 10, 11, 13, 14, 16, 18, 20, 23, 24, 25),
79(2, 1, 4, 5, 6, 7, 9, 11, 12, 13, 15, 16, 19, 20, 23, 24),
80(3, 1, 4, 6, 7, 8, 9, 10, 11, 12, 14, 16, 17, 20, 23, 24),
81(4, 1, 2, 4, 5, 8, 10, 12, 13, 16, 17, 18, 19, 23, 24, 25),
82(5, 1, 2, 4, 8, 9, 11, 12, 13, 15, 16, 19, 20, 23, 24, 25),
83(6, 1, 2, 4, 5, 6, 7, 10, 12, 15, 16, 17, 19, 21, 23, 25),
84(7, 1, 4, 7, 8, 10, 12, 14, 15, 16, 18, 19, 21, 22, 23, 25),
85(8, 1, 5, 6, 8, 9, 10, 13, 15, 16, 17, 18, 19, 20, 22, 25),
86(9, 3, 4, 5, 9, 10, 11, 13, 15, 16, 17, 19, 20, 21, 24, 25),
87(10, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14, 19, 20, 23, 24),
88(11, 2, 6, 7, 8, 9, 10, 11, 12, 16, 19, 20, 22, 23, 24, 25),
89(12, 1, 2, 4, 5, 7, 8, 9, 10, 11, 12, 14, 16, 17, 24, 25),
90(13, 3, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 19, 23),
91(14, 1, 2, 5, 6, 7, 9, 13, 14, 15, 18, 19, 20, 21, 23, 25),
92(15, 1, 2, 4, 6, 8, 10, 12, 15, 16, 18, 19, 21, 23, 24, 25),
93(16, 2, 5, 6, 7, 8, 10, 12, 13, 15, 17, 19, 21, 23, 24, 25),
94(17, 1, 2, 3, 5, 6, 7, 9, 13, 14, 16, 17, 18, 19, 20, 21),
95(18, 2, 6, 7, 8, 10, 11, 14, 15, 17, 18, 19, 20, 22, 23, 24),
96(19, 2, 5, 6, 7, 8, 10, 11, 13, 14, 15, 16, 17, 20, 23, 24),
97(20, 3, 4, 6, 7, 8, 9, 10, 14, 16, 17, 18, 19, 20, 23, 24),
98(21, 1, 2, 4, 5, 8, 11, 14, 16, 18, 19, 20, 22, 23, 24, 25),
99(22, 1, 2, 3, 4, 5, 6, 7, 9, 10, 12, 13, 14, 15, 22, 25),
100(23, 1, 3, 4, 5, 6, 8, 10, 11, 12, 14, 16, 17, 18, 19, 20),
101(24, 1, 2, 3, 5, 7, 10, 11, 14, 17, 19, 20, 21, 23, 24, 25),
102(25, 1, 2, 3, 4, 5, 6, 7, 9, 13, 14, 16, 20, 22, 23, 24),
103(26, 5, 7, 8, 9, 10, 11, 13, 14, 16, 17, 19, 20, 21, 22, 23),
104(27, 3, 6, 8, 10, 11, 12, 13, 14, 15, 18, 20, 21, 22, 24, 25),
105(28, 1, 3, 7, 9, 10, 11, 12, 13, 14, 16, 17, 18, 19, 20, 21),
106(29, 1, 4, 5, 6, 8, 9, 13, 14, 16, 17, 19, 20, 21, 22, 24),
107(30, 1, 2, 3, 4, 6, 7, 8, 11, 14, 17, 19, 20, 21, 22, 23),
108(31, 1, 2, 3, 4, 9, 13, 14, 15, 17, 19, 20, 21, 22, 24, 25),
109(32, 1, 2, 4, 6, 7, 9, 10, 11, 14, 15, 16, 17, 20, 22, 23),
110(33, 1, 2, 5, 7, 8, 10, 11, 12, 14, 16, 19, 20, 21, 23, 24),
111(34, 1, 2, 4, 7, 8, 9, 10, 11, 15, 16, 18, 19, 20, 21, 23),
112(35, 1, 4, 5, 6, 11, 12, 13, 14, 16, 17, 19, 21, 22, 23, 25),
113(36, 1, 4, 5, 7, 8, 10, 11, 14, 17, 19, 20, 21, 22, 23, 24),
114(37, 1, 3, 4, 5, 8, 9, 10, 11, 13, 15, 20, 21, 22, 23, 24),
115(38, 1, 2, 3, 6, 7, 8, 9, 10, 13, 14, 15, 16, 22, 24, 25),
116(39, 2, 7, 8, 9, 11, 13, 14, 15, 17, 18, 19, 21, 22, 23, 24),
117(40, 1, 2, 5, 7, 8, 10, 12, 13, 14, 16, 17, 20, 21, 22, 24),
118(41, 2, 3, 4, 9, 12, 13, 15, 16, 17, 18, 19, 20, 21, 23, 25),
119(42, 1, 3, 4, 5, 6, 8, 11, 12, 14, 15, 17, 21, 22, 24, 25),
120(43, 1, 3, 6, 7, 8, 9, 10, 14, 17, 18, 19, 20, 22, 23, 24),
121(44, 3, 4, 5, 6, 10, 11, 12, 13, 14, 18, 19, 21, 23, 24, 25),
122(45, 1, 2, 3, 5, 7, 9, 14, 16, 17, 18, 19, 21, 23, 24, 25),
123(46, 1, 2, 4, 5, 6, 8, 10, 11, 14, 18, 19, 21, 23, 24, 25),
124(47, 1, 2, 3, 4, 5, 6, 8, 10, 11, 13, 15, 18, 20, 22, 25),
125(48, 2, 5, 6, 7, 11, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23),
126(49, 2, 4, 5, 6, 8, 11, 13, 15, 16, 19, 20, 21, 22, 23, 24),
127(50, 1, 2, 3, 6, 7, 9, 10, 11, 12, 13, 19, 20, 21, 23, 25),
128
129<?php
130mysql_connect ("localhost", "user","pass") or die (mysql_error());
131mysql_select_db ("database");
132
133$num1 = $_POST['num1'];
134$num2 = $_POST['num2'];
135$num3 = $_POST['num3'];
136$num4 = $_POST['num4'];
137$num5 = $_POST['num5'];
138$num6 = $_POST['num6'];
139$num7 = $_POST['num7'];
140$num8 = $_POST['num8'];
141$num9 = $_POST['num9'];
142$num10 = $_POST['num10'];
143$num11 = $_POST['num11'];
144$num12 = $_POST['num11'];
145
146$sql = mysql_query("select * from lotto_table where numbers like '%$num1%' AND numbers like '%$num2%' AND numbers like '%$num3%' AND numbers like '%$num4%' AND numbers like '%$num5%' AND numbers like '%$num6%' AND numbers like '%$num7%' AND numbers like '%$num8%' AND numbers like '%$num9%' AND numbers like '%$num10%' AND numbers like '%$num11%' AND numbers like '%$num12%'");
147
148while ($row = mysql_fetch_array($sql)){
149 echo 'Game: '.$row['id'];
150 echo '<br/> Numbers: '.$row['numbers'];
151 echo '<br/><br/>';
152 }
153
154?>
155
156CREATE TABLE IF NOT EXISTS `lotto_table` (
157 `id` int(4) NOT NULL AUTO_INCREMENT,
158 `n1` int(4) NOT NULL,
159 `n2` int(4) NOT NULL,
160 `n3` int(4) NOT NULL,
161 `n4` int(4) NOT NULL,
162 `n5` int(4) NOT NULL,
163 `n6` int(4) NOT NULL,
164 `n7` int(4) NOT NULL,
165 `n8` int(4) NOT NULL,
166 `n9` int(4) NOT NULL,
167 `n10` int(4) NOT NULL,
168 `n11` int(4) NOT NULL,
169 `n12` int(4) NOT NULL,
170 `n13` int(4) NOT NULL,
171 `n14` int(4) NOT NULL,
172 `n15` int(4) NOT NULL,
173 PRIMARY KEY (`id`)
174) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4
175
176INSERT INTO `lotto_table` (`n1`,`n2`,`n3`,`n4`,`n5`,`n6`,`n7`,`n8`,`n9`,`n10`,`n11`,`n12`,`n13`,`n14`,`n15`)
177VALUES
178(01, 04, 06, 07, 08, 09, 10, 11, 12, 14, 16, 17, 20, 23, 24),
179(01, 02, 04, 05, 08, 10, 12, 13, 16, 17, 18, 19, 23, 24, 25),
180(01, 02, 04, 08, 09, 11, 12, 13, 15, 16, 19, 20, 23, 24, 25),
181(01, 02, 04, 05, 06, 07, 10, 12, 15, 16, 17, 19, 21, 23, 25),
182(01, 04, 07, 08, 10, 12, 14, 15, 16, 18, 19, 21, 22, 23, 25),
183(01, 05, 06, 08, 09, 10, 13, 15, 16, 17, 18, 19, 20, 22, 25),
184(03, 04, 05, 09, 10, 11, 13, 15, 16, 17, 19, 20, 21, 24, 25),
185(02, 03, 04, 05, 06, 08, 09, 10, 11, 12, 14, 19, 20, 23, 24),
186(02, 06, 07, 08, 09, 10, 11, 12, 16, 19, 20, 22, 23, 24, 25),
187(01, 02, 04, 05, 07, 08, 09, 10, 11, 12, 14, 16, 17, 24, 25),
188(03, 05, 06, 07, 08, 09, 10, 11, 13, 14, 15, 16, 17, 19, 23),
189(01, 02, 05, 06, 07, 09, 13, 14, 15, 18, 19, 20, 21, 23, 25),
190(01, 02, 04, 06, 08, 10, 12, 15, 16, 18, 19, 21, 23, 24, 25),
191(02, 05, 06, 07, 08, 10, 12, 13, 15, 17, 19, 21, 23, 24, 25),
192(01, 02, 03, 05, 06, 07, 09, 13, 14, 16, 17, 18, 19, 20, 21),
193(02, 06, 07, 08, 10, 11, 14, 15, 17, 18, 19, 20, 22, 23, 24),
194(02, 05, 06, 07, 08, 10, 11, 13, 14, 15, 16, 17, 20, 23, 24),
195(03, 04, 06, 07, 08, 09, 10, 14, 16, 17, 18, 19, 20, 23, 24),
196(01, 02, 04, 05, 08, 11, 14, 16, 18, 19, 20, 22, 23, 24, 25),
197(01, 02, 03, 04, 05, 06, 07, 09, 10, 12, 13, 14, 15, 22, 25),
198(01, 03, 04, 05, 06, 08, 10, 11, 12, 14, 16, 17, 18, 19, 20),
199(01, 02, 03, 05, 07, 10, 11, 14, 17, 19, 20, 21, 23, 24, 25),
200(01, 02, 03, 04, 05, 06, 07, 09, 13, 14, 16, 20, 22, 23, 24),
201(05, 07, 08, 09, 10, 11, 13, 14, 16, 17, 19, 20, 21, 22, 23),
202(03, 06, 08, 10, 11, 12, 13, 14, 15, 18, 20, 21, 22, 24, 25),
203(01, 03, 07, 09, 10, 11, 12, 13, 14, 16, 17, 18, 19, 20, 21),
204(01, 04, 05, 06, 08, 09, 13, 14, 16, 17, 19, 20, 21, 22, 24),
205(01, 02, 03, 04, 06, 07, 08, 11, 14, 17, 19, 20, 21, 22, 23),
206(01, 02, 03, 04, 09, 13, 14, 15, 17, 19, 20, 21, 22, 24, 25),
207(01, 02, 04, 06, 07, 09, 10, 11, 14, 15, 16, 17, 20, 22, 23),
208(01, 02, 05, 07, 08, 10, 11, 12, 14, 16, 19, 20, 21, 23, 24),
209(01, 02, 04, 07, 08, 09, 10, 11, 15, 16, 18, 19, 20, 21, 23),
210(01, 04, 05, 06, 11, 12, 13, 14, 16, 17, 19, 21, 22, 23, 25),
211(01, 04, 05, 07, 08, 10, 11, 14, 17, 19, 20, 21, 22, 23, 24),
212(01, 03, 04, 05, 08, 09, 10, 11, 13, 15, 20, 21, 22, 23, 24),
213(01, 02, 03, 06, 07, 08, 09, 10, 13, 14, 15, 16, 22, 24, 25),
214(02, 07, 08, 09, 11, 13, 14, 15, 17, 18, 19, 21, 22, 23, 24),
215(01, 02, 05, 07, 08, 10, 12, 13, 14, 16, 17, 20, 21, 22, 24),
216(02, 03, 04, 09, 12, 13, 15, 16, 17, 18, 19, 20, 21, 23, 25),
217(01, 03, 04, 05, 06, 08, 11, 12, 14, 15, 17, 21, 22, 24, 25),
218(01, 03, 06, 07, 08, 09, 10, 14, 17, 18, 19, 20, 22, 23, 24),
219(03, 04, 05, 06, 10, 11, 12, 13, 14, 18, 19, 21, 23, 24, 25),
220(01, 02, 03, 05, 07, 09, 14, 16, 17, 18, 19, 21, 23, 24, 25),
221(01, 02, 04, 05, 06, 08, 10, 11, 14, 18, 19, 21, 23, 24, 25),
222(01, 02, 03, 04, 05, 06, 08, 10, 11, 13, 15, 18, 20, 22, 25),
223(02, 05, 06, 07, 11, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23),
224(02, 04, 05, 06, 08, 11, 13, 15, 16, 19, 20, 21, 22, 23, 24),
225(01, 02, 03, 06, 07, 09, 10, 11, 12, 13, 19, 20, 21, 23, 25);
226
227SELECT * FROM lotto_table WHERE
228 n1=$num1 AND
229 n2=$num2 AND
230 ....
231 ....
232 n11=$num11 AND
233 n12=$num12;