-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSqlQueryGenerator.php
231 lines (186 loc) · 22.5 KB
/
SqlQueryGenerator.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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
<?php
/** @noinspection SqlNoDataSourceInspection */
/** @noinspection SqlDialectInspection */
class SqlQueryGenerator
{
public static function generateEnQuery(string $pled, string $direcziun, string $modus): string {
$SQLString_0_exact = "SELECT * FROM `mypledari` WHERE `B2` LIKE '$pled' OR `B2` LIKE '%, $pled' OR `B2` LIKE '%, $pled, %' OR `B2` LIKE '$pled, %'";
$SQLString_0_entschatta = "SELECT * FROM `mypledari` WHERE `B2` LIKE '$pled%' OR `B2` LIKE '%, $pled%'";
$SQLString_0_intern = "SELECT * FROM `mypledari` WHERE `B2` LIKE '%$pled%'";
$SQLString_0_finiziun = "SELECT * FROM `mypledari` WHERE `B2` LIKE '%$pled' OR `B2` LIKE '%$pled, %'";
$SQLString_1_exact = "SELECT * FROM `mypledari` WHERE `A2` LIKE '$pled' OR `A2` LIKE '%, $pled' OR `A2` LIKE '%, $pled, %' OR `A2` LIKE '$pled, %'";
$SQLString_1_entschatta = "SELECT * FROM `mypledari` WHERE `A2` LIKE '$pled%' OR `A2` LIKE '%, $pled%'";
$SQLString_1_intern = "SELECT * FROM `mypledari` WHERE `A2` LIKE '%$pled%'";
$SQLString_1_finiziun = "SELECT * FROM `mypledari` WHERE `A2` LIKE '%$pled' OR `A2` LIKE '%$pled, %'";
$SQLString_2_exact = "SELECT * FROM `mypledari` WHERE `D2` LIKE '$pled' OR `D2` LIKE '%, $pled' OR `D2` LIKE '%, $pled, %' OR `D2` LIKE '$pled, %'";
$SQLString_2_entschatta = "SELECT * FROM `mypledari` WHERE `D2` LIKE '$pled%' OR `D2` LIKE '%, $pled%'";
$SQLString_2_intern = "SELECT * FROM `mypledari` WHERE `D2` LIKE '%$pled%'";
$SQLString_2_finiziun = "SELECT * FROM `mypledari` WHERE `D2` LIKE '%$pled' OR `D2` LIKE '%$pled, %'";
$SQLString_3_exact = "SELECT * FROM `mypledari` WHERE `E2` LIKE '$pled' OR `E2` LIKE '%, $pled' OR `E2` LIKE '%, $pled, %' OR `E2` LIKE '$pled, %'";
$SQLString_3_entschatta = "SELECT * FROM `mypledari` WHERE `E2` LIKE '$pled%' OR `E2` LIKE '%, $pled%'";
$SQLString_3_intern = "SELECT * FROM `mypledari` WHERE `E2` LIKE '%$pled%'";
$SQLString_3_finiziun = "SELECT * FROM `mypledari` WHERE `E2` LIKE '%$pled' OR `E2` LIKE '%$pled, %'";
$SQLString_4_exact = "SELECT * FROM `mypledari` WHERE `F2` LIKE '$pled' OR `F2` LIKE '%, $pled' OR `F2` LIKE '%, $pled, %' OR `F2` LIKE '$pled, %'";
$SQLString_4_entschatta = "SELECT * FROM `mypledari` WHERE `F2` LIKE '$pled%' OR `F2` LIKE '%, $pled%'";
$SQLString_4_intern = "SELECT * FROM `mypledari` WHERE `F2` LIKE '%$pled%'";
$SQLString_4_finiziun = "SELECT * FROM `mypledari` WHERE `F2` LIKE '%$pled' OR `F2` LIKE '%$pled, %'";
$SQLString_5_exact = "SELECT * FROM `mypledari` WHERE `G2` LIKE '$pled' OR `G2` LIKE '%, $pled' OR `G2` LIKE '%, $pled, %' OR `G2` LIKE '$pled, %'";
$SQLString_5_entschatta = "SELECT * FROM `mypledari` WHERE `G2` LIKE '$pled%' OR `G2` LIKE '%, $pled%'";
$SQLString_5_intern = "SELECT * FROM `mypledari` WHERE `G2` LIKE '%$pled%'";
$SQLString_5_finiziun = "SELECT * FROM `mypledari` WHERE `G2` LIKE '%$pled' OR `G2` LIKE '%$pled, %'";
$SQLString_6_exact = "SELECT * FROM `mypledari` WHERE `H2` LIKE '$pled' OR `H2` LIKE '%, $pled' OR `H2` LIKE '%, $pled, %' OR `H2` LIKE '$pled, %'";
$SQLString_6_entschatta = "SELECT * FROM `mypledari` WHERE `H2` LIKE '$pled%' OR `H2` LIKE '%, $pled%'";
$SQLString_6_intern = "SELECT * FROM `mypledari` WHERE `H2` LIKE '%$pled%'";
$SQLString_6_finiziun = "SELECT * FROM `mypledari` WHERE `H2` LIKE '%$pled' OR `H2` LIKE '%$pled, %'";
$SQLString_7_exact = "SELECT * FROM `mypledari` WHERE `D2` LIKE '$pled' OR `D2` LIKE '%, $pled' OR `D2` LIKE '%, $pled, %' OR `D2` LIKE '$pled, %' OR `E2` LIKE '$pled' OR `E2` LIKE '%, $pled' OR `E2` LIKE '%, $pled, %' OR `E2` LIKE '$pled, %' OR `F2` LIKE '$pled' OR `F2` LIKE '%, $pled' OR `F2` LIKE '%, $pled, %' OR `F2` LIKE '$pled, %' OR `G2` LIKE '$pled' OR `G2` LIKE '%, $pled' OR `G2` LIKE '%, $pled, %' OR `G2` LIKE '$pled, %' OR `H2` LIKE '$pled' OR `H2` LIKE '%, $pled' OR `H2` LIKE '%, $pled, %' OR `H2` LIKE '$pled, %' OR `A2` LIKE '$pled' OR `A2` LIKE '%, $pled' OR `A2` LIKE '%, $pled, %' OR
`A2` LIKE '$pled,%'";
$SQLString_7_entschatta = "SELECT * FROM `mypledari` WHERE `A2` LIKE '$pled%' OR `A2` LIKE '%, $pled%' OR `D2` LIKE '$pled%' OR `D2` LIKE '%, $pled%' OR `E2` LIKE '$pled%' OR `E2` LIKE '%, $pled%' OR `F2` LIKE '$pled%' OR `F2` LIKE '%, $pled%' OR `G2` LIKE '$pled%' OR `G2` LIKE '%, $pled%' OR `H2` LIKE '$pled%' OR `H2` LIKE '%, $pled%'";
$SQLString_7_intern = "SELECT * FROM `mypledari` WHERE `A2` LIKE '%$pled%' OR `D2` LIKE '%$pled%' OR `E2` LIKE '%$pled%' OR `F2` LIKE '%$pled%' OR `G2` LIKE '%$pled%' OR `H2` LIKE '%$pled%'";
$SQLString_7_finiziun = "SELECT * FROM `mypledari` WHERE `A2` LIKE '%$pled' OR `A2` LIKE '%$pled, %' OR `D2` LIKE '%$pled' OR `D2` LIKE '%$pled, %' OR `E2` LIKE '%$pled' OR `E2` LIKE '%$pled, %' OR `F2` LIKE '%$pled' OR `F2` LIKE '%$pled, %' OR `G2` LIKE '%$pled' OR `G2` LIKE '%$pled, %' OR `H2` LIKE '%$pled' OR `H2` LIKE '%$pled, %'";
$SQLString_8_exact = "SELECT * FROM `mypledari` WHERE `J2` LIKE '$pled'";
$SQLString_8_entschatta = "SELECT * FROM `mypledari` WHERE `J2` LIKE '$pled%'";
$SQLString_8_intern = "SELECT * FROM `mypledari` WHERE `J2` LIKE '%$pled%'";
$SQLString_8_finiziun = "SELECT * FROM `mypledari` WHERE `J2` LIKE '%$pled'";
$SQLString_9_exact = "SELECT * FROM `mypledari` WHERE `J1` LIKE '$pled'";
$SQLString_9_entschatta = "SELECT * FROM `mypledari` WHERE `J1` LIKE '$pled%'";
$SQLString_9_intern = "SELECT * FROM `mypledari` WHERE `J1` LIKE '%$pled%'";
$SQLString_9_finiziun = "SELECT * FROM `mypledari` WHERE `J1` LIKE '%$pled'";
$SQLString2 = @"SQLString_".@$direcziun."_".@$modus;
return @$$SQLString2;
}
public static function generateDeQuery(string $pled, string $direcziun, string $modus): string {
$SQLString_0_exact = "SELECT * FROM `meinpledari` WHERE `B2` LIKE '$pled' OR `B2` LIKE '%, $pled' OR `B2` LIKE '%, $pled, %' OR `B2` LIKE '$pled, %'";
$SQLString_0_entschatta = "SELECT * FROM `meinpledari` WHERE `B2` LIKE '$pled%' OR `B2` LIKE '%, $pled%'";
$SQLString_0_intern = "SELECT * FROM `meinpledari` WHERE `B2` LIKE '%$pled%'";
$SQLString_0_finiziun = "SELECT * FROM `meinpledari` WHERE `B2` LIKE '%$pled' OR `B2` LIKE '%$pled, %'";
$SQLString_1_exact = "SELECT * FROM `meinpledari` WHERE `A2` LIKE '$pled' OR `A2` LIKE '%, $pled' OR `A2` LIKE '%, $pled, %' OR `A2` LIKE '$pled, %'";
$SQLString_1_entschatta = "SELECT * FROM `meinpledari` WHERE `A2` LIKE '$pled%' OR `A2` LIKE '%, $pled%'";
$SQLString_1_intern = "SELECT * FROM `meinpledari` WHERE `A2` LIKE '%$pled%'";
$SQLString_1_finiziun = "SELECT * FROM `meinpledari` WHERE `A2` LIKE '%$pled' OR `A2` LIKE '%$pled, %'";
$SQLString_2_exact = "SELECT * FROM `meinpledari` WHERE `D2` LIKE '$pled' OR `D2` LIKE '%, $pled' OR `D2` LIKE '%, $pled, %' OR `D2` LIKE '$pled, %'";
$SQLString_2_entschatta = "SELECT * FROM `meinpledari` WHERE `D2` LIKE '$pled%' OR `D2` LIKE '%, $pled%'";
$SQLString_2_intern = "SELECT * FROM `meinpledari` WHERE `D2` LIKE '%$pled%'";
$SQLString_2_finiziun = "SELECT * FROM `meinpledari` WHERE `D2` LIKE '%$pled' OR `D2` LIKE '%$pled, %'";
$SQLString_3_exact = "SELECT * FROM `meinpledari` WHERE `E2` LIKE '$pled' OR `E2` LIKE '%, $pled' OR `E2` LIKE '%, $pled, %' OR `E2` LIKE '$pled, %'";
$SQLString_3_entschatta = "SELECT * FROM `meinpledari` WHERE `E2` LIKE '$pled%' OR `E2` LIKE '%, $pled%'";
$SQLString_3_intern = "SELECT * FROM `meinpledari` WHERE `E2` LIKE '%$pled%'";
$SQLString_3_finiziun = "SELECT * FROM `meinpledari` WHERE `E2` LIKE '%$pled' OR `E2` LIKE '%$pled, %'";
$SQLString_4_exact = "SELECT * FROM `meinpledari` WHERE `F2` LIKE '$pled' OR `F2` LIKE '%, $pled' OR `F2` LIKE '%, $pled, %' OR `F2` LIKE '$pled, %'";
$SQLString_4_entschatta = "SELECT * FROM `meinpledari` WHERE `F2` LIKE '$pled%' OR `F2` LIKE '%, $pled%'";
$SQLString_4_intern = "SELECT * FROM `meinpledari` WHERE `F2` LIKE '%$pled%'";
$SQLString_4_finiziun = "SELECT * FROM `meinpledari` WHERE `F2` LIKE '%$pled' OR `F2` LIKE '%$pled, %'";
$SQLString_5_exact = "SELECT * FROM `meinpledari` WHERE `G2` LIKE '$pled' OR `G2` LIKE '%, $pled' OR `G2` LIKE '%, $pled, %' OR `G2` LIKE '$pled, %'";
$SQLString_5_entschatta = "SELECT * FROM `meinpledari` WHERE `G2` LIKE '$pled%' OR `G2` LIKE '%, $pled%'";
$SQLString_5_intern = "SELECT * FROM `meinpledari` WHERE `G2` LIKE '%$pled%'";
$SQLString_5_finiziun = "SELECT * FROM `meinpledari` WHERE `G2` LIKE '%$pled' OR `G2` LIKE '%$pled, %'";
$SQLString_6_exact = "SELECT * FROM `meinpledari` WHERE `H2` LIKE '$pled' OR `H2` LIKE '%, $pled' OR `H2` LIKE '%, $pled, %' OR `H2` LIKE '$pled, %'";
$SQLString_6_entschatta = "SELECT * FROM `meinpledari` WHERE `H2` LIKE '$pled%' OR `H2` LIKE '%, $pled%'";
$SQLString_6_intern = "SELECT * FROM `meinpledari` WHERE `H2` LIKE '%$pled%'";
$SQLString_6_finiziun = "SELECT * FROM `meinpledari` WHERE `H2` LIKE '%$pled' OR `H2` LIKE '%$pled, %'";
$SQLString_7_exact = "SELECT * FROM `meinpledari` WHERE `D2` LIKE '$pled' OR `D2` LIKE '%, $pled' OR `D2` LIKE '%, $pled, %' OR `D2` LIKE '$pled, %' OR `E2` LIKE '$pled' OR `E2` LIKE '%, $pled' OR `E2` LIKE '%, $pled, %' OR `E2` LIKE '$pled, %' OR `F2` LIKE '$pled' OR `F2` LIKE '%, $pled' OR `F2` LIKE '%, $pled, %' OR `F2` LIKE '$pled, %' OR `G2` LIKE '$pled' OR `G2` LIKE '%, $pled' OR `G2` LIKE '%, $pled, %' OR `G2` LIKE '$pled, %' OR `H2` LIKE '$pled' OR `H2` LIKE '%, $pled' OR `H2` LIKE '%, $pled, %' OR `H2` LIKE '$pled, %' OR `A2` LIKE '$pled' OR `A2` LIKE '%, $pled' OR `A2` LIKE '%, $pled, %' OR
`A2` LIKE '$pled,%'";
$SQLString_7_entschatta = "SELECT * FROM `meinpledari` WHERE `A2` LIKE '$pled%' OR `A2` LIKE '%, $pled%' OR `D2` LIKE '$pled%' OR `D2` LIKE '%, $pled%' OR `E2` LIKE '$pled%' OR `E2` LIKE '%, $pled%' OR `F2` LIKE '$pled%' OR `F2` LIKE '%, $pled%' OR `G2` LIKE '$pled%' OR `G2` LIKE '%, $pled%' OR `H2` LIKE '$pled%' OR `H2` LIKE '%, $pled%'";
$SQLString_7_intern = "SELECT * FROM `meinpledari` WHERE `A2` LIKE '%$pled%' OR `D2` LIKE '%$pled%' OR `E2` LIKE '%$pled%' OR `F2` LIKE '%$pled%' OR `G2` LIKE '%$pled%' OR `H2` LIKE '%$pled%'";
$SQLString_7_finiziun = "SELECT * FROM `meinpledari` WHERE `A2` LIKE '%$pled' OR `A2` LIKE '%$pled, %' OR `D2` LIKE '%$pled' OR `D2` LIKE '%$pled, %' OR `E2` LIKE '%$pled' OR `E2` LIKE '%$pled, %' OR `F2` LIKE '%$pled' OR `F2` LIKE '%$pled, %' OR `G2` LIKE '%$pled' OR `G2` LIKE '%$pled, %' OR `H2` LIKE '%$pled' OR `H2` LIKE '%$pled, %'";
$SQLString_8_exact = "SELECT * FROM `meinpledari` WHERE `J2` LIKE '$pled'";
$SQLString_8_entschatta = "SELECT * FROM `meinpledari` WHERE `J2` LIKE '$pled%'";
$SQLString_8_intern = "SELECT * FROM `meinpledari` WHERE `J2` LIKE '%$pled%'";
$SQLString_8_finiziun = "SELECT * FROM `meinpledari` WHERE `J2` LIKE '%$pled'";
$SQLString_9_exact = "SELECT * FROM `meinpledari` WHERE `J1` LIKE '$pled'";
$SQLString_9_entschatta = "SELECT * FROM `meinpledari` WHERE `J1` LIKE '$pled%'";
$SQLString_9_intern = "SELECT * FROM `meinpledari` WHERE `J1` LIKE '%$pled%'";
$SQLString_9_finiziun = "SELECT * FROM `meinpledari` WHERE `J1` LIKE '%$pled'";
$SQLString2 = @"SQLString_".@$direcziun."_".@$modus;
return @$$SQLString2;
}
public static function generateItQuery(string $pled, string $direcziun, string $modus): string {
$SQLString_0_exact = "SELECT * FROM `miopledari` WHERE `B2` LIKE '$pled' OR `B2` LIKE '%, $pled' OR `B2` LIKE '%, $pled, %' OR `B2` LIKE '$pled, %'";
$SQLString_0_entschatta = "SELECT * FROM `miopledari` WHERE `B2` LIKE '$pled%' OR `B2` LIKE '%, $pled%'";
$SQLString_0_intern = "SELECT * FROM `miopledari` WHERE `B2` LIKE '%$pled%'";
$SQLString_0_finiziun = "SELECT * FROM `miopledari` WHERE `B2` LIKE '%$pled' OR `B2` LIKE '%$pled, %'";
$SQLString_1_exact = "SELECT * FROM `miopledari` WHERE `A2` LIKE '$pled' OR `A2` LIKE '%, $pled' OR `A2` LIKE '%, $pled, %' OR `A2` LIKE '$pled, %'";
$SQLString_1_entschatta = "SELECT * FROM `miopledari` WHERE `A2` LIKE '$pled%' OR `A2` LIKE '%, $pled%'";
$SQLString_1_intern = "SELECT * FROM `miopledari` WHERE `A2` LIKE '%$pled%'";
$SQLString_1_finiziun = "SELECT * FROM `miopledari` WHERE `A2` LIKE '%$pled' OR `A2` LIKE '%$pled, %'";
$SQLString_2_exact = "SELECT * FROM `miopledari` WHERE `D2` LIKE '$pled' OR `D2` LIKE '%, $pled' OR `D2` LIKE '%, $pled, %' OR `D2` LIKE '$pled, %'";
$SQLString_2_entschatta = "SELECT * FROM `miopledari` WHERE `D2` LIKE '$pled%' OR `D2` LIKE '%, $pled%'";
$SQLString_2_intern = "SELECT * FROM `miopledari` WHERE `D2` LIKE '%$pled%'";
$SQLString_2_finiziun = "SELECT * FROM `miopledari` WHERE `D2` LIKE '%$pled' OR `D2` LIKE '%$pled, %'";
$SQLString_3_exact = "SELECT * FROM `miopledari` WHERE `E2` LIKE '$pled' OR `E2` LIKE '%, $pled' OR `E2` LIKE '%, $pled, %' OR `E2` LIKE '$pled, %'";
$SQLString_3_entschatta = "SELECT * FROM `miopledari` WHERE `E2` LIKE '$pled%' OR `E2` LIKE '%, $pled%'";
$SQLString_3_intern = "SELECT * FROM `miopledari` WHERE `E2` LIKE '%$pled%'";
$SQLString_3_finiziun = "SELECT * FROM `miopledari` WHERE `E2` LIKE '%$pled' OR `E2` LIKE '%$pled, %'";
$SQLString_4_exact = "SELECT * FROM `miopledari` WHERE `F2` LIKE '$pled' OR `F2` LIKE '%, $pled' OR `F2` LIKE '%, $pled, %' OR `F2` LIKE '$pled, %'";
$SQLString_4_entschatta = "SELECT * FROM `miopledari` WHERE `F2` LIKE '$pled%' OR `F2` LIKE '%, $pled%'";
$SQLString_4_intern = "SELECT * FROM `miopledari` WHERE `F2` LIKE '%$pled%'";
$SQLString_4_finiziun = "SELECT * FROM `miopledari` WHERE `F2` LIKE '%$pled' OR `F2` LIKE '%$pled, %'";
$SQLString_5_exact = "SELECT * FROM `miopledari` WHERE `G2` LIKE '$pled' OR `G2` LIKE '%, $pled' OR `G2` LIKE '%, $pled, %' OR `G2` LIKE '$pled, %'";
$SQLString_5_entschatta = "SELECT * FROM `miopledari` WHERE `G2` LIKE '$pled%' OR `G2` LIKE '%, $pled%'";
$SQLString_5_intern = "SELECT * FROM `miopledari` WHERE `G2` LIKE '%$pled%'";
$SQLString_5_finiziun = "SELECT * FROM `miopledari` WHERE `G2` LIKE '%$pled' OR `G2` LIKE '%$pled, %'";
$SQLString_6_exact = "SELECT * FROM `miopledari` WHERE `H2` LIKE '$pled' OR `H2` LIKE '%, $pled' OR `H2` LIKE '%, $pled, %' OR `H2` LIKE '$pled, %'";
$SQLString_6_entschatta = "SELECT * FROM `miopledari` WHERE `H2` LIKE '$pled%' OR `H2` LIKE '%, $pled%'";
$SQLString_6_intern = "SELECT * FROM `miopledari` WHERE `H2` LIKE '%$pled%'";
$SQLString_6_finiziun = "SELECT * FROM `miopledari` WHERE `H2` LIKE '%$pled' OR `H2` LIKE '%$pled, %'";
$SQLString_7_exact = "SELECT * FROM `miopledari` WHERE `D2` LIKE '$pled' OR `D2` LIKE '%, $pled' OR `D2` LIKE '%, $pled, %' OR `D2` LIKE '$pled, %' OR `E2` LIKE '$pled' OR `E2` LIKE '%, $pled' OR `E2` LIKE '%, $pled, %' OR `E2` LIKE '$pled, %' OR `F2` LIKE '$pled' OR `F2` LIKE '%, $pled' OR `F2` LIKE '%, $pled, %' OR `F2` LIKE '$pled, %' OR `G2` LIKE '$pled' OR `G2` LIKE '%, $pled' OR `G2` LIKE '%, $pled, %' OR `G2` LIKE '$pled, %' OR `H2` LIKE '$pled' OR `H2` LIKE '%, $pled' OR `H2` LIKE '%, $pled, %' OR `H2` LIKE '$pled, %' OR `A2` LIKE '$pled' OR `A2` LIKE '%, $pled' OR `A2` LIKE '%, $pled, %' OR
`A2` LIKE '$pled,%'";
$SQLString_7_entschatta = "SELECT * FROM `miopledari` WHERE `A2` LIKE '$pled%' OR `A2` LIKE '%, $pled%' OR `D2` LIKE '$pled%' OR `D2` LIKE '%, $pled%' OR `E2` LIKE '$pled%' OR `E2` LIKE '%, $pled%' OR `F2` LIKE '$pled%' OR `F2` LIKE '%, $pled%' OR `G2` LIKE '$pled%' OR `G2` LIKE '%, $pled%' OR `H2` LIKE '$pled%' OR `H2` LIKE '%, $pled%'";
$SQLString_7_intern = "SELECT * FROM `miopledari` WHERE `A2` LIKE '%$pled%' OR `D2` LIKE '%$pled%' OR `E2` LIKE '%$pled%' OR `F2` LIKE '%$pled%' OR `G2` LIKE '%$pled%' OR `H2` LIKE '%$pled%'";
$SQLString_7_finiziun = "SELECT * FROM `miopledari` WHERE `A2` LIKE '%$pled' OR `A2` LIKE '%$pled, %' OR `D2` LIKE '%$pled' OR `D2` LIKE '%$pled, %' OR `E2` LIKE '%$pled' OR `E2` LIKE '%$pled, %' OR `F2` LIKE '%$pled' OR `F2` LIKE '%$pled, %' OR `G2` LIKE '%$pled' OR `G2` LIKE '%$pled, %' OR `H2` LIKE '%$pled' OR `H2` LIKE '%$pled, %'";
$SQLString_8_exact = "SELECT * FROM `miopledari` WHERE `J2` LIKE '$pled'";
$SQLString_8_entschatta = "SELECT * FROM `miopledari` WHERE `J2` LIKE '$pled%'";
$SQLString_8_intern = "SELECT * FROM `miopledari` WHERE `J2` LIKE '%$pled%'";
$SQLString_8_finiziun = "SELECT * FROM `miopledari` WHERE `J2` LIKE '%$pled'";
$SQLString_9_exact = "SELECT * FROM `miopledari` WHERE `J1` LIKE '$pled'";
$SQLString_9_entschatta = "SELECT * FROM `miopledari` WHERE `J1` LIKE '$pled%'";
$SQLString_9_intern = "SELECT * FROM `miopledari` WHERE `J1` LIKE '%$pled%'";
$SQLString_9_finiziun = "SELECT * FROM `miopledari` WHERE `J1` LIKE '%$pled'";
$SQLString2 = @"SQLString_".@$direcziun."_".@$modus;
return @$$SQLString2;
}
public static function generateFrQuery(string $pled, string $direcziun, string $modus): string {
$SQLString_0_exact = "SELECT * FROM `monpledari` WHERE `B2` LIKE '$pled' OR `B2` LIKE '%, $pled' OR `B2` LIKE '%, $pled, %' OR `B2` LIKE '$pled, %'";
$SQLString_0_entschatta = "SELECT * FROM `monpledari` WHERE `B2` LIKE '$pled%' OR `B2` LIKE '%, $pled%'";
$SQLString_0_intern = "SELECT * FROM `monpledari` WHERE `B2` LIKE '%$pled%'";
$SQLString_0_finiziun = "SELECT * FROM `monpledari` WHERE `B2` LIKE '%$pled' OR `B2` LIKE '%$pled, %'";
$SQLString_1_exact = "SELECT * FROM `monpledari` WHERE `A2` LIKE '$pled' OR `A2` LIKE '%, $pled' OR `A2` LIKE '%, $pled, %' OR `A2` LIKE '$pled, %'";
$SQLString_1_entschatta = "SELECT * FROM `monpledari` WHERE `A2` LIKE '$pled%' OR `A2` LIKE '%, $pled%'";
$SQLString_1_intern = "SELECT * FROM `monpledari` WHERE `A2` LIKE '%$pled%'";
$SQLString_1_finiziun = "SELECT * FROM `monpledari` WHERE `A2` LIKE '%$pled' OR `A2` LIKE '%$pled, %'";
$SQLString_2_exact = "SELECT * FROM `monpledari` WHERE `D2` LIKE '$pled' OR `D2` LIKE '%, $pled' OR `D2` LIKE '%, $pled, %' OR `D2` LIKE '$pled, %'";
$SQLString_2_entschatta = "SELECT * FROM `monpledari` WHERE `D2` LIKE '$pled%' OR `D2` LIKE '%, $pled%'";
$SQLString_2_intern = "SELECT * FROM `monpledari` WHERE `D2` LIKE '%$pled%'";
$SQLString_2_finiziun = "SELECT * FROM `monpledari` WHERE `D2` LIKE '%$pled' OR `D2` LIKE '%$pled, %'";
$SQLString_3_exact = "SELECT * FROM `monpledari` WHERE `E2` LIKE '$pled' OR `E2` LIKE '%, $pled' OR `E2` LIKE '%, $pled, %' OR `E2` LIKE '$pled, %'";
$SQLString_3_entschatta = "SELECT * FROM `monpledari` WHERE `E2` LIKE '$pled%' OR `E2` LIKE '%, $pled%'";
$SQLString_3_intern = "SELECT * FROM `monpledari` WHERE `E2` LIKE '%$pled%'";
$SQLString_3_finiziun = "SELECT * FROM `monpledari` WHERE `E2` LIKE '%$pled' OR `E2` LIKE '%$pled, %'";
$SQLString_4_exact = "SELECT * FROM `monpledari` WHERE `F2` LIKE '$pled' OR `F2` LIKE '%, $pled' OR `F2` LIKE '%, $pled, %' OR `F2` LIKE '$pled, %'";
$SQLString_4_entschatta = "SELECT * FROM `monpledari` WHERE `F2` LIKE '$pled%' OR `F2` LIKE '%, $pled%'";
$SQLString_4_intern = "SELECT * FROM `monpledari` WHERE `F2` LIKE '%$pled%'";
$SQLString_4_finiziun = "SELECT * FROM `monpledari` WHERE `F2` LIKE '%$pled' OR `F2` LIKE '%$pled, %'";
$SQLString_5_exact = "SELECT * FROM `monpledari` WHERE `G2` LIKE '$pled' OR `G2` LIKE '%, $pled' OR `G2` LIKE '%, $pled, %' OR `G2` LIKE '$pled, %'";
$SQLString_5_entschatta = "SELECT * FROM `monpledari` WHERE `G2` LIKE '$pled%' OR `G2` LIKE '%, $pled%'";
$SQLString_5_intern = "SELECT * FROM `monpledari` WHERE `G2` LIKE '%$pled%'";
$SQLString_5_finiziun = "SELECT * FROM `monpledari` WHERE `G2` LIKE '%$pled' OR `G2` LIKE '%$pled, %'";
$SQLString_6_exact = "SELECT * FROM `monpledari` WHERE `H2` LIKE '$pled' OR `H2` LIKE '%, $pled' OR `H2` LIKE '%, $pled, %' OR `H2` LIKE '$pled, %'";
$SQLString_6_entschatta = "SELECT * FROM `monpledari` WHERE `H2` LIKE '$pled%' OR `H2` LIKE '%, $pled%'";
$SQLString_6_intern = "SELECT * FROM `monpledari` WHERE `H2` LIKE '%$pled%'";
$SQLString_6_finiziun = "SELECT * FROM `monpledari` WHERE `H2` LIKE '%$pled' OR `H2` LIKE '%$pled, %'";
$SQLString_7_exact = "SELECT * FROM `monpledari` WHERE `D2` LIKE '$pled' OR `D2` LIKE '%, $pled' OR `D2` LIKE '%, $pled, %' OR `D2` LIKE '$pled, %' OR `E2` LIKE '$pled' OR `E2` LIKE '%, $pled' OR `E2` LIKE '%, $pled, %' OR `E2` LIKE '$pled, %' OR `F2` LIKE '$pled' OR `F2` LIKE '%, $pled' OR `F2` LIKE '%, $pled, %' OR `F2` LIKE '$pled, %' OR `G2` LIKE '$pled' OR `G2` LIKE '%, $pled' OR `G2` LIKE '%, $pled, %' OR `G2` LIKE '$pled, %' OR `H2` LIKE '$pled' OR `H2` LIKE '%, $pled' OR `H2` LIKE '%, $pled, %' OR `H2` LIKE '$pled, %' OR `A2` LIKE '$pled' OR `A2` LIKE '%, $pled' OR `A2` LIKE '%, $pled, %' OR
`A2` LIKE '$pled,%'";
$SQLString_7_entschatta = "SELECT * FROM `monpledari` WHERE `A2` LIKE '$pled%' OR `A2` LIKE '%, $pled%' OR `D2` LIKE '$pled%' OR `D2` LIKE '%, $pled%' OR `E2` LIKE '$pled%' OR `E2` LIKE '%, $pled%' OR `F2` LIKE '$pled%' OR `F2` LIKE '%, $pled%' OR `G2` LIKE '$pled%' OR `G2` LIKE '%, $pled%' OR `H2` LIKE '$pled%' OR `H2` LIKE '%, $pled%'";
$SQLString_7_intern = "SELECT * FROM `monpledari` WHERE `A2` LIKE '%$pled%' OR `D2` LIKE '%$pled%' OR `E2` LIKE '%$pled%' OR `F2` LIKE '%$pled%' OR `G2` LIKE '%$pled%' OR `H2` LIKE '%$pled%'";
$SQLString_7_finiziun = "SELECT * FROM `monpledari` WHERE `A2` LIKE '%$pled' OR `A2` LIKE '%$pled, %' OR `D2` LIKE '%$pled' OR `D2` LIKE '%$pled, %' OR `E2` LIKE '%$pled' OR `E2` LIKE '%$pled, %' OR `F2` LIKE '%$pled' OR `F2` LIKE '%$pled, %' OR `G2` LIKE '%$pled' OR `G2` LIKE '%$pled, %' OR `H2` LIKE '%$pled' OR `H2` LIKE '%$pled, %'";
$SQLString_8_exact = "SELECT * FROM `monpledari` WHERE `J2` LIKE '$pled'";
$SQLString_8_entschatta = "SELECT * FROM `monpledari` WHERE `J2` LIKE '$pled%'";
$SQLString_8_intern = "SELECT * FROM `monpledari` WHERE `J2` LIKE '%$pled%'";
$SQLString_8_finiziun = "SELECT * FROM `monpledari` WHERE `J2` LIKE '%$pled'";
$SQLString_9_exact = "SELECT * FROM `monpledari` WHERE `J1` LIKE '$pled'";
$SQLString_9_entschatta = "SELECT * FROM `monpledari` WHERE `J1` LIKE '$pled%'";
$SQLString_9_intern = "SELECT * FROM `monpledari` WHERE `J1` LIKE '%$pled%'";
$SQLString_9_finiziun = "SELECT * FROM `monpledari` WHERE `J1` LIKE '%$pled'";
$SQLString2 = @"SQLString_".@$direcziun."_".@$modus;
return @$$SQLString2;
}
}