Databases
StackOverflow2013
Postsdbo
POprint html table using php dom document
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POprint html table using php dom document
    primarykey
    data
    text
    <p>Need help,</p> <p>I would like to print this html code in our web page using php domdocument, but struggling I have also write the code with below. Could you please help me.</p> <pre><code>&lt;table width="610" id="machine" border="0" cellSpacing="10" cellPadding="0"&gt; &lt;TBODY&gt; &lt;TR&gt; &lt;TD colSpan=2 align=left&gt; &lt;DIV id=breadcrumbs&gt;&lt;A href="/new-and-used-machinery.php"&gt;All Machines&lt;/A&gt; &amp;nbsp;&amp;gt;&amp;nbsp; &lt;A href="/listing.php?cat=Air+Compressors"&gt;Air Compressors&lt;/A&gt; &amp;nbsp;&amp;gt;&amp;nbsp;&lt;/DIV&gt; &lt;DIV id=ForSale&gt;FOR SALE:&lt;/DIV&gt; &lt;H1&gt;5 CFM Used Speedaire Air Compressor, Single Phase, 60 Gallon tank, 1.5 H.P. #A1194&lt;/H1&gt; &lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD id=photos vAlign=top width=270 align=middle&gt; &lt;DIV id=ClickPhotos&gt;Click On Photos For Larger Image:&lt;/DIV&gt; &lt;!-- PHOTOS DB div style="margin-bottom:12px"&gt;&lt;img src="thumb.php?id=A1194.jpg&amp;amp;w=250&amp;amp;h=250"&gt;&lt;/div --&gt;&lt;!-- ORIG PHOTOS div style="margin-bottom:12px"&gt;&lt;img src="thumb.php?f=A1194.jpg&amp;amp;w=250&amp;amp;h=250"&gt;&lt;/div --&gt; &lt;DIV style="MARGIN-BOTTOM: 12px"&gt;&lt;A href="/photos.php?id=7135&amp;amp;p=1"&gt;&lt;IMG title="Used Speedaire Air Compressor" alt="Used Speedaire Air Compressor" src="/class/class_Image.php?load=cGhvdG9zL0ExMTk0LmpwZ3wyNTB8MjUwfDF8"&gt;&lt;/A&gt; &lt;/DIV&gt; &lt;!-- PHOTOS DB div style="margin-bottom:12px"&gt;&lt;img src="thumb.php?id=A1194_1.jpg&amp;amp;w=250&amp;amp;h=250"&gt;&lt;/div --&gt;&lt;!-- ORIG PHOTOS div style="margin-bottom:12px"&gt;&lt;img src="thumb.php?f=A1194_1.jpg&amp;amp;w=250&amp;amp;h=250"&gt;&lt;/div --&gt; &lt;DIV style="MARGIN-BOTTOM: 12px"&gt;&lt;A href="/photos.php?id=7135&amp;amp;p=2"&gt;&lt;IMG title="Used Speedaire Air Compressor" alt="Used Speedaire Air Compressor" src="/class/class_Image.php?load=cGhvdG9zL0ExMTk0XzEuanBnfDI1MHwyNTB8MXw="&gt;&lt;/A&gt; &lt;/DIV&gt; &lt;/TD&gt; &lt;TD id=details vAlign=top width=310 align=left&gt; &lt;TABLE style="BORDER-BOTTOM: #cdcdcd 1px solid; BORDER-LEFT: #cdcdcd 1px solid; PADDING-BOTTOM: 10px; BACKGROUND-COLOR: #eee; PADDING-LEFT: 10px; PADDING-RIGHT: 10px; BORDER-TOP: #cdcdcd 1px solid; BORDER-RIGHT: #cdcdcd 1px solid; PADDING-TOP: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px" id=machine_buttons border=0 cellSpacing=3 cellPadding=0&gt; &lt;TBODY&gt; &lt;TR&gt; &lt;TD&gt;&lt;A onmouseover="swapImg('Manufact', true)" onmouseout="swapImg('Manufact', false)" href="/manufacturer.php?brand=Speedaire"&gt;&lt;IMG id=icon_Manufact border=0 alt="" src="/images/machine_button_Manufact.gif" width=66 height=33&gt;&lt;BR&gt; Manufacturer Info&lt;/A&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD&gt;&lt;A onmouseover="swapImg('Category', true)" onmouseout="swapImg('Category', false)" href="/listing.php?cat=Air+Compressors"&gt;&lt;IMG id=icon_Category border=0 alt="" src="/images/machine_button_Category.gif" width=66 height=33&gt;&lt;BR&gt; Similar Machines&lt;/A&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD&gt;&lt;A onmouseover="swapImg('Brochure', true)" onmouseout="swapImg('Brochure', false)" href="/manufacturer.php?brand=Speedaire#brochures" target=_blank&gt;&lt;IMG id=icon_Brochure border=0 alt="" src="/images/machine_button_Brochure.gif" width=66 height=33&gt;&lt;BR&gt; OEM Brochure&lt;/A&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD&gt;&lt;A style="CURSOR: pointer" id=shadowbox_email class=sb title="Used Speedaire Air Compressor" href="/share.php?id=7135" rel=shadowbox;width=520;height=500 shadowboxCacheKey="1" onMouseOver="swapImg('Email', true)" onMouseOut="swapImg('Email', false)" jQuery1316148993734="2"&gt;&lt;IMG id=icon_Email border=0 alt="" src="/images/machine_button_Email.gif" width=66 height=33 jQuery1316148993734="3"&gt;&lt;BR&gt; Email A Friend&lt;/A&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD&gt;&lt;A onmouseover="swapImg('Ship', true)" onmouseout="swapImg('Ship', false)" href="/shipping.php?id=7135"&gt;&lt;IMG id=icon_Ship border=0 alt="" src="/images/machine_button_Ship.gif" width=66 height=33&gt;&lt;BR&gt; Shipping&lt;/A&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;/TBODY&gt; &lt;/TABLE&gt; &lt;DIV id=QuickQuote&gt;&lt;A href="/machine-print.php?id=7135" target=_blank&gt;&lt;IMG title="Print a Quick Quote!" border=0 alt="Print a Quick Quote!" align=absMiddle src="http://www.sterlingmachinery.com/images/quick_quote.jpg"&gt; &lt;/A&gt;&lt;/DIV&gt; &lt;DIV style="MARGIN: 5px 0px 0px 45px"&gt; &lt;FORM method=post name=addmachine action=/request-quote.php jQuery1316148993734="5"&gt;&lt;INPUT id=add title="Add Machine to Quote Cart" value="Add Machine to Quote Cart" alt="Add Machine to Quote Cart" src="http://www.sterlingmachinery.com/images/quick_add.jpg" type=image name=add jQuery1316148993734="7"&gt; &lt;IMG style="DISPLAY: none; CURSOR: pointer" id=remove title="Remove from quote cart" name=remove alt="Remove from quote cart" src="/images/remove.gif" width=16 height=16 jQuery1316148993734="8"&gt; &lt;DIV style="MARGIN-TOP: 5px"&gt;&lt;INPUT id=view title="View Quote Cart" value="View Quote Cart" alt="View Quote Cart" src="http://www.sterlingmachinery.com/images/quick_view.jpg" type=image name=view&gt;&lt;/DIV&gt; &lt;/FORM&gt; &lt;/DIV&gt; &lt;BR&gt; &lt;TABLE id=machine_stats border=0 cellSpacing=5 cellPadding=0 width=300&gt; &lt;TBODY&gt; &lt;TR&gt; &lt;TD class=field vAlign=top align=right&gt;Stock #&lt;/TD&gt; &lt;TD vAlign=top align=left&gt;A1194&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD class=field vAlign=top align=right&gt;Manufacturer:&lt;/TD&gt; &lt;TD vAlign=top align=left&gt;&lt;A href="/manufacturer.php?brand=Speedaire"&gt;Speedaire&lt;/A&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD class=field vAlign=top align=right&gt;Model:&lt;/TD&gt; &lt;TD vAlign=top align=left&gt;&lt;A href="/listing.php?cat=Air+Compressors"&gt;&lt;/A&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD class=field vAlign=top align=right&gt;Capacity:&lt;/TD&gt; &lt;TD vAlign=top align=left&gt;&lt;A href="/listing.php?cat=Air+Compressors"&gt;5 CFM&lt;/A&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD class=field vAlign=top align=right&gt;Price:&lt;/TD&gt; &lt;TD vAlign=top align=left&gt;&lt;SPAN style="BACKGROUND-COLOR: #ffff00"&gt;$350&lt;/SPAN&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD class=field vAlign=top align=right&gt;Category:&lt;/TD&gt; &lt;TD vAlign=top align=left&gt;&lt;A href="/results.php?keywords=Air+Compressors"&gt;Air Compressors&lt;/A&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD class=field vAlign=top align=right&gt;Condition:&lt;/TD&gt; &lt;TD vAlign=top align=left&gt;Used Machinery&lt;/TD&gt; &lt;/TR&gt; &lt;/TBODY&gt; &lt;/TABLE&gt; &lt;FIELDSET&gt;&lt;LEGEND&gt;Full Description&lt;/LEGEND&gt; &lt;TABLE id=machine_specs border=0 cellSpacing=0 cellPadding=4 width=300&gt; &lt;TBODY&gt; &lt;TR&gt; &lt;TD style="BORDER-RIGHT-WIDTH: 0px; BORDER-TOP-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px" class=field vAlign=top align=right&gt;CFM Rating:&lt;/TD&gt; &lt;TD style="BORDER-RIGHT-WIDTH: 0px; BORDER-TOP-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px" vAlign=top align=left&gt;5&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD class=field vAlign=top align=right&gt;Tank Size:&lt;/TD&gt; &lt;TD vAlign=top align=left&gt;60 Gallon&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD class=field vAlign=top align=right&gt;Weight:&lt;/TD&gt; &lt;TD vAlign=top align=left&gt;400 LBS.&lt;/TD&gt; &lt;/TR&gt; &lt;/TBODY&gt; &lt;/TABLE&gt; &lt;/FIELDSET&gt; &lt;FIELDSET&gt;&lt;LEGEND&gt;Equipped With&lt;/LEGEND&gt;Single Phase Motor&lt;BR&gt; Horsepower: 1 1/2&lt;/FIELDSET&gt; &lt;DIV class=privates&gt;* Temporary specifications subject to verification.&lt;BR&gt; &amp;nbsp; All quotations subject to prior sale.&lt;/DIV&gt; &lt;/TD&gt; &lt;/TR&gt; &lt;/TBODY&gt; &lt;/table&gt; </code></pre> <p>I have write this code but its not getting properly. Outer foreach loops runs 17 times but should be only two time because the outer table has only two rows.</p> <pre><code>$xml = new DOMDocument(); $xml-&gt;validateOnParse = true; $xml-&gt;loadHTMLFile($url); $xpath = new DOMXPath($xml); $table =$xpath-&gt;query("//*[@id='machine']")-&gt;item(0); echo "&lt;table border=2&gt;"; $rows = $table-&gt;getElementsByTagName("tr"); foreach ($rows as $row) //there i only two rows. { echo "&lt;tr&gt;"; $cells = $row -&gt; getElementsByTagName('td'); foreach ($cells as $cell) { echo "&lt;td&gt;"; foreach ($cell-&gt;getElementsByTagName('table') as $innerTable ) { foreach ( $innerTable-&gt;getElementsByTagName("tr") as $innerTrs) { foreach ( $innerTrs-&gt;getElementsByTagName('td') as $innerCell) { foreach ($innerCell-&gt;getElementsByTagName('a') as $a ) { echo '&lt;br&gt;&lt;a href="'.GetMainBaseFromURL($url).$a-&gt;getAttribute('href').'"&gt;'.$a-&gt;nodeValue.'&lt;/a&gt;'; foreach ($a-&gt;getElementsByTagName('img') as $img ) echo '&lt;br&gt;&lt;a href="'.GetMainBaseFromURL($url).$a-&gt;getAttribute('href').'"&gt; &lt;img src="'.GetMainBaseFromURL($url).$img-&gt;getAttribute('src').'"&gt;&lt;/a&gt;'; } } } } echo "&lt;/td&gt;"; } echo "&lt;/tr&gt;"; } echo "&lt;/table&gt;"; </code></pre> <p>Then how can i print as it is html table in my web page using php dom document. I am new in php dom.</p> <p>Thank you. Thanks a lot.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UShakre
    1. USBajrang
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhat did not work? Are you getting any error?
      singulars
      1. POprint html table using php dom document
      1. UShakre
    2. CONot getting errors but it prints only inner html table data, not printing outer data which are inside the outer table but outside the inner html tables.
      singulars
      1. POprint html table using php dom document
      1. USBajrang
    3. COThen what i have to write for this? The data for first tr is not printing.
      singulars
      1. POprint html table using php dom document
      1. USBajrang
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload