Get Certain portion of an other site

duny

I use to know how to do this, but i have been away from PHP for awhile.

The data i am trying to get is this portion of a website:

<center><table border=0 cellspacing=4 cellpadding=1>
<tr><th>Mailing<BR>Name</th><th>State<BR>Code</th><th>ZIP<BR>Code</th><th>Latitude<BR>(North)</th><th>Longitude<BR>(West)</th></tr><tr><td align=center>Newburgh</font></td><td align=center>NY</font></td><td align=center>12550</font></td><td align=center>41.5391</font></td><td align=center>74.0491</font></td></tr></table>
</center><P><br><center>Are you looking for the ZIP code for a particular street address? If so, <A href=http://www.usps.com/zip4/>click here</A>.</center><br><br><FORM  ACTION="http://www.zipinfo.com/cgi-local/zipsrch.exe" METHOD="GET"><CENTER><TABLE BORDER="1" CELLSPACING="2" CELLPADDING="10" BGCOLOR="#FFFF80"><TR><Th ALIGN="center"><FONT SIZE=+2 color="#FF0000"><CENTER><STRONG>Search Again...</STRONG></CENTER></FONT><BR>For any valid ZIP code, find the city and state, plus:<br><Table><tr><td VALIGN="top" align="left"><INPUT NAME="cnty" VALUE="cnty" TYPE="CHECKBOX" ALIGN=left></td><td VALIGN="top" align="left">county name and FIPS code</td><td VALIGN="top" align="left"><INPUT NAME="ac" VALUE="ac" TYPE="CHECKBOX" ALIGN=left></td><td VALIGN="top" align="left">area code</td></tr><tr><td VALIGN="top" align="left"><INPUT NAME="tz" VALUE="tz" TYPE="CHECKBOX" ALIGN=left></td><td VALIGN="top" align="left">time zone</td><td VALIGN="top" align="left"><INPUT NAME="ll" VALUE="ll" TYPE="CHECKBOX" ALIGN=left CHECKED></td><td VALIGN="top" align="left">latitude and longitude</td></tr><tr><td VALIGN="top" align="left"><INPUT NAME="msa" VALUE="msa" TYPE="CHECKBOX" ALIGN=left></td><td VALIGN="top" align="left">MSA/PMSA</td></tr></table><BR>Enter a ZIP code or a city and state<BR><INPUT TYPE="text" NAME="zip" SIZE="30" MAXLENGTH="100"  VALUE = "12550"> <INPUT TYPE="submit" NAME="Go" VALUE="Go" ><BR><BR>Data Source: <A HREF="../products/products.htm">ZIPList5 Product Line</A> September 2006</TD></TR></TABLE><BR></CENTER><center><img src="../images/divider.gif"></center><BR>

The html is the middle part of the page that I would like to get and post to my website.

I know I should be using file_get_contents() but i can't remember. The website is
http://zipinfo.com/cgi-local/zipsrch.exe?ll=ll&zip=12550
If someone will post an example it would be great.

sneakyimp

http://php.net/file_get_contents

you might also look at

http://php.net/preg_match

duny

This is the code i have

	$fd = fread(fopen("http://zipinfo.com/cgi-local/zipsrch.exe?ll=ll&zip=$_GET[zip]", "rb"), 100000);
	$StartDilimiter = "<center><table border=0 cellspacing=4 cellpadding=1>";
	$EndDilimiter = "</center><BR>";

if ($fd) {
	$start = strpos($fd, $StartDilimiter) + strlen($StartDilimiter);
	$finish = strpos($fd, $EndDilimiter) - strlen($EndDilimiter);
	$length = $finish - $start;
	$code = Substr($fd, $start, $length);
}		
echo $code;

and the error I get is

Warning: fopen(http://zipinfo.com/cgi-local/zipsrch.exe?ll=ll&zip=12550) [function.fopen]: failed to open stream: Permission denied in /home/u5/countryclubrv/html/get.php on line 3

Warning: fread(): supplied argument is not a valid stream resource in /home/u5/countryclubrv/html/get.php on line 3

The site that I am trying to pull data from is not mine and I have tried everything to extract the data from this site.

Config.
PHP 4
safe_mode on
FILE CHMOD 0777
Folder CHMOD 0777

Piranha

Edit: Try with file_get_contents instead and see if that works.

duny

now i get this Warning: file_get_contents(http://zipinfo.com/cgi-local/zipsrch.exe?ll=ll&zip=12550) [function.file-get-contents]: failed to open stream: Permission denied in /home/u5/countryclubrv/html/get.php on line 2

Piranha

It seem like they don't want people to access their site this way. I would forget including this site.

Sorry that the answer is not helpful, but unfortunatley you can't always get what you want.

sneakyimp

you might want to check your php ini confi with this statement:

if (ini_get['allow_url_fopen']) {
  echo 'you are permitted to open urls with fopen';
} else {
  echo 'sorry, no urls permitted with fopen';
}

i'm not certain, but i think that ini directive might prevent you from using any of those file commands to open a remote url.

you could also try using cURL or fsockopen.