[RESOLVED] Need some help with preg_match_all

[savj14]

After running my code I get results as follows:

Highest Skill - 29 (#79852)
Total EXP - 299 (#62976)

This is fine except I want to only have it display:
Highest Skill - 29
Total EXP - 299

So for some reason I cannot seem to strip out what I need.

<?php

$url = "http://www.halo3leaderboard.com/ManHands14";

$raw = file_get_contents($url);

$newlines = array("\t","\n","\r","\x20\x20","\0","\x0B");

$content = str_replace($newlines, "", html_entity_decode($raw));

//$start = strpos($content,'<table cellpadding="2" class="standard_table"');
$start = strpos($content,'<table class="DataDisplay" width="100%" border="0" cellspacing="0" cellpadding="0">');

//$end = strpos($content,'</table>',$start) + 8;
$end = strpos($content,'<td valign="center"><div align="left" class="White8ptTxt_Bold">Social Kills</div></td>',$start) + 8;

$table = substr($content,$start,$end-$start);

preg_match_all("|<tr(.*)</tr>|U",$table,$rows);

foreach ($rows[0] as $row){

if ((strpos($row,'<th')===false)){

    preg_match_all("|<td(.*)</td>|U",$row,$cells);

    $title = strip_tags($cells[0][0]);

    $rank = strip_tags($cells[0][1]);

 $new_rank = preg_replace('/\s\(#\d+\)$/', '', $rank);


    $position = strip_tags($cells[0][2]);


	 echo "{$title} - {$new_rank}<br>\n";

}

}

?>

Any thoughts?

[savj14]

Anyone???

[halojoy]

i make a try
even if regex is not my strongest point i am not toally lost 😃

I did a try at my private php server
Looks like it works .. at least with the simple string I used for test:
$str = '29 (#12345)'

<?php

$str = '29 (#12345)';

$remove = '=[\(#].*[\)]=';

$res = preg_replace($remove, '', $str);
$res = trim($res); // trim away eventual spaces
echo $res;

?>

regars 🙂
halojoy

[savj14]

halojoy wrote:

i make a try
even if regex is not my strongest point i am not toally lost 😃

I did a try at my private php server
Looks like it works .. at least with the simple string I used for test:
$str = '29 (#12345)'

<?php

$str = '29 (#12345)';

$remove = '=[\(#].*[\)]=';

$res = preg_replace($remove, '', $str);
$res = trim($res); // trim away eventual spaces
echo $res;

?>

regars 🙂
halojoy

Thanks for the reply. The only thing with that is the string 29 (#12345) will change frequently. So I would need someway to say remove (whatever number is inside)......That way not matter what number is inside it would remove it.

[bradgrafelman]

Instead of using [man]preg_replace/man to trim up the data matched, it would make more sense to simply match only the data you want.

Can you show us an example of the HTML you're trying to grab? Also, note that any change in the structure of the HTML could easily break your script.

[savj14]

For example I am trying to grab data from [URL="$url = "http://www.halo3leaderboard.com/ManHands14";"]http://www.halo3leaderboard.com/ManHands14[/URL]

And I'm grabbing everything from the Latest Multiplayer statistics for ManHands14 Table.

Is that what you meant about the HTML or did you want the code?

You can see what I am trying to grab as far as coding goes by looking at:

$url = "http://www.halo3leaderboard.com/ManHands14"; 

$start = strpos($content,'<table class="DataDisplay" width="100%" border="0" cellspacing="0" cellpadding="0">');

$end = strpos($content,'<td valign="center"><div align="left" class="White8ptTxt_Bold">Social Kills</div></td>',$start) + 8; 

[aCa]

Hi savj14.

If I have understood you correctly you just wan't the data from the stats table right?

I needed a short brake from developing my regex tool so I thought I would give you a hand 😉

$url = "http://www.halo3leaderboard.com/ManHands14"; 

$raw = file_get_contents($url);

preg_match('/<table width="100%" border="0" cellspacing="3" cellpadding="0">(.*)<\/table>/sU', $raw, $result);

$result = preg_replace('/(.+)&nbsp;.*/', '$1', strip_tags($result[1]));
$result = preg_split('/\s{2,}/', $result, -1, PREG_SPLIT_NO_EMPTY);

$result is an array with all the stats.

Hope it helps.

[halojoy]

savj14 wrote:

So I would need someway to say remove (whatever number is inside)......That way not matter what number is inside it would remove it.

And this is what my code does!
So I guess you didnt try my code????????????

Again,
my suggestion will remove any I[/I]

I thought I have tried to help all sorts of persons.
Some smart, some not so smart, a few even plain stupid.

But this .. they do not even bother to test if my advice is good ...
When I tell I have tsted it at my php server. And it works.
Dont you believe in me?
See my profile.
I have posted 1.800 posts.
Been helping here for 2-3 years.
Maybe I did learn something,
maybe I know some things PHP after all these posts .. or ...

Ohhhh, it cant be true. Say it is not true, savj14 :queasy: :queasy:

<?php

$remove = '&#164;[\(#].*[\)]&#164;';
$new_rank = preg_replace($remove, '', $rank);

?>

regars 🙂
halojoy

[savj14]

I wasn't doubting your skills and/or knowledge. I quickly glanced at what you posted and it looked similar to something I have already tried.

I just looked at it again and I should have tested it. I thought it would only work with the string I gave you.

So yes I should have tried it, because it works with what I have now. I don't think you needed to write all that in your post. A simple did you test what I posted would have worked just fine.

Thank you for your help and sorry for not testing first.