0

I have a script that parses certain elements from a webpage and stores them in a mysql db. Everything works fine until I try to split an element and store the resulting data into the db. Any ideas what might be wrong? Here's the page I'm parsing: http://www.ratemyprofessors.com/SelectTeacher.jsp?sid=953

Here's my code:

<?php
include('simple_html_dom.php'); 

//connect to db (code emitted)

prof_List("http://www.ratemyprofessors.com/SelectTeacher.jsp?sid=953");

function prof_name($url)
{
    // collect data
    echo $url;
    $data = new simple_html_dom();  
    $data->load_file($url);
    $profName = $data->find("//*[@id=profName]", 0);
    $profName = strip_tags($profName);
    echo "Full Name: " . $profName = trim($profName);
    list($first, $last) = explode("&nbsp;", $profName);
    echo "fname: " .  $first;
    echo "lname: " . $last;

    //call mysql function
    insert_row($profName, $first, $last);

}


function insert_row($profName, $first, $last)
{
    $sql1="INSERT INTO PROFESSOR(name, firstname, lastname) VALUES('$profName','$first', '$last')";
    $sql1=strip_tags($sql1);
    echo $sql1;
    mysql_query($sql1) or die(mysql_error());  
    echo "Data Inserted!"; 
}


function prof_List($mainURL)
{

    $list = new simple_html_dom();  
    $list->load_file($mainURL);
    $profLinks = $list->find("//*[@class=profName]/a");
    foreach($profLinks as $profLink)
    {
        $profU=$profLink->href;
        echo $profURL = "http://www.ratemyprofessors.com/" . $profU;
        prof_name($profURL);
    }

}

?>

Here's my output: 

Connected to MySQL
Connected to Databasehttp://www.ratemyprofessors.com/SelectTeacher.jsp?the_dept=All&sid=953&orderby=TLName&toggel=truehttp://www.ratemyprofessors.com/SelectTeacher.jsp?the_dept=All&sid=953&orderby=TLName&toggel=trueFull Name: fname: lname: INSERT INTO PROFESSOR1(name, firstname, lastname) VALUES('','', '')Data Inserted!http://www.ratemyprofessors.com/ShowRatings.jsp?tid=861228http://www.ratemyprofessors.com/ShowRatings.jsp?tid=861228
Fatal error: Call to a member function find() on a non-object in /Users/user1/Sites/simple_html_dom.php on line 879
wandersolo
  • 69
  • 1
  • 3
  • 11
  • 1
    Try this: $data->file_get_html($url); instead of $data->load_file($url); – mkey Sep 08 '12 at 23:52
  • I get a Fatal error: Call to undefined method simple_html_dom::file_get_html() – wandersolo Sep 09 '12 at 00:02
  • I made a mistake. Try this $data = file_get_html($url); You can find out more in documentation: http://simplehtmldom.sourceforge.net/ – mkey Sep 09 '12 at 00:04

1 Answers1

1

I don't think you can use find() on simple_html_dom().

Try this: 

$data = new simple_html_dom();  
$data->file_get_html($url);
$profName = $data->find("//*[@id=profName]", 0);

This link provides a great, basic example.

David
  • 3,831
  • 2
  • 28
  • 38