extracting data from html
| From: | Adrian D'Costa | Date: | Tue, 31 Jul 2001 05:07:20 +0000 |
| Subject: | extracting data from html | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-60320@lists.php.net to get a copy of this message | ||
Hi,
This mail is very looong as I have included the code. What I need is to
extract certian text from the html file and dump it into mysql
table. This is what the html looks like (code below). The mysql part can
wait now. I have given comment between each file. As of now the php is
just printing the html table. Can someone tell me what next I have to do
or some sample where I can study?
TIA
Adrian
====================================================================
| some image not needed |
====================================================================
Some text not needed
====================================================================
|Text needed for all records in this table (2nd table |
====================================================================
|Text |Text |Text |Text |Text |Text |Text |Text |
====================================================================
|15/7 |23-28/8| |Txt |Txt |250 |Txt |Txt |
| | | |Txt |Txt |300 |Txt |Txt |
====================================================================
This is the html. The second row in the second table not needed. The
third row of the second table having the dates will be required for all
records.
========================== HTML =====================================
<TABLE WIDTH=753 BORDER=0 CELLPADDING=1 CELLSPACING=0>
<COL WIDTH=574>
<COL WIDTH=175>
<TR VALIGN=TOP>
<TD WIDTH=574 HEIGHT=4 BGCOLOR="#ffffff">
<P><IMG
SRC="sv6326328.gif" NAME="Graphic1" ALIGN=BOTTOM WIDTH=378 HEIGHT=68
BORDER=0></P>
</TD>
<TD WIDTH=175 BGCOLOR="#000000">
<P ALIGN=CENTER
STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT
SIZE=6
STYLE="font-size: 28pt">Urgent</FONT></FONT></P>
<P ALIGN=CENTER><FONT FACE="Arial,
sans-serif"><FONT SIZE=4><B>Fax
- Message</B></FONT></FONT></P>
</TD>
</TR>
</TABLE>
<P STYLE="margin-bottom: 0in"><BR>
</P>
<P ALIGN=CENTER STYLE="margin-bottom: 0in; border: 1.10pt double
#000000; padding: 0.01in">
<FONT COLOR="#000000"><FONT FACE="Arial,
sans-serif"><FONT
SIZE=5><B>OFFRES
SPECIALES - 27.06.2001 - OFFRES SPECIALES
</B></FONT></FONT></FONT>
</P>
<P ALIGN=CENTER STYLE="margin-bottom: 0in; border: 1.10pt double
#000000; padding: 0.01in">
<B><FONT SIZE=3><FONT
FACE="Wingdings">¶¶¶</FONT><FONT FACE="Arial,
sans-serif">
Départs de Genève </FONT><FONT
FACE="Wingdings">¶¶¶</FONT></FONT></B></P>
<P STYLE="margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-bottom: 0in; line-height: 0.17in"><B><FONT
SIZE=3><FONT FACE="Arial, sans-serif"> SOUS
RÉSERVE DE MODIFICATION DE PRIX ! Page <SDFIELD
TYPE=PAGE
SUBTYPE=RANDOM FORMAT=PAGE>2</SDFIELD>/6
</FONT></FONT></B>
</P>
</DIV>
<P STYLE="margin-right: 0.1in; margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-right: 0.1in; margin-bottom: 0in"><BR>
</P>
<TABLE WIDTH=748 BORDER=1 BORDERCOLOR="#000000" CELLPADDING=1
CELLSPACING=0 RULES=GROUPS>
<COL WIDTH=86>
<COL WIDTH=97>
<COL WIDTH=96>
<COL WIDTH=244>
<COL WIDTH=67>
<COL WIDTH=67>
<COL WIDTH=76>
<TBODY>
<TR>
<TD COLSPAN=7 WIDTH=744 HEIGHT=25 VALIGN=TOP>
<P><FONT SIZE=4><SUB><B><I>Grand
Canarie
(LPA)
</I></B>samedi de
Genève avec LX</SUB></FONT></P>
</TD>
</TR>
</TBODY>
<TBODY>
<TR VALIGN=TOP>
<TD WIDTH=86 HEIGHT=18>
<P STYLE="margin-top: 0.04in"><FONT
FACE="Arial, sans-serif"><I><B>Départs
juin</B></I></FONT></P>
</TD>
<TD WIDTH=97>
<P STYLE="margin-top: 0.04in"><FONT
FACE="Arial, sans-serif"><I><B>Départs
juillet</B></I></FONT></P>
</TD>
<TD WIDTH=96>
<P STYLE="margin-top: 0.04in"><FONT
FACE="Arial, sans-serif"><I><B>Départs
août</B></I></FONT></P>
</TD>
<TD WIDTH=244>
<P STYLE="margin-top: 0.04in"><FONT
FACE="Arial,
sans-serif"><I><B>Cat./Logement</B></I></FONT></P>
</TD>
<TD WIDTH=67>
<P STYLE="margin-top: 0.04in"><FONT
FACE="Arial, sans-serif"><I><B>Code
htl.</B></I></FONT></P>
</TD>
<TD WIDTH=67>
<P STYLE="margin-top: 0.04in"><FONT
FACE="Arial, sans-serif"><I><B>1
sem.</B></I></FONT></P>
</TD>
<TD WIDTH=76>
<P STYLE="margin-top: 0.04in"><FONT
FACE="Arial, sans-serif"><I><B>sem.
suppl.</B></I></FONT></P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=86>
<P><BR>
</P>
</TD>
<TD WIDTH=97>
<P><FONT FACE="Arial,
sans-serif">Sa: 21/28</FONT></P>
</TD>
<TD WIDTH=96>
<P><BR>
</P>
</TD>
<TD WIDTH=244>
<P STYLE="margin-bottom: 0in"><FONT
FACE="Arial, sans-serif">LS Apt.
Tagoror </FONT><FONT
FACE="Wingdings">ww</FONT><FONT FACE="Arial, sans-serif">
</FONT><FONT SIZE=2
STYLE="font-size: 9pt"><FONT FACE="Monotype
Sorts">J</FONT></FONT></P>
<P><FONT FACE="Arial, sans-serif">LS
Apt. Solymar </FONT><FONT FACE="Wingdings">www</FONT><FONT
FACE="Arial,
sans-serif">
</FONT><FONT SIZE=2
STYLE="font-size: 9pt"><FONT FACE="Monotype
Sorts">J</FONT></FONT></P>
</TD>
<TD WIDTH=67>
<P STYLE="margin-bottom: 0in"><FONT
FACE="Arial, sans-serif">9tagor</FONT></P>
<P><FONT FACE="Arial,
sans-serif">9solym</FONT></P>
</TD>
<TD WIDTH=67>
<P STYLE="margin-bottom: 0in"><FONT
FACE="Arial, sans-serif">Fr.
749.-</FONT></P>
<P><FONT FACE="Arial,
sans-serif">Fr. 890.-</FONT></P>
</TD>
<TD WIDTH=76>
<P STYLE="margin-bottom: 0in"><FONT
FACE="Arial, sans-serif">Fr.
301.-</FONT></P>
<P><FONT FACE="Arial,
sans-serif">Fr. 329.-</FONT></P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=86>
<P><BR>
</P>
</TD>
<TD WIDTH=97>
<P><BR>
</P>
</TD>
<TD WIDTH=96>
<P><FONT FACE="Arial,
sans-serif">Sa: 11</FONT></P>
</TD>
<TD WIDTH=244>
<P STYLE="margin-bottom: 0in"><FONT
FACE="Arial, sans-serif">LS Bung.
Colorado Golf </FONT><FONT
FACE="Wingdings">ww<SUP>w</SUP></FONT><FONT SIZE=2
STYLE="font-size: 9pt"><FONT FACE="Monotype
Sorts">J</FONT></FONT></P>
<P><FONT FACE="Arial, sans-serif">DP
Apt.-Htl. Principado </FONT><FONT FACE="Wingdings">www</FONT><FONT
SIZE=2
STYLE="font-size: 9pt"><FONT FACE="Monotype
Sorts">J</FONT></FONT></P>
</TD>
<TD WIDTH=67>
<P STYLE="margin-bottom: 0in"><FONT
FACE="Arial, sans-serif">9colgo</FONT></P>
<P><FONT FACE="Arial,
sans-serif">9Princi</FONT></P>
</TD>
<TD WIDTH=67>
<P STYLE="margin-bottom: 0in"><FONT
FACE="Arial, sans-serif">Fr.
750.-</FONT></P>
<P><FONT FACE="Arial,
sans-serif">Fr. 890.-</FONT></P>
</TD>
<TD WIDTH=76>
<P STYLE="margin-bottom: 0in"><FONT
FACE="Arial, sans-serif">Fr.
301.-</FONT></P>
<P><FONT FACE="Arial,
sans-serif">Fr. 350.-</FONT></P>
</TD>
</TR>
<TR>
<TD COLSPAN=7 WIDTH=744 VALIGN=TOP>
<P><SPAN STYLE="font-weight: medium"><FONT
FACE="Arial, sans-serif">Supplément
dernières places offres speciales
Fr. 100.- taxes
d'aéroport
Fr. 31.-</FONT></SPAN></P>
</TD>
</TR>
</TBODY>
</TABLE>
=============================== END HTML ============================
This is the php that I am trying but not getting any where.
=============================== PHP FILE ===========================
<?
$filename = "sample.html";
$fp = fopen($filename, "r");
$html = fread($fp, filesize($filename));
fclose($fp);
preg_match_all("|<TABLE.*>(.*)</table>|Uims", $html, $tables);
$tables = $tables[0];
for($i = 1, $count = sizeof($tables); $i < $count; ++$i)
{
preg_match_all("|<TR.*>(.*)</tr>|Uims", $tables[$i], $rows); // Get a
list ofrows in this table
$rows = $rows[1];
//echo "rows $rows[0]";
for($j = 0, $rowcount = sizeof($rows); $j < $rowcount; ++$j)
{
preg_match_all("|<TD.*>(.*)</td>|Uims", $rows[$j], $cells); // Get
a list of cells in this row
$cells = $cells[1];
//echo "cells $cells[0]"; $rows
for($k = 0, $cellcount = sizeof($cells); $k < $cellcount; ++$k)
{
$elements[$i][$j][$k] = $cells[$k];
if(stristr($elements[$i][$j][$k], "</P>"))
{ $fields = explode("</P>", $elements[$i][$j][$k]);
//print_r($fields);
$num=sizeof($fields);
//print("$num");
for($m = 0; $m < ($num-1); $m++)
{
//$fields[$m]=strip_tags($fields[$m],"</P>");
if($fields[$m] != "")
{
if(strstr($fields[$m], '<B>')==0)
{
//strip_tags($fields[$m]);
print("<br>Feild.$m = $fields[$m]");
//print("<br>");
} }
}
//print ("One : $fields[0] and Two $fields[1]");
//print_r($fields);
}
// $elements[$i][$j][$k]=strip_tags($elements[$i][$j][$k] =
$cells[$k]); //$xcells[]=strip_tags($cells[$k]);
} //$xcells[]=strip_tags($fields[$k]);
}
}
============================= END PHP FILE ======================