从 NHL.com 抓取数据

发布于 2024-12-16 00:52:39 字数 1004 浏览 1 评论 0原文

我正在尝试从 http://www.nhl.com/ice/stands.htm?season=20112012&type=LEA" rel="nofollow">http://www. nhl.com/ice/stands.htm?season=20112012&type=LEA，并将其存储到我服务器上的 MySQL 数据库中。使用下面的内容，我可以准确复制该网站，但我不确定如何提取该表。代码如下：

有什么想法吗？

function get_data($url)
{
  $ch = curl_init();
  $timeout = 5;
  curl_setopt($ch,CURLOPT_URL,$url);
  curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
  curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,$timeout);
  $data = curl_exec($ch);
  curl_close($ch);
  return $data;
}

$returned_content = get_data('http://www.nhl.com/ice/standings.htm?season=20112012&type=LEA');

echo $returned_content;

更新：

$html = file_get_html('http://www.nhl.com/ice/standings.htm?season=20112012&type=LEA');
    $e = $html->find("table", 2);

    echo($e);

这段代码有效，发布了一张像我需要的那样的表格。但现在我很好奇如何删除所有不必要的链接/格式并将其保存到数据库中？

原文

I'm trying to grab the table from http://www.nhl.com/ice/standings.htm?season=20112012&type=LEA, and store it into a MySQL database on my server. Using the below, I'm able to copy the website exactly, but I'm not sure how to just extract that table. Code below:

Any ideas?

function get_data($url)
{
  $ch = curl_init();
  $timeout = 5;
  curl_setopt($ch,CURLOPT_URL,$url);
  curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
  curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,$timeout);
  $data = curl_exec($ch);
  curl_close($ch);
  return $data;
}

$returned_content = get_data('http://www.nhl.com/ice/standings.htm?season=20112012&type=LEA');

echo $returned_content;

UPDATE:

$html = file_get_html('http://www.nhl.com/ice/standings.htm?season=20112012&type=LEA');
    $e = $html->find("table", 2);

    echo($e);

This code works, posts a table like the one I need. But Now I'm curious as to how I would go about stripping all unnecessary links/formatting and saving it to the database?

分享到QQ

分享到微博