Parsing text to array in PHP or jQuery

Question

<?php 

$list = "<tr>
          <td>1.</td>
          <td>aaa</td>
          <td>234234</td>

          <td>1.</td>
          <td>bbb</td>
          <td>23423423</td>
        </tr>
        <tr>
          <td>2.</td>
          <td>ccc</td>

          <td>5644</td>
          <td>2.</td>
          <td>ddd</td>
          <td>4566456</td>
        </tr>
        <tr>
          <td>3.</td>

          <td>eee</td>
          <td>456456</td>
          <td>3.</td>
          <td>fff</td>
          <td>456456456</td>
        </tr>
"; ?>

CODEPAD: http://codepad.org/JaxTfBF6

How can i get all values from second and the fifth TD in each TR from variable $list? i would like receive array. I can use PHP or jQuery.

$all = array('aaa', 'bbb', 'ccc', 'ddd', 'eee', 'fff');

If you already have the data server-side, why would you want to send it to client-side ,parse it with jQuery, and then back to server-side? — kba
– kba, Commented Feb 2, 2012 at 14:08

Gary Chambers · Accepted Answer · 2012-02-02 14:11:46Z

2

var text = "<tr><td>1.</td><td>aaa</td><td>234234</td><td>1.</td><td>bbb</td><td>23423423</td></tr><tr><td>2.</td><td>ccc</td><td>5644</td><td>2.</td><td>ddd</td><td>4566456</td></tr><tr><td>3.</td><td>eee</td><td>456456</td><td>3.</td><td>fff</td><td>456456456</td></tr>";

var output = $(text).find("td:nth-child(2), td:nth-child(5)").map(function() {
    return $(this).text();
});

console.log(output);

answered Feb 2, 2012 at 14:11

Gary Chambers

25.9k5 gold badges37 silver badges31 bronze badges

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

Comments

Kory Hodgson · Accepted Answer · 2012-02-02 14:05:40Z

1

This would be pretty easy with jQuery.

You could load DOM objects from the string:

var values = [];
var domObj = $( input_string );

$( 'tr:nth-child(5)', domObj ).each( function() {

   values.push( this.val() );
});

answered Feb 2, 2012 at 14:05

Kory Hodgson

7901 gold badge5 silver badges15 bronze badges

Comments

Elzo Valugi · Accepted Answer · 2012-02-02 14:15:33Z

1

With PHP you can use DOM or simpleXML libraries to parse HTML or regular expressions.

answered Feb 2, 2012 at 14:15

Elzo Valugi

28.1k17 gold badges97 silver badges115 bronze badges

Comments

entropid · Accepted Answer · 2012-02-02 15:12:48Z

1

You could use jQuery:

var list = $('td:nth-child(2), td:nth-child(5)').map(function(){
   return $(this).text();
}).get()

It basically retrieves the fifth element of every td and then applied a function to each element, which replace the element itself with its text content.

edited Feb 2, 2012 at 15:12

answered Feb 2, 2012 at 14:07

entropid

6,2595 gold badges36 silver badges45 bronze badges

Comments

kba · Accepted Answer · 2012-02-02 15:40:56Z

1

It seems as if you already have the data on your server, so there is no reason to send it to the client, use jQuery to parse it, and then send it back to PHP.

Given your input array $list in PHP, you can do the following.

First match all <td> elements

if (preg_match_all('/<td>(.*)<\/td>/U', $list, $res))
    $res = end($res);

Then filter out all the wrong rows.

$count = 0;
$res = array_filter($res, function($item) use (&$count) {
    return (++$count%3==2);
});

Finally remove the old keys in the array and return it.

$res = array_values($res);
print_r($res);

The above should return

Array (
    [0] => aaa       [1] => bbb       [2] => ccc
    [3] => ddd       [4] => eee       [5] => fff
)

answered Feb 2, 2012 at 15:40

kba

19.5k6 gold badges65 silver badges90 bronze badges

Comments

Reinstate Monica Cellio · Accepted Answer · 2012-02-02 14:12:25Z

0

Similar to the other answers, but complete working code...

var all = [];

$("tr").each(function() {
    $(this).find("td:nth-child(2)").each(function() {
        all.push($(this).val());
    });
    $(this).find("td:nth-child(5)").each(function() {
        all.push($(this).val());
    });
})

answered Feb 2, 2012 at 14:12

Reinstate Monica Cellio

26.2k6 gold badges54 silver badges67 bronze badges

2 Comments

Reinstate Monica Cellio Over a year ago

No reason for downvotes? I'd like an explanation so I know what's wrong with the code.

Reinstate Monica Cellio Over a year ago

@PaulAttuck Thanks Paul, but I just wanted to know what people though was wrong with it. I tested it and it works so if it's bad code then I'd rather know why so I can learn from it.

Collectives™ on Stack Overflow

Parsing text to array in PHP or jQuery

6 Answers 6

Comments

Comments

Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related