Parsing HTML

legal-medium

I have a large file that I would like to parse and insert into a database

///////////////////////////<HTML> file example///////////////////////////

Christina W. (Chi) Chua * 
Ellman, Burke et al 
One Ecker Building 
Suite 200 
San Francisco, CA 94105 
tel: (415) 777-2727 
fax: (415) 495-7587 
email: <a href="mailto:cchua@ellman-burke.com">cchua@ellman-burke.com</a> 
url: <a href="http://www.ellman-burke.com">www.ellman-burke.com</a>

Erin Boo Tool 
Attorney at Law 
2445 Petaluma Boulevard North 
Petaluma, CA 94952-1979

Adel Aali 
Fish & Neave 
525 University Avenue 
Palo Alto, CA 94301 
tel: (650) 617-4006 
fax: (650) 617-4090 
email: <a href="mailto:aaali@fishneave.com">aaali@fishneave.com</a>

I want to extract the below captioned fileds and insert into an array that I can use for a sql insert loop

///////////////Fileds////////////////////////////////
the name
the e-mail address

////////////////Example Results/////////////////////////

Christina W. (Chi) Chua - cchua@ellman-burke.com
Erin Boo Tool - null
Adel Aali - aaali@fishneave.com

Thanks

swon

Well, not so easy but I guess that works for you:

<?
$file ="file3.html"; // your file;
$array = file($file);
$harry = array();
$i=0;

for($x=0;$x<count($array);$x++)
{
$check = substr_count($array[$x], "");
if($check >0){
$i++;
}
else{
$harry[$i] .= $array[$x];
}

}
$a=0;
foreach($harry as $value){

     $ex    = explode("</b>",$value);
     $ex2  = explode("email:",$value);
     $new = explode("<br>",$ex2[1]);
     $name = strip_tags($ex[0]);
     $email = strip_tags($new[0]);

     echo "Name:$name<br>email:$email<br><br>"; // here you can loop the inserts into the db;

}
?>