Imploding a website of stats

[solidariti]

I'm trying to import a league table then strip out the useless stuff that I dont ie. page tags, and title tags etc. Then display it in a neat table, on my page.

I'm using:

<?php
    $test  = implode ('',file("http://www.busa.org.uk/page.asp?section=0001000200010003"));
    
    print $test;

Which imports the page nicely, however I'm not sure how to get rid of the stuff that I dont need. Could I save it to a file, and then use regular expressions to search through and cut out the tags and info that I dont want. Is this possible, and if so is there a better way of doing this?

Thanks and merry christmas

[chazzy]

well before you do that, have you attempted to contact BUSA to see if they can provide you an XML export of their data?

[solidariti]

Thats a good idea, I will, how would I do it this way though using the implode in php. Just to satisfy my curiusity.

[SpectreReturns]

I would attempt to use strip_tags to see if that removes most of the useless stuff (might cut text too :/). If not, you would need to determine where the data is located, and probably use an SGML parser to figure out what you want.

[Huevoos]

well if you just want to output de data here is a very simple script that allows you to do so.

<?php
         $url = "http://www.busa.org.uk/page.asp?section=0001000200010003";
             $ch = curl_init("$url");
             $fp = fopen("escroto.txt", "w");
             curl_setopt($ch, CURLOPT_FILE, $fp);
             curl_setopt($ch, CURLOPT_HEADER, 0);
             curl_exec($ch);
             curl_close($ch);
             fclose($fp);
             $content = file_get_contents("escroto.txt");
        $array1 = array();
        $array2 = array();

                $array1 = explode("<p></p>", $content);
                $array2 = explode("</tbody></table></p>", $array1[1]);

        echo $array2[0] . "</tbody></table></p>";

?>

[solidariti]

thank you, but if I wanted to search through the arrays and to cut out the text like links, that i didnt want, could I use preg_matches to match the links and then delete them. Or is there a #nother way, as this might interfer with the data that im trying to import.

[Huevoos]

Sorry, I don't understand, which links???
could you explain yourself a little more???

[solidariti]

Sorry about that, all I want to display, is whats in the tables, ie. the league tables not the actual whole page which include the lnks etc.

[solidariti]

When I run the below code I seem to get this error: Fatal error: Call to undefined function: curl_init() in H:\xampp\htdocs\www\1uwafc\busa\index.php on line 26.

What does this mean?

well if you just want to output de data here is a very simple script that allows you to do so.

<?php
         $url = "http://www.busa.org.uk/page.asp?section=0001000200010003";
             $ch = curl_init("$url");
             $fp = fopen("escroto.txt", "w");
             curl_setopt($ch, CURLOPT_FILE, $fp);
             curl_setopt($ch, CURLOPT_HEADER, 0);
             curl_exec($ch);
             curl_close($ch);
             fclose($fp);
             $content = file_get_contents("escroto.txt");
        $array1 = array();
        $array2 = array();

                $array1 = explode("<p></p>", $content);
                $array2 = explode("</tbody></table></p>", $array1[1]);

        echo $array2[0] . "</tbody></table></p>";

?>

[Huevoos]

Oh it means that you do not have the curl library, I believe it should work with the following changes

<?php
         $url = "http://www.busa.org.uk/page.asp?section=0001000200010003";
/*
             $ch = curl_init("$url");
             $fp = fopen("escroto.txt", "w");
             curl_setopt($ch, CURLOPT_FILE, $fp);
             curl_setopt($ch, CURLOPT_HEADER, 0);
             curl_exec($ch);
             curl_close($ch);
             fclose($fp);
             $content = file_get_contents("escroto.txt");
*/
                $content = implode('',file("http://www.busa.org.uk/page.asp?section=0001000200010003")); 
        $array1 = array();
        $array2 = array();

                $array1 = explode("<p></p>", $content);
                $array2 = explode("</tbody></table></p>", $array1[1]);

        echo $array2[0] . "</tbody></table></p>";

?>

It is suposed to print in your page only the table with the results