Selecting numbers inside HTML element in PHP

Question

<root>
<td align="left"><a title="Testing" href="www.test.com/product/">$129.00</a></td><td valign="bottom">Testing</td></root>

How do I go about selecting the 129.00 in the above example? I don't want the $.

Currently I have preg_match('/\$.{6}/') to select this. This is generally ok, but whenever it becomes a 4 digit string, it fails. Eg. $50.00

Thanks.

Yoshi · Accepted Answer · 2011-05-18 09:56:23Z

4

As many will tell you, don't use regex to parse html/xml structures. But if you really want or have to use regex, try this pattern:

\$([0-9\.]+)

for alternatives look here:

http://php.net/manual/en/book.simplexml.php

http://www.php.net/manual/en/book.dom.php

answered May 18, 2011 at 9:56

Yoshi

54.8k14 gold badges93 silver badges108 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Dean Over a year ago

Yeah, I know I should use DOM/XPath, but its a really simple document with a few lines of code... really cant be stuffed using extra stuff. Thanks!

Yoshi Over a year ago

Then I hope the pattern will work for you. But be aware, that it will not match if you have some characters others than 0-9 and .. Maybe adding chars for a thousands separator will be needed. (See: php.net/manual/en/regexp.reference.character-classes.php)

tradyblix Over a year ago

It does.. preg_match('/\$([0-9\.]+)/', $yourString, $matches); and do $matches[1] returns 129 or..how are you using it with other rows?

Dean Over a year ago

@tradybix ohh, my bad. It does work too, I accidentally removed one of the quotes ('). Thanks. However it does not remove the $.

Yoshi Over a year ago

preg_match is not the correct function if you want to remove something, look at preg_replace for this. (php.net/manual/en/function.preg-replace.php)

CyberVitor · Accepted Answer · 2011-05-18 09:59:06Z

1

Try this regex, got it from here: Link

 \$\d+\.\d{2}

answered May 18, 2011 at 9:59

CyberVitor

431 silver badge8 bronze badges

1 Comment

Dean Over a year ago

Doesn't seem to work... pastebin.com/WqEUKFNn and SQL result (id 29): img.acianet.co.uk/i/sqlfail.jpg

Community · Accepted Answer · 2017-05-23 11:47:53Z

0

replace all "foo" between two HTML tags using REGEX (PHP code)

<?php
$string ='<root>
<td align="left"><a title="Digitan Technology: Click to see item" href="www.digitan.com.au/home.php?cat=2655" target="retailer">$115.20</a></td><td valign="bottom">AMD PHENOM X4 Quad Core 9650 CPU, 2.3GHz (95W), 4MB Cache, Sockets AM2+/AM2</td></root>';
preg_match('/\$([0-9\.]+)(?=(?:.(?!<a))*<\/a>)/', $string, $match);
echo $match[1];
?>

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered May 18, 2011 at 11:00

BrankoR

961 bronze badge

Collectives™ on Stack Overflow

Selecting numbers inside HTML element in PHP

3 Answers 3

5 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related