[rayzer]

Hi,

I am working on a website for a friend. He has asked me to extract table results from a webpage (Breaking Vehicles | Used Car Parts | Leon Recycling Ltd & Car Dismantlers Wicklow) and display on his website.

How do i go about retrieving this information, and placing it on a new php page?

Can do basic! i mean basic websites, so all help would be grateful.

Thanks for your help.
Ray Mantle

[Jcbones]

Something like this:

PHP Code:

<?php 
$str = file_get_contents('http://www.partfinder.ie/leon-recycling/listvehiclesforbreaking.pl');

$pattern = '~<table width="750" height="600" border="0" cellspacing="5" cellpadding="4">(<tr>((<td.*>([A-Za-z0-9])*</td>)+)</tr>)*</table>~i';
preg_match($pattern,$str,$match);
$match = preg_replace('~BGCOLOR=#[a-z0-9]{6}~i','',$match[3]);
echo '<table><tr>' . $match . '</tr></table>';
?>

[mysamsung]

you can do it by using
file_get_contents('http://www.partfinder.ie/leon-recycling/listvehiclesforbreaking.pl');

[job0107]

Lets take Jcbones code a little further and create a table just like the one you see at PartFinder.ie - Car Dismantlers, Car Breakers search for Ireland. website.
The colors maybe slightly different, but you can fix them to what ever colors you prefer.

PHP Code:

<?php
$str = file_get_contents('http://www.partfinder.ie/leon-recycling/listvehiclesforbreaking.pl');
$pattern = '~<table width="750" height="600" border="0" cellspacing="5" cellpadding="4">(<tr>((<td.*>([A-Za-z0-9])*</td>)+)</tr>)*</table>~i';
preg_match($pattern,$str,$match);
$match = preg_replace('~BGCOLOR=#[a-z0-9]{6}~i','',$match[3]);
$rows = explode("</TR><TR>",$match);
$s=0;
$pattern = array("<TD >","</TD>","<TD>","</INPUT>","</TR>","</table>","</div>","</center>");
$replace = array("","|","|","","","","","");
foreach($rows AS $row)
{
 $row = str_replace($pattern,$replace,$row);
 $row = str_replace("||","|",$row);
 if($s==0){$r = substr($row,1,strlen($row)-2);$s=1;}
 else{$r = substr($row,0,strlen($row)-1);}
 $cols[] = explode("|",$r);
 }
$s=0;
echo "<center><div style='padding:5px;background:#77b;width:815px;'><div style='background:#bbf;padding:10px;padding-left:15px;padding-right:15px;'><div style='width:770px;background:#bbf;height:500px;overflow:auto;'><table width='750' height='600' border='0' cellspacing='5' cellpadding='4' style='background:#bbf;'>";
for($row=0;$row<count($cols);$row++)
{
 $c1=($c1=="#ddf")?"#eee":"#ddf";
 if($s==0){$c="";$s=1;}
 else{$c="style='background:".$c1.";'";}
 echo "<tr>";
 for($col=0;$col<count($cols[0]);$col++)
 {
  echo "<td ".$c.">".$cols[$row][$col]."</td>";
  }
 echo "</tr>";
 }
echo "</table></div></div></div></center>";
?>