I'm using Simple HTML DOM to get elements from a website, but when class attribute has spaces, I don't get anything.
Source HTML from betaexplorer.com
<table id="table-type-2" class="stats-table stats-main table-2">
<tbody>
<tr class="odd glib-participant-ppjDR086" data-def-order="0">
<td class="rank col_rank no" title="">1.</td>
<td class="participant_name col_participant_name col_name"><span class="team_name_span"><a onclick="javascript:getUrlByWinType('/soccer/england/premier-league/teaminfo.php?team_id=ppjDR086');">Manchester United</a></span></td>
<td class="matches_played col_matches_played">4</td>
<td class="wins col_wins">4</td>
<td class="draws col_draws">0</td>
<td class="losses col_losses">0</td>
<td class="goals col_goals">14:0</td>
<td class="goals col_goals">12</td>
</tr>
<tr class="even glib-participant-hA1Zm19f" data-def-order="1">
<td class="rank col_rank no" title="">2.</td>
<td class="participant_name col_participant_name col_name"><span class="team_name_span"><a onclick="javascript:getUrlByWinType('/soccer/england/premier-league/teaminfo.php?team_id=hA1Zm19f');">Arsenal</a></span></td>
<td class="matches_played col_matches_played">4</td>
<td class="wins col_wins">4</td>
<td class="draws col_draws">0</td>
<td class="losses col_losses">0</td>
<td class="goals col_goals">11:3</td>
<td class="goals col_goals">12</td>
</tr>
<tr class="odd glib-participant-Wtn9Stg0" data-def-order="2">
<td class="rank col_rank no" title="">3.</td>
<td class="participant_name col_participant_name col_name"><span class="team_name_span"><a onclick="javascript:getUrlByWinType('/soccer/england/premier-league/teaminfo.php?team_id=Wtn9Stg0');">Manchester City</a></span></td>
<td class="matches_played col_matches_played">4</td>
<td class="wins col_wins">3</td>
<td class="draws col_draws">1</td>
<td class="losses col_losses">0</td>
<td class="goals col_goals">18:3</td>
<td class="goals col_goals">10</td>
</tr>
</tbody>
</table>
My PHP code using SimpleHtmlDom
<?php
include('../simple_html_dom.php');
function getHTML($url,$timeout)
{
$ch = curl_init($url); // initialize curl with given url
curl_setopt($ch, CURLOPT_USERAGENT, $_SERVER["HTTP_USER_AGENT"]); // set useragent
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // write the response to a variable
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); // follow redirects if any
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout); // max. seconds to execute
curl_setopt($ch, CURLOPT_FAILONERROR, 1); // stop when it encounters an error
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
return @curl_exec($ch);
}
$response=getHTML("http://www.betexplorer.com/soccer/england/premier-league/standings/?table=table&table_sub=home&ts=WOO1nDO2&dcheck=0",10);
$html = str_get_html($response);
$team = $html->find("span[class=team_name_span]/a");
$numbermatch = $html->find("td.matches_played.col_matches_played");
$wins = $html->find("td.wins.col_wins");
$draws = $html->find("td.draws.col_draws");
$losses = $html->find("td.losses.col_losses");
$goals = $html->find("td.goals.col_goals");
?>
<table border="1" width="100%">
<thead>
<tr>
<th>Team</th>
<th>MP</th>
<th>W</th>
<th>D</th>
<th>L</th>
<th>G</th>
</tr>
</thead>
<?php
foreach ($team as $match) {
echo "<tr>".
"<td class='first-cell'>".$match->innertext."</td> " .
"<td class='first-cell'>".$numbermatch->innertext."</td> " .
"<td class='first-cell'>".$wins->innertext."</td> " .
"<td class='first-cell'>".$draws->innertext."</td> " .
"<td class='first-cell'>".$losses->innertext."</td> " .
"<td class='first-cell'>".$goals->innertext."</td> " .
"</tr><br/>";
}
?>
</table>
So, I only get first value (because class name is without spaces), but I can't get the rest of values
EDIT: I fixed a mistake into PHP code. See again
EDIT2: It's not a duplicate, I tried that solution but It doesn't work
EDIT3: I tried to use advanced_html_dom (it should fix spaces problem), but I don't get anything (also just the only one I was getting)
EDIT4: In the screens below you can see what I'd like to get and what I get right now:
EDIT5
team.php
<?php
// START team.php
class Team
{
public $name, $matches, $wins, $draws, $losses, $goals;
public static function parseRow($row): ?self
{
$result = new self();
$result->name = $result->parseMatch($row, 'span.team_name_span a');
if (null === $result->name) {
return null; // couldn't even match the name, probably not a team row, skip it
}
$result->matches = $result->parseMatch($row, 'td.col_matches_played');
$result->wins = $result->parseMatch($row, 'td.col_wins');
$result->draws = $result->parseMatch($row, 'td.col_draws');
$result->losses = $result->parseMatch($row, 'td.col_losses');
$result->goals = $result->parseMatch($row, 'td.col_goals');
return $result;
}
private function parseMatch($row, $selector)
{
if (!empty($match = $row->find($selector, 0))) {
return $match->innertext;
}
return null;
}
}
// END team.php
?>
clas.php
<?php
include('../simple_html_dom.php');
include('../team.php');
function getHTML($url,$timeout)
{
$ch = curl_init($url); // initialize curl with given url
curl_setopt($ch, CURLOPT_USERAGENT, $_SERVER["HTTP_USER_AGENT"]); // set useragent
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // write the response to a variable
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); // follow redirects if any
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout); // max. seconds to execute
curl_setopt($ch, CURLOPT_FAILONERROR, 1); // stop when it encounters an error
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
return @curl_exec($ch);
}
$response=getHTML("http://www.betexplorer.com/soccer/england/premier-league/standings/?table=table&table_sub=home&ts=WOO1nDO2&dcheck=0",10);
$html = str_get_html($response);
// START DOM parsing block
$teams = [];
foreach($html->find('table.stats-table tr') as $row) {
$team = Team::parseRow($row); // load the row into a Team object if possible
// skipp this entry if it couldn't match the row
if (null !== $team) {
// what were actually doing here is just the OOP equivalent of:
// $teams[] = ['name' => $row->find('span.team_name_span a',0)->innertext, ...];
$teams[] = $team;
}
}
foreach($teams as $team) {
echo $team->name;
echo $team->matches;
}
// END DOM Parsing Block
?>
Solution: http://phpfiddle.org/main/code/cq54-hta2
Class-names don't have spaces, don't try to match them
SimpleHtmlDom doesn't support attribute selectors like this. Plus you're tyring to match a class as though it has spaces in the class name. So, instead of this:
Do the following to match td elements which match BOTH of two class-names:
Additionally, that HTML markup doesn't require you to match both classes to get the data, should you could simply do:
Getting repeated selectors (looping through rows).
What you are trying to extract is the an array of data from the rows of a table. More specifically, something that looks like this:
This means you'll need to run the same data-extraction against each row of the table. SimpleHtmlDom makes this easy through jQuery-like
find
methods, which can be called from any matched element.Complete Solution
This solution actually defines a
Team
object to load each row's data into. Should make future adjustments much simpler.The important piece to note here, is that first we loop through every table-row as
$row
, and collect the team and numbers from$row->find([selector])
.