Extracting from html using php

Dev Shed Forums Sponsor:

September 12th, 2008, 07:03 AM

livewire1974

Registered User

Join Date: Sep 2008

Posts: 2

Time spent in forums: 33 m 51 sec
Reputation Power: 0

Extracting from html using php

Hi,
I am completely new to regexp, but i think i need some to extract some info from a table that i have, maybe somebody can give me some pointers?

here is the html,

Code:

<table width="430"  border="0" cellpadding="4">                     <tr>                       <td width="122" valign="top"><img src="graphics/ice_logo_1.gif"></td>                       <td width="130" valign="top"><p class="style3"><strong>Home Broadband</strong><br /><span class="tool">Wireless <a href="" title="">  <img src="graphics/tooltip.gif" width="10" height="10" border="0"></a></span><br /><em>Cont </em> (36:1) <a href=""  title=""><img src="graphics/tooltip.gif" width="10" height="10" border="0"></a><br>                         </p></td>                      <td width="100" valign="top"><span class="style3">                          <em>Dn</em>  					 3Mbps					  <em><a href="" title=""> <img src="graphics/tooltip.gif" width="10" height="10" border="0"></a></em><br>                           <em>Up</em>                            1Mbps</span>  <span><em><a href="" title=""><strong><img src="graphics/tooltip.gif" width="10" height="10" border="0"></strong></a></em></span></td>                       <td width="78" align="right" valign="top"><p> &euro;37.99 <a href="test" title=""> <strong><img src="graphics/tooltip.gif" width="10" height="10" border="0"></strong></a><br /> 					                        </p>                         </td>                     </tr>                   </table>

can somebody help me get the fields from this?

September 12th, 2008, 08:27 AM

ishnid

kill 9, $$;

Dev Shed God 4th Plane (6500 - 6999 posts)

Join Date: Sep 2001

Location: Shanghai, An tSín

Posts: 6,894

Time spent in forums: 4 Months 2 Weeks 1 Day 22 h 36 m 34 sec
Reputation Power: 3885

Generally using your own regexps to parse HTML is a bad idea. I'm not PHP programmer, but I'd be pretty confident there should be HTML parsing libraries available to do this kind of task.

__________________
~ishnid;

Have you tried:
[ search.cpan.org | perldoc | Java API | mysql.com | google ]

Apostrophes are NOT used for possessive pronouns or for noun plurals, including acronyms.

September 12th, 2008, 11:34 AM

ManiacDan

Likely to be eaten by a grue.

Dev Shed God 10th Plane (9500 - 9999 posts)

Join Date: Oct 2006

Location: Pennsylvania, USA

Posts: 9,804

Folding Points: 127430 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 2 Months 3 Weeks 17 h 28 m 32 sec
Reputation Power: 6112

This will give you all the contents of the <td> fields:

PHP Code:


		
			
 $string = <<<STRING

<table width="430"  border="0" cellpadding="4">                     <tr>                       <td width="122" valign="top"><img src="graphics/ice_logo_1.gif"></td>                       <td width="130" valign="top"><p class="style3"><strong>Home Broadband</strong><br /><span class="tool">Wireless <a href="" title="">  <img src="graphics/tooltip.gif" width="10" height="10" border="0"></a></span><br /><em>Cont </em> (36:1) <a href=""  title=""><img src="graphics/tooltip.gif" width="10" height="10" border="0"></a><br>                         </p></td>                      <td width="100" valign="top"><span class="style3">                          <em>Dn</em>                       3Mbps                      <em><a href="" title=""> <img src="graphics/tooltip.gif" width="10" height="10" border="0"></a></em><br>                           <em>Up</em>                            1Mbps</span>  <span><em><a href="" title=""><strong><img src="graphics/tooltip.gif" width="10" height="10" border="0"></strong></a></em></span></td>                       <td width="78" align="right" valign="top"><p> &euro;37.99 <a href="test" title=""> <strong><img src="graphics/tooltip.gif" width="10" height="10" border="0"></strong></a><br />                                             </p>                         </td>                     </tr>                   </table>

STRING;



preg_match_all("#<td[^>]*>(.+?)</td#", $string, $foo);

print_r($foo[1]);

However, it also includes plenty of HTML. If the HTML is properly formed, you can use the DOM document model to parse it, but I personally like using regexp for this sort of thing.

-Dan

__________________
HEY! YOU! Read the New User Guide and Forum Rules

"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002

Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.

Extracting from html using php

Developer Shed Advertisers and Affiliates