traitement fichier en php

Bonjour,
j'ai un fichier que je veux l’insérer sur une base mysql comme suite,
1) id = 0 , nom_bouquet=ALJAZEERA, code=0001:ffbaaaf0:0001:0001:1
2) id = 0 , nom_bouquet=ALJAZEERA, code=0002:ffbaaaf0:0001:0001:1
3) ...
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 bouquets 0 AL JAZEERA 0001:ffbaaaf0:0001:0001:1 0002:ffbaaaf0:0001:0001:1 0003:ffbaaaf0:0001:0001:1 0006:ffbaaaf0:0001:0001:1 0007:ffbaaaf0:0001:0001:1 / 1 NOORSAT 0002:ffba0000:0014:006e:1 0003:ffba0000:0014:006e:1 0005:ffba0000:0013:006e:1 0005:ffba0000:0014:006e:1 / 2 HARMONIC 0018:ffba0000:0021:0800:1 0afa:ffba0000:001c:0800:1 100d:ffba0000:0029:0800:1 1020:ffba0000:0029:0800:1 /

Bonjour,

Code:

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
<?php
$text = "bouquets
0
AL JAZEERA
0001:ffbaaaf0:0001:0001:1
0002:ffbaaaf0:0001:0001:1
0003:ffbaaaf0:0001:0001:1
0006:ffbaaaf0:0001:0001:1
0007:ffbaaaf0:0001:0001:1
/
1
NOORSAT
0002:ffba0000:0014:006e:1
0003:ffba0000:0014:006e:1
0005:ffba0000:0013:006e:1
0005:ffba0000:0014:006e:1
/
2
HARMONIC
0018:ffba0000:0021:0800:1
0afa:ffba0000:001c:0800:1
100d:ffba0000:0029:0800:1
1020:ffba0000:0029:0800:1
/";
 
$q = '';
$i = 0;
$T = explode('/', $text);
$T = array_map('trim', $T);
foreach ($T as $slice) {
	$T2 = explode("\n", $slice);
	$T2 = array_map('trim', $T2);
	if ($i == 0) 
		array_shift($T2);
 
	array_shift($T2);
	$nom_bouquet = array_shift($T2);
 
	foreach ($T2 as $code) {
		if (empty($code))
			continue;
 
		if ($i>0)
			$q .= "\n";
 
		$q .= "id=0, nom_bouquet=".$nom_bouquet.", code=".$code;
 
		$i ++;
	}
}
 
echo $q;

Merci bcp,
j'ai essayer avec un autre fichier pou mieux comprendre,

explode() pour end,
récupère les tableaux, et tariter comme suite,
transponders : 2ligne je pense explode() par / .
services : 3ligne par enregistrement :cry:

voici le code :

Code:

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
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
<?php
$text = "eDVB services /2/
transponders
ffba0000:0012:006e
	s 10873000:27500000:1:0:-70:2:0
/
ffba0000:0013:006e
	s 11317000:27500000:1:0:-70:2:0
/
ffba0000:0014:006e
	s 10892000:27500000:0:0:-70:2:0
/
ffba0000:0001:0800
	s 11747000:27500000:1:0:-70:2:0
/
ffba0000:0005:0800
	s 11766000:27500000:0:0:-70:2:0
/
ffba0000:0006:0800
	s 11843000:27500000:0:0:-70:2:0
/
ffba0000:0007:0800
	s 12034000:27500000:0:0:-70:2:0
/
ffba0000:0008:0800
	s 11958000:27500000:0:0:-70:2:0
/
end
services
01f9:ffba0000:0005:0800:1:474
NileTV
p:ERTU
01fa:ffba0000:0005:0800:1:475
AL masriya
p:ERTU
01fb:ffba0000:0005:0800:1:476
LYBIA ALRIADYA
p:ERTU
01fc:ffba0000:0005:0800:1:477
Ashrooq Tv
p:Ashrooq TV
01fe:ffba0000:0005:0800:1:478
Alrai TV
p:NILESAT
0203:ffba0000:0005:0800:1:479
Yemen today
p:NILESAT
03f0:ffba0000:0320:0800:1:395
Al Malakoot
p:STN Ltd
03f1:ffba0000:0320:0800:1:396
Dua Channel
p:STN Ltd
03f2:ffba0000:0320:0800:1:397
Libya Awalan
p:STN Ltd
03f3:ffba0000:0320:0800:1:398
PTV
p:STN Ltd
03f4:ffba0000:0320:0800:1:399
MMC
p:STN Ltd
03f5:ffba0000:0320:0800:1:400
Elhiwar Ettounsi TV
p:STN Ltd
03f6:ffba0000:0320:0800:1:401
Aden Live
p:STN Ltd
03f7:ffba0000:0320:0800:1:402
Sat7 Kids
p:STN Ltd
03f8:ffba0000:0320:0800:1:403
Sat7
p:STN Ltd
03f9:ffba0000:0320:0800:1:404
Noursat
p:STN Ltd
03fa:ffba0000:0320:0800:1:405
Hod Hod
p:STN Ltd
03fb:ffba0000:0320:0800:1:406
Al Alam News Channel
p:STN Ltd
03fc:ffba0000:0320:0800:1:407
Payam TV
p:STN Ltd
03fd:ffba0000:0320:0800:1:408
Newroz TV
p:STN Ltd
03fe:ffba0000:0320:0800:1:409
inta omri tv
p:STN Ltd
03ff:ffba0000:0320:0800:1:410
Alruqia TV
p:STN Ltd
0400:ffba0000:0320:0800:1:411
Al-Falak
p:STN 
0401:ffba0000:0320:0800:1:412
!Ana Bintizarek
p:STN Ltd
0402:ffba0000:0320:0800:1:413
Anta Oana Obs
p:STN Ltd
0403:ffba0000:0320:0800:2:414
IRIB 3IR IB6
p:STN Ltd
0404:ffba0000:0320:0800:2:415
Radio All For Peace
p:STN Ltd
0405:ffba0000:0320:0800:1:416
Fashion One
p:STN Ltd
0406:ffba0000:0320:0800:1:417
Sterk TV
p:STN Ltd
0407:ffba0000:0320:0800:2:418
ESAT Radio
p:STN Ltd
0408:ffba0000:0320:0800:2:419
Radio Mesopotamya
p:STN Ltd
044e:ffba0000:000b:0800:1:526
Alhurra
p:NILESAT
044f:ffba0000:000b:0800:1:527
Palestine
p:NILESAT
0450:ffba0000:000b:0800:1:528
AL MAGHRIBIA
p:NILESAT
0451:ffba0000:000b:0800:1:529
AL Rahma
p:NILESAT
0452:ffba0000:000b:0800:1:530
Oman 
p:NILESAT
0453:ffba0000:000b:0800:1:531
Bahrain
p:NILESAT
0454:ffba0000:000b:0800:1:532
Kuwait
p:NILESAT
0456:ffba0000:000b:0800:1:533
Syria
p:NILESAT
0457:ffba0000:000b:0800:1:534
Mehwer
p:NILESAT
0458:ffba0000:000b:0800:1:535
AlThuraya
p:NILESAT
0459:ffba0000:000b:0800:1:536
Kuwait Sport & +
p:NILESAT
045a:ffba0000:000b:0800:1:537
Sada El Balad
p:NILESAT
045b:ffba0000:000b:0800:1:538
AD Emirates
p:NILESAT
045f:ffba0000:000b:0800:2:539
KWT-Quran
p:NILESAT
0460:ffba0000:000b:0800:2:540
KW Radio
p:NILESAT
0461:ffba0000:000b:0800:2:541
Syria R3
p:NILESAT
0462:ffba0000:000b:0800:2:542
Syria R1
p:NILESAT
0463:ffba0000:000b:0800:2:543
Syria R2
p:NILESAT
0464:ffba0000:000b:0800:2:544
Oman Arabic Radio
p:NILESAT
0465:ffba0000:000b:0800:2:545
Oman English Radio
p:NILESAT
0466:ffba0000:000b:0800:2:546
NEW FM Oman
p:NILESAT
0467:ffba0000:000b:0800:2:547
Oman -Quran
p:NILESAT
0468:ffba0000:000b:0800:2:548
OUS Sudan Radio
p:Nilesat
0469:ffba0000:000b:0800:2:549
Radio National
p:Nilesat
046a:ffba0000:000b:0800:2:550
Palestine Radio
p:Nilesat
04b1:ffba0000:000c:0800:1:741
Arabica TV
p:Nilesat Libanon
04b2:ffba0000:000c:0800:1:742
NBN
p:Nilesat Libanon
04b3:ffba0000:000c:0800:1:743
Heya
p:Nilesat Libanon
04b4:ffba0000:000c:0800:1:744
AL JADEED
p:Nilesat Libanon
04b5:ffba0000:000c:0800:1:745
MANAR
p:Nilesat Libanon
04b6:ffba0000:000c:0800:1:746
Hawakom
p:Nilesat Libanon
04b7:ffba0000:000c:0800:1:747
Test
p:Nilesat Libanon
04b9:ffba0000:000c:0800:1:748
Test
p:Nilesat Libanon
04ba:ffba0000:000c:0800:1:749
Test
p:Nilesat Libanon
04bb:ffba0000:000c:0800:1:750
Test
p:Nilesat Libanon
04bd:ffba0000:000c:0800:1:751
MTV Lebanon
p:Nilesat Libanon
04bf:ffba0000:000c:0800:1:752
Sumaria
p:Nilesat Libanon
04c0:ffba0000:000c:0800:1:753
Test1
p:Nilesat Libanon
04c4:ffba0000:000c:0800:2:754
RFI
p:Nilesat Libanon
04c5:ffba0000:000c:0800:2:755
Sumer FM
p:Nilesat Libanon
04c6:ffba0000:000c:0800:2:756
Leb Radio 3
p:Nilesat Libanon
04c7:ffba0000:000c:0800:2:757
Leb Radio4
p:Nilesat Libanon
04c8:ffba0000:000c:0800:2:758
NOUR
p:Nilesat Libanon
04c9:ffba0000:000c:0800:2:759
Leb Radio6
p:Nilesat Libanon
0515:ffba0000:000d:0800:1:675
Medi1 TV
p:Nilesat
0516:ffba0000:000d:0800:1:676
CCTV9
p:NILESAT
0517:ffba0000:000d:0800:1:677
Berges TV
p:NILESAT
0518:ffba0000:000d:0800:1:678
Melody 
p:NILESAT
0519:ffba0000:000d:0800:1:679
Smile TV
p:NILESAT
051a:ffba0000:000d:0800:1:680
Top TV
p:NILESAT
051b:ffba0000:000d:0800:1:681
A1 Shop
p:NILESAT
051c:ffba0000:000d:0800:1:682
2M Maroc
p:NILESAT
051d:ffba0000:000d:0800:1:683
SPTV
p:NILESAT
051e:ffba0000:000d:0800:1:684
end
subservices
...
end
Have a lot of fun!";
 
$q = '';
$T = explode('eDVB services /2/', $text);
$text2 = implode($T[1],$T);
$have = explode('Have a lot of fun!', $text2);
$have2 = implode($have[0],$have);
$T1 = explode('end', $have2);
 
$T1 = array_map('trim', $T1);
 
	foreach ($T1 as $ligne => $slice){
 
		$T2 = explode("\n", $slice);
 
		$titre = array_shift($T2);
		$T2 = array_map('trim', $T2);
 
		foreach ($T2 as $code) {
		 if (empty($code))
			 continue;
 
		 if ($ligne > 0)
		 $q .= "\n";
 
		 $q .= "id=".$ligne.", titre = ".$titre.", code = ".$code;
		 $q .= "<br>";
 
		}
	}
echo $q;
 
?>