/
Gists
/
Zyla simple parser
On gists
PHP
Zyla simple parser
parser.php Raw #
<?php
$x = file_get_contents($file);
$final = preg_match("~<tr[^>]*>(.+)</tr>~si", $x, $match);
$lastTr = strpos($match[0], '</tr>');
$match[0] = substr($match[0], $lastTr + 8, strlen($match[0]));
file_put_contents("frag.txt", $match[0]);
$f = fopen("frag.txt", "r");
$cols = array("kolo", "datum", "cas", "domaci", "hoste", "skore", "strelci_karty");
//$in_td = false;
$rows = array();
while (!feof($f))
{
$r = fgets($f);
# preskocit prazdne radky
if ( trim($r) != '' )
{
if (strpos($r, '<tr') !== false)
{
// $in_td=true;
$rows = array();
}
else
{
if (strpos($r, '</tr') !== false)
{
//$in_td = false;
#zpracuju $rows
if (count($rows) == 8)
{
#mam v prvni bunce kolo
$kolo = array_shift($rows);
}
zapis_insert($kolo, $rows);
//print_r($rows);
}
else
{
if (strpos($r, '<td') !== false)
{
$t = preg_replace('/<[^>]*>/', '', trim($r));
$rows[] = $t;
}
}
}
}
}fragment.txt Raw #
<tr>
<td rowspan=6 align="center" valign="middle"><font size=-2>1. KOLO</font></td>
<td align="center"><font size=-2>22.4.</font></td>
<td align="center"><font size=-2>17:00</font></td>
<td align="left"><font size=-2>BALKAN BOYS</font></td>
<td align="left"><font size=-2>FC FOFO</font></td>
<td align="right"><font size=-2><B> </B></font></td>
<td align="right"><font size=-2> </font></td>
<td align="left"><font size=-2>ODLOŽENO</font></td>
</tr>
<tr>
<td align="center"><font size=-2>22.4.</font></td>
<td align="center"><font size=-2>17:53</font></td>
<td align="left"><font size=-2>MĚŠIČÁCI</font></td>
<td align="left"><font size=-2>PANTEROS NEGROS</font></td>
<td align="right"><font size=-2><B>12:4</B></font></td>
<td align="right"><font size=-2>5:1</font></td>
<td align="left"><font size=-2>Nešpor Luboš 2,Sedlmajer Pavel 4,Svoboda Václav 2,Bednář Ondřej 4 - Zdobinský Jan,Procházka Tomáš 3</font></td>
</tr>
<tr>
<td align="center"><font size=-2>22.4.</font></td>
<td align="center"><font size=-2>18:46</font></td>
<td align="left"><font size=-2>DVĚ PROMILE</font></td>
<td align="left"><font size=-2>MARIMEX TEAM</font></td>
<td align="right"><font size=-2><B>15:1</B></font></td>
<td align="right"><font size=-2>7:0</font></td>
<td align="left"><font size=-2>Hněvkovský Jaroslav,Mousesyan Artem 2,Bock Petr 9,Petík Ladislav,Konfršt Jan 2 - Houser Jiří</font></td>
</tr>
<tr>
<td align="center"><font size=-2>22.4.</font></td>
<td align="center"><font size=-2>19:39</font></td>
<td align="left"><font size=-2>VZP LUFŤÁCI</font></td>
<td align="left"><font size=-2>BANDITAS ŽIŽKOV</font></td>
<td align="right"><font size=-2><B>1:7</B></font></td>
<td align="right"><font size=-2>0:1</font></td>
<td align="left"><font size=-2>Kala Viktor - Matucha Jan 3,Havel Michal,Pilc Antonín 2,Vančura Ondřej</font></td>
</tr>
<tr>
<td align="center"><font size=-2>22.4.</font></td>
<td align="center"><font size=-2>20:32</font></td>
<td align="left"><font size=-2>FURT HIGH</font></td>
<td align="left"><font size=-2>DAFC</font></td>
<td align="right"><font size=-2><B>2:4</B></font></td>
<td align="right"><font size=-2>0:1</font></td>
<td align="left"><font size=-2>Tajchman Jan,Koutský Tomáš - Dub Václav 2,Chuman Marek,Vavruška Ladislav</font></td>
</tr>
<tr>
<td align="center"><font size=-2>22.4.</font></td>
<td align="center"><font size=-2>21:25</font></td>
<td align="left"><font size=-2>EL DRAGON</font></td>
<td align="left"><font size=-2>FC VEČERNÍČEK</font></td>
<td align="right"><font size=-2><B>6:1</B></font></td>
<td align="right"><font size=-2>2:0</font></td>
<td align="left"><font size=-2>Pokuta Daniel,Týborec Josef 2,Jon Ondřej 3 - Herman Marek</font></td>
</tr>
<tr>
<td rowspan=6 align="center" valign="middle"><font size=-2>2. KOLO</font></td>
<td align="center"><font size=-2>29.4.</font></td>
<td align="center"><font size=-2>17:00</font></td>
<td align="left"><font size=-2>BANDITAS ŽIŽKOV</font></td>
<td align="left"><font size=-2>FURT HIGH</font></td>
<td align="right"><font size=-2><B>2:7</B></font></td>
<td align="right"><font size=-2>2:3</font></td>
<td align="left"><font size=-2>Matucha Jan,Koudela Jindřich - Tajchman Jan,Fritz Martin,Koutský Tomáš 2,Cvetkov Jan 3</font></td>
</tr>
<tr>
<td align="center"><font size=-2>29.4.</font></td>
<td align="center"><font size=-2>17:53</font></td>
<td align="left"><font size=-2>FC FOFO</font></td>
<td align="left"><font size=-2>DAFC</font></td>
<td align="right"><font size=-2><B>8:5</B></font></td>
<td align="right"><font size=-2>2:1</font></td>
<td align="left"><font size=-2>Schreiber Michal,Ejem Michal,Nosek Pavel 3,Neubauer Miroslav 3 - Chuman Marek,Urban Karel,Kosmata Miroslav,Chuman Martin,Královec Marcel</font></td>
</tr>
<tr>
<td align="center"><font size=-2>29.4.</font></td>
<td align="center"><font size=-2>18:46</font></td>
<td align="left"><font size=-2>FC VEČERNÍČEK</font></td>
<td align="left"><font size=-2>MĚŠIČÁCI</font></td>
<td align="right"><font size=-2><B>10:7</B></font></td>
<td align="right"><font size=-2>4:2</font></td>
<td align="left"><font size=-2>Herman Marek 2,Sochr Ivan,Tkáč Ivan 4,Černý Daniel 2,Smolka Jakub - Nešpor Luboš 4,Pelc Jiří,Bednář Ondřej 2</font></td>
</tr>
<tr>
<td align="center"><font size=-2>29.4.</font></td>
<td align="center"><font size=-2>19:39</font></td>
<td align="left"><font size=-2>PANTEROS NEGROS</font></td>
<td align="left"><font size=-2>DVĚ PROMILE</font></td>
<td align="right"><font size=-2><B>3:12</B></font></td>
<td align="right"><font size=-2>2:4</font></td>
<td align="left"><font size=-2>Duda Tomáš,Fuksa Tomáš,Procházka Tomáš - Žirko Pavel 4,Bock Petr 4,Lisý Marek 3,Sekyra Petr</font></td>
</tr>