how to get list of arrays using DOMDocument?

[mark103]

I have the list of tags in php and I want to get the contents.

for example:

    <li class="zc-ssl-pg" id="row0-1" style="">
    <span id="row1Time" class="zc-ssl-pg-time">6:00 PM</span>
    <a id="rowTitle1" class="zc-ssl-pg-title" href='http://www.mysite.com'>Melissa & Joey</a>
    <a class="zc-ssl-pg-ep" href='http://www.mysite.com'>"House Broken"</a>

<li class="zc-ssl-pg" id="row1-1" style="">
<span id="row1Time" class="zc-ssl-pg-time">6:00 PM</span>
<a id="rowTitle1" class="zc-ssl-pg-title" href='http://www.mysite.com'>The Middle</a>
<a class="zc-ssl-pg-ep" href='http://www.mysite.com'>"Thanksgiving IV"</a>

Here's the PHP:

    <?php
    $errmsg_arr = array();
    $errflag = false;
    $link;

function db_connect()
{
  define('DB_HOST', 'localhost');
  define('DB_USER', 'myusername');
  define('DB_PASSWORD', 'mypassword');
  define('DB_DATABASE', 'mydbname');

  $errmsg_arr = array();
  $errflag = false;
  $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

  if(!$link) 
  {
    die('Failed to connect to server: ' . mysql_error());
  }

  $db = mysql_select_db(DB_DATABASE);
  if(!$db) 
  {
    die("Unable to select database");
  }
}
db_connect();

$qrytable1="SELECT id, channels, links, streams FROM tvguide";
$result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());


  $links = "WEBSITE URL";
  $result = file_get_contents($links);
  $dom = new DOMDocument();
  $dom->loadHTML($result);
  echo $dom->getElementById('row1Time')->nodeValue . "<br>";
?>

When I use the code as above, it will only get the contents from the tags with array value 0.

I want to get the tags `row1Time, rowTitle1 and zc-ssl-pg-ep with the array 1 value.

Can you please tell me how I can get the contents from the class tags with the array value 1 using with DOMDocument?

[Weedpacket]

That would be ... difficult. The original HTML is broken; the same ID is being used for more than one element in the document - in violation of the DOM specification. [font=monospace]getElementById[/font] is only meant to find and return one element, not more than one. That's why it's not called [font=monospace]getElementsById[/font].

You might try searching for elements with a particular class, or use a storage format designed for machine use instead.

[mark103]

Weedpacket;11039783 wrote:

That would be ... difficult. The original HTML is broken; the same ID is being used for more than one element in the document - in violation of the DOM specification. [font=monospace]getElementById[/font] is only meant to find and return one element, not more than one. That's why it's not called [font=monospace]getElementsById[/font].

You might try searching for elements with a particular class, or use a storage format designed for machine use instead.

can you please post the code that i should use?

[dalecosp]

No, because how would he know that based on what's been given thus far?

As he indicates, the HTML you're trying to read is broken. If you are responsible for that HTML, trying incrementing the numbers in the element ID's thusly:

<span id="row1Time" class="zc-ssl-pg-time">6:00 PM</span>
    <a id="rowTitle1" class="zc-ssl-pg-title" href='http://www.mysite.com'>Melissa & Joey</a>

<span id="row2Time" class="zc-ssl-pg-time">7:00 PM</span>
    <a id="rowTitle2" class="zc-ssl-pg-title" href='http://www.mysite.com'>Madge & Henry</a>

<span id="row3Time" class="zc-ssl-pg-time">7:58:42 PM</span>
    <a id="rowTitle3" class="zc-ssl-pg-title" href='http://www.mysite.com'>Tom & Jerry</a>

If you don't have control of the HTML, you're going to have to find another way to skin this cat; and it's not an easy one. You'll probably have to grab TagNames and loop through them and hope to Jesus that you can keep all the relevant data together if they, for example, have skipped a field someplace or any other anomaly exists (which seems likely given the care they seem to have used with their element ID numbers) 😉 😉 ...