Selecting middle part of a string / mySQL result with PHP or query

Question

Possible Duplicate:
How to parse and process HTML with PHP?

I am selecting a column from a mySQL table which has a value something like this:

<div class="article news group">
    <p class="news_info">18/10/12</p>
    <h2>Hello world!</h2>
    <p>ertwrt aerteartert</p>
    <p>ertaertert</p>
    <p>waertwertwertwaertweart</p>
</div>

I now need to only get the 3 p tags from this - so returning:

    <p>ertwrt aerteartert</p>
    <p>ertaertert</p>
    <p>waertwertwertwaertweart</p>

Is there an easy way to do this with php or will I need to use jQuery to remove the unwanted code.

Either way, any ideas how I would do it?

It's better to do it with PHP if it's unwanted. No reason to send it to the client (more traffic) and then remove it. PHP & regular expressions are what you need in this instance. — Reinstate Monica Cellio, Oct 18 '12 at 10:42

score 2 · Accepted Answer · answered Oct 18 '12 at 10:46

Using PHP

$html = '<div class="article news group">
    <p class="news_info">18/10/12</p>
    <h2>Hello world!</h2>
    <p>ertwrt aerteartert</p>
    <p>ertaertert</p>
    <p>waertwertwertwaertweart</p>
</div>';

preg_match_all('~(<p>.+?</p>)~', $html, $match);

echo implode("\n", $match[1]);

score 0 · Answer 2 · answered Oct 18 '12 at 10:42

0

This may be help for your needs : http://api.jquery.com/siblings/

answered Oct 18 '12 at 10:42

senthilbp

807
1
9
16

score 0 · Answer 3 · answered Oct 18 '12 at 11:34

0

If the html you are processing is more complicated than the example you might want to consider QueryPath (http://querypath.org/)

It would be overkill for your example but can be quite useful for this type of manipulation.

answered Oct 18 '12 at 11:34

Rick Burgess

704
1
5
12

Selecting middle part of a string / mySQL result with PHP or query

3 Answers3