[Resolved] Accessing other sites

[DeadFly]

Is it possible to make a PHP script which would browse another sites, and either grab data from an output page, or directly from an unknown database with unknown fields ?

What I'm looking to do is have a script which will automatically visit this page and will access the fields (W-L-T-OTL) and enter them into my mySQL database to be displayed on my site. Basically it would save me the time of making a team editing portion of my site.

Here would be the pseudo code:

///// Open site
open_page("http://www.somesite.com/index.php");

///// Grab specific data
$variable=read_variable("some_var_name");

///// Enter into my database
enter_into_db($variable);

I can do the entering the variable into my database easy, but can the other 2 parts be done successfully ?

I was looking at using iOpus Internet Macros, but it runs for VBScript, and I want to do this in PHP.

Thanks in advance for any help.

[webdes03]

<?php
  $my_var = file_get_contents('http://nhl.com/onthefly/standings/div_stand.html');
?>

That will set $my_var to be the source of the page, as if you were clicking "view source" in IE... you're then going to have to tell it to select only the scores part, so you'll need a couple points in the code, around the scores that will hopefully never change... it is possible, just play with it a bit.

You might be able to use stripos() to search for a team name, and get that row of the table from the page.

I'm not entirely positive how to select that data, but I know the code above will work to get the contents of the file into a variable that you can work with.

[DeadFly]

Thanks for a point in the right direction !