Conflict between Simple_html_dom and Nonobject-Oriented functions

Question

I’m developing an app that has to access a list of websites stored in a database, upload all their links. It’s a test application but I’ve found a difficulty. The routine is this one:

  function crawler() {
      include_once './simple_html_dom.php';

      //Coloquei este registro em um vetor para dar um exemplo
      $sites = array("http://www.folhavitoria.com.br/");

      //se eu descomentar a linha abaixo o erro acontece:
      // $conecta = mysql_connect("localhost", "root", "");

      foreach ($sites as $url){
        $html = new simple_html_dom($url);
        echo "<br>".$url."</br>";

        foreach($html->find("a") as $link){
            echo $link->href."<br/>";
        }
        unset($html);
      }
  }

Basically what this routine returns me is a series of links from within the main page of this site.

It turns out that when I put the function mysql_connect, to be able to collect information from the bank at the time of running the following error message:

Fatal error: Call to a Member Function find() on a non-object in /var/www/html/Crawler/simple_html_dom.php on line 1113

updating responding to requests the function that is (next actually) of the 1113 line in simple_html_dom.php is as follows:

function find($selector, $idx=null, $lowercase=false)
{
    return $this->root->find($selector, $idx, $lowercase);
}

I’ve tried several alternatives and I don’t know what else to do.

If you want to download Simple_html_dom for testing follow the link.: http://sourceforge.net/projects/simplehtmldom/files/

Answer 1

Move the connection up the include_once() not to disrespect the file code - this is probably affecting the workflow class simple_html_dom. Upshot:

function crawler() {
  $conecta = mysql_connect("localhost", "root", "");

  include_once './simple_html_dom.php';

  // [...]
}

---

Remarks

First, the function mysql_connect() is deprecated. This means that it is no longer updated, will be removed soon and you should avoid using it.

According to, value by nomenclature. Variables tend to be nouns, and $conecta is a Verb conjugate in personal third of singular. Suggestion: $conecta → $conexao.

Answer 2

Resolution

I basically took the advice of @Guilhermeoderdenge and researched alternatives to the deceased mysql_connect() and used the PDO, and what was not my surprise to work only with objects the system worked perfect harmony and no bugs.

Then replace the command:

$conecta = mysql_connect("localhost", "root", "");

For the connection with the PDO:

$pdo = new PDO('mysql:host=localhost;dbname=meuBancoDeDados', "root", ""); 
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

And it all worked out right. Detail that whenever I try to put a function outside of an object to work directly with the simple_html_dom I’ll take the risk of having that problem.

So from now on 100% PDO And 100% Object Orientation D:

Thank you to everyone who helped.