Pass data and replace in Javascript / PHP

Question

Let's say I already have near 2000 lines like these:

<div style="position:absolute;top:461;left:167"><nobr>1 001 A NAME HERE</nobr></div>
<div style="position:absolute;top:461;left:682"><nobr>TRUE</nobr></div>
<div style="position:absolute;top:480;left:167"><nobr>2 002 ANOTHER NAME GOES HERE</nobr></div>
<div style="position:absolute;top:480;left:682"><nobr>FALSE</nobr></div>

and I want to pass them automatically into a table like here:

<tr>
    <td class="id">1</td>
    <td class="serial">001</td>
    <td class="name">A NAME HERE</td>
    <td class="accepted">TRUE</td>
</tr>
<tr>
    <td class="id">2</td>
    <td class="serial">002</td>
    <td class="name">ANOTHER NAME GOES HERE</td>
    <td class="accepted">FALSE</td>
</tr>

Can you help me on how can I do that with PHP/Javascript?

PS: It doesn't matter the style defined, since it will be easier in tables.

@JBRTRND I already have them, in an HTML file. Any suggestion? — Luis
– Luis, Commented Jul 27, 2012 at 13:23
So, I think you should use Javascript/jQuery to achieve what you want to do.(You don't have any way to store these lines in database ?) — jbrtrnd
– jbrtrnd, Commented Jul 27, 2012 at 13:23

user1028286 · Accepted Answer · 2012-07-27 13:48:24Z

1

Here is a javascript version.

    <script>
        var data = [];

        $('div').each(function(index) {
            data[index] = $(this).text();
        });

        var str = '';

        for (var i=0; i < data.length; i=i+2) {
            var temp = data[i].split(' ');
            var name = temp.slice(2).join(' ');
            str += '<tr>' +
                        '<td class="id">'+ temp[0] + '</td>' + 
                        '<td class="serial">' + temp[1] + '</td>' +
                        '<td class="name">' + name +'</td>' +
                        '<td class="accepted">' + data[i + 1] + '</td>' +
                    '</tr>';
            temp = [];
        }

        console.log(str);
    </script>

The str variable contains your table data. Just add that data to your html page.

answered Jul 27, 2012 at 13:48

user1028286

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

2 Comments

Luis Over a year ago

It's not working at all, sorry but the data is getting the same and it also throws a lot of "undefined" strings.

Luis Over a year ago

Oww, sorry men! This worked just right now, it's the best answer ;)

Dzhuneyt · Accepted Answer · 2012-07-27 13:45:58Z

1

Assuming $str contains your input DIVs:

<?php
preg_match_all('#<nobr>(?P<id>\d)(\s)(?P<number>\d{3})(\s)(?P<name>.*)</nobr>#Ui', $str, $names, PREG_SET_ORDER);
preg_match_all('#<nobr>(?P<bool>TRUE|FALSE)</nobr>#Ui', $str, $bools, PREG_SET_ORDER);

foreach($names as $i=>$row){
    echo '<tr>
            <td class="id">'.$row['id'].'</td>
            <td class="serial">'.$row['number'].'</td>
            <td class="name">'.$row['name'].'</td>
            <td class="accepted">'.$bools[$i]['bool'].'</td>
           </tr>'. PHP_EOL;
}
?>

Note that this code is not affected by how your line endings are formatted, because it uses regular expression.

answered Jul 27, 2012 at 13:45

Dzhuneyt

8,75116 gold badges68 silver badges120 bronze badges

1 Comment

Luis Over a year ago

I'm sorry but it throws... nothing.

Rupesh Patel · Accepted Answer · 2012-07-27 13:41:32Z

0

lat say your curent html in temp.html

get all data in a php variable;

$data = file_get_contents('temp.html');
$data_filter = explode('<nobr>',$data);

$final_data  = array();
foreach($data_filter as $df1)
{
   $temp = explode('</nobr>',$df1);
   $final_data[] = $temp[0];
}
// now all your required data is in an array in sequences of two
$str = '';
while(count($final_data))
{
  $name  = array_pop($final_data);
  while(strlen($name)<5){
  $name  = array_pop($final_data);
  }
  $accepted = array_pop($final_data);
  $name = explode(' ',$name);
  $str.= '<tr>
    <td class="id">'.$name[0].'</td>
    <td class="serial">'.$name[1].'</td>
    <td class="name">'.$name[2].'</td>
    <td class="accepted">'.$accepted.'</td>
</tr>
';
}
echo $str;

edited Jul 27, 2012 at 13:41

answered Jul 27, 2012 at 13:30

Rupesh Patel

3,0835 gold badges31 silver badges49 bronze badges

2 Comments

Luis Over a year ago

<tr>     <td class="id">TRUE</td>     <td class="serial"></td>     <td class="name"></td>     <td class="accepted">1 001 A NAME HERE</td> </tr>

its not parsing correctly the data.

Luis Over a year ago

The same thing, but I thing I saw the error. The first line it pushes contents

<tr>     <td class="id"><div</td>     <td class="serial">style="position:absolute;top:461;left:167"></td>     <td class="name"></td>     <td class="accepted"></td> </tr>

so I thing you need to parse the style.

Luis · Accepted Answer · 2012-07-27 13:46:32Z

0

$string is the string of all the divs. Assumes linebreaks are \r\n, change all those to correct linebreaks

$sections = explode("\r\n", strip_tags($string));//Remove divs ad nobrs and sort into lines
$numSections = count($sections);
for($row = 0; $row < $numSections; $row += 2) {
    $rows[0] = explode(" ", $sections[$row]);
    $rows[1] = $sections[$row + 1];?>
<tr>
    <td class="id"><?php echo $rows[0][0]; ?></td>
    <td class="serial"><?php echo $rows[0][1]; ?></td>
    <td class="name"><?php for($i=2; $i<count($rows[0]); $i++) echo $rows[0][$i]+" "; ?></td>
    <td class="accepted"><?php echo $rows[1]; ?></td>
</tr>

<?php  }

Assumes you wanted it echo'd

edited Jul 27, 2012 at 13:46

Luis

1,1171 gold badge14 silver badges25 bronze badges

answered Jul 27, 2012 at 13:23

meiamsome

2,9441 gold badge19 silver badges19 bronze badges

5 Comments

Luis Over a year ago

This is what I need, but just one question, can you see please again the question? There's no linebreak, someone edited in order to be more "clear".

meiamsome Over a year ago

Ah, I see. Give me a second and I'll have that fixed for you.

Luis Over a year ago

Sure, thanks. Also a little bit problem, in my $string I can't add those lines with the linebreaks, or yes? Because it throws Parse error: syntax error, unexpected '}' in ...

meiamsome Over a year ago

If that's the case it's an error with my code :P, try this one and comment the error if it comes out again!

Luis Over a year ago

It was throwing an Error: Wrong parameter count for explode() in (lines with $sections and $rows[0]), but I corrected the syntaxis and worked the explode function. Now I'm getting this

<tr>     <td class="id">1</td>     <td class="serial">001</td>     <td class="name">002 003 004...</td>     <td class="accepted"></td> </tr>

Collectives™ on Stack Overflow

Pass data and replace in Javascript / PHP

4 Answers 4

2 Comments

1 Comment

2 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related