[RESOLVED] need help get info from string -fopen

planethax

I am using fopen to get contents of standings page,
what would I use (preg_match?) to get the info rank driver etc?
this is what I have sofar

<?php

$handle = fopen("http://www.mysite.com/standings.html", "rb");
$contents = '';
while (!feof($handle)) {
$contents .= fread($handle, 8192);
}
fclose($handle);

preg_match_all('/a href\=\"(http\:\/\/.*?)\"/',
$contents, $matches);

foreach ($matches[1] as $url) {
echo $url . "
";
}
?>

this is what the standings page looks like

</tr>
        			<tr>
					   <th>RANK</th>
					   <th>+/-</th>
					   <th>DRIVER</th>
					   <th>POINTS</th>
					   <th>BEHIND</th>
					   <th>STARTS</th>
					   <th>POLES</th>
					   <th>WINS</th>
					   <th>TOP 5</th>
					   <th>TOP 10</th>
					   <th class="cnnLast">WINNINGS</th>					
					</tr>
					<tbody id="cnnDataBody">



<tr><td>1</td><td>--</td><td><a href='/drivers/dps/tstewart00/cup/index.html'>Tony Stewart</a></td><td>3188</td><td>Leader</td><td>21</td><td>0</td><td>2</td><td>12</td><td>17</td><td class="cnnLast">4,850,180</td></tr>
<tr><td>2</td><td>--</td><td><a href='/drivers/dps/jjohnson00/cup/index.html'>Jimmie Johnson</a></td><td>2991</td><td>-197</td><td>21</td><td>0</td><td>3</td><td>9</td><td>14</td><td class="cnnLast">4,472,040</td></tr>
<tr><td>3</td><td>--</td><td><a href='/drivers/dps/jgordon00/cup/index.html'>Jeff Gordon</a></td><td>2989</td><td>-199</td><td>21</td><td>0</td><td>1</td><td>10</td><td>15</td><td class="cnnLast">4,178,270</td></tr>
<tr><td>4</td><td>--</td><td><a href='/drivers/dps/kbusch00/cup/index.html'>Kurt Busch</a></td><td>2751</td><td>-437</td><td>21</td><td>0</td><td>1</td><td>6</td><td>11</td><td class="cnnLast">2,928,560</td></tr>

planethax

or should i use fgetss ?
can someone pot a quick example?

planethax

If I use fopen and fgets,
how can I get the pointer to start at
<tbody id="cnnDataBody">

thanx

planethax

the following has an error, results blank page.
Can anyone help me fix it?

thanx

<?php
$fh = fopen("http://www.nascar.com/races/cup/2009/data/standings_official.html", "rb");

while (!feof($fh)) {
	$line = fgets($fh);
	echo $line;
}

fclose($fh);
?>
<html>
<head><title>Standings</title>


</head>
<body>
<?

$split1 = "<!--endclickprintexclude-->"; // end of google header - this may change so keep tabs on googles source code
$split2 = "<div class="cnnRaceExtras">* Denotes Rookie"; // beginning of  footer - this may also change - see above

$results = explode($split1, $contents); // seperate header from page

//print_r($results); // use to check array in debugging

$topchunk = $results[0]; // google header, which we wont be using
$midchunk = $results[1]; // the rest of the page, which includes the body and footer

$results2 = explode($split2, $midchunk); // seperate footer from page

$body = $results2[0]; // the page without the header or footer

echo $body;
?>
</body>
</html>

Weedpacket

Well, you echo everything you got from the other page before you start your own; and $contents never gets set to anything.

That whole chunk of PHP at the top could be replaced with

$contents = file_get_contents('http://...blahblahblah...');

You may also want to keep in mind what it says on this page.

planethax

Well, Ideally,
I want to just goto the page,
just get the stats, (info in table)
Input to database,
Then insert the info from database into table.
That way I can just run the page once a week.

But having a tough time figuring that out.

Can you help?

planethax

To add,
I am not wanting to display the other sites table, I have it looking that way right now as I learn and try to adapt it to my needs.

Now I am think fgetss would be best,(to stip the html) but how to strip the before and after of the table.

There are many different standing I could use as well
ie
http://sports.yahoo.com/nascar/standings

planethax

Also, shouldn't this (with out formatting and a mess) echo all info and html in the table?

<?php
$fh = fopen("http://sports.yahoo.com/nascar/standings", "rb");

while (!feof($fh)) {
	$line = fgets($fh);
	echo $line;
}

fclose($fh);


$split1 = "<!--endclickprintexclude-->"; // end of google header - this may change so keep tabs on googles source code
$split2 = "<div class="cnnRaceExtras">* Denotes Rookie"; // beginning of  footer - this may also change - see above

$results = explode($split1, $contents); // seperate header from page

//print_r($results); // use to check array in debugging

$topchunk = $results[0]; // google header, which we wont be using
$midchunk = $results[1]; // the rest of the page, which includes the body and footer

$results2 = explode($split2, $midchunk); // seperate footer from page

$body = $results2[0]; // the page without the header or footer

echo $body;
?>

planethax

Well, this does not work either, but can anyone tell me if I am getting closer?

<?php
$fh = fopen("http://sports.yahoo.com/nascar/standings", "rb");

$file = file_get_contents("http://sports.yahoo.com/nascar/standings");


fclose($fh);


$split1 = "<!--endclickprintexclude-->"; // end of google header - this may change so keep tabs on googles source code
$split2 = "<div class="cnnRaceExtras">* Denotes Rookie"; // beginning of  footer - this may also change - see above

$results = explode($split1, $contents); // seperate header from page

//print_r($results); // use to check array in debugging

$topchunk = $results[0]; // google header, which we wont be using
$midchunk = $results[1]; // the rest of the page, which includes the body and footer

$results2 = explode($split2, $midchunk); // seperate footer from page

$body = $results2[0]; // the page without the header or footer

echo $body;
?>

planethax

Any thoughts?

I think its the way I am using the split?

planethax

Lots of views, but no replies,
Should I have posted this in the "coding" section?

planethax

I have also tried this,
what am I missing here?

<?php
$fh = fopen("http://sports.yahoo.com/nascar/standings", "rb");

$file = file_get_contents("http://sports.yahoo.com/nascar/standings");


fclose($fh);
$contents = $file

$split1 = "<!--endclickprintexclude-->"; // end of google header - this may change so keep tabs on googles source code
$split2 = "<div class="cnnRaceExtras">* Denotes Rookie"; // beginning of  footer - this may also change - see above

$results = explode($split1, $contents); // seperate header from page

//print_r($results); // use to check array in debugging

$topchunk = $results[0]; // google header, which we wont be using
$midchunk = $results[1]; // the rest of the page, which includes the body and footer

$results2 = explode($split2, $midchunk); // seperate footer from page

$body = $results2[0]; // the page without the header or footer

echo $body;
?>

planethax

There are many sites that have Nascar standings.
They all seem to be updated at exact same time.
So I am assuming most go some place, grab the info to update their own site (CNN, Yahoo, SI, Msn, Nascar etc)

So this is all I am wanting to do.
I have a program to do this, but would rather to it server side with php once a week.

So, so far I am able to get the contents, but can someone please help me $strip the
Header (and all info before table) and all info after table.

Then I think I can use fgetss to remove html tags so I can insert into database.

I am not sure why I can get get any replies?
Am I doing something wrong?

Alittle advice please?

planethax

bpat1434
came up with this for me.

Thank you again!

Now I need to insert all this into my database.

What would be the best and easiest format as to be able to then retrieve info and insert into my own table?

1 table (standings)
12 Fields (rank, rankdelta,driver,points etc) ?

but will mark this one resolved and stay in coding section.

<?php
$url = 'http://sports.yahoo.com/nascar/standings';
$html = file_get_contents($url);

// First, get that one single table.
preg_match('~(<table width="100%" border="0" cellspacing="0" cellpadding="0">.*<tr.*class="ysptblthbody1".*>.*</table>)~iUs', $html, $matches);

// $matches[0] is now the full match (e.g. the whole $html content)
// $matches[1] is just the table we need

// We'll split it up between those in the contention and those not
preg_match('~(<tr class="ysprow(?:1|2)">.*)<tr><td.*><img.*></td></tr>(<tr class="ysprow(?:1|2)".*>.*</tr>.*)</table>~iUs', $matches[1], $parts);

// $parts[1] are those in contention
// $parts[2] are the other drivers in the field

// Look for all the information for those in contention, save to $matches
preg_match_all('~<tr class="ysprow.*">.*<td.*>.*([\d]*)</td>.*<td.*>([+|-][\d]*)</td><td class=".*padded2px.*".*>.*<a.*>(.*)</a></td>.*<td class=".*ysptblclbg6.*".*>(.*)</td>.*<td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td>.*</tr>~iUs', $parts[1], $matches, PREG_SET_ORDER);

// Look for all the information for the other drivers, store in $matches2
preg_match_all('~<tr class="ysprow.*">.*<td.*>.*([\d]*)</td>.*<td.*>([+|-][\d]*)</td><td class=".*padded2px.*".*>.*<a.*>(.*)</a></td>.*<td class=".*ysptblclbg6.*".*>(.*)</td>.*<td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td>.*</tr>~iUs', $parts[2], $matches2, PREG_SET_ORDER);

// Prepare our array for population
$drivers = array(
    'contention' => array(),
    'field' => array()
);

// Add the drivers in contention
foreach($matches as $match)
{
    $drivers['contention'][$match[1]] = array(
        'rank' => $match[1],
        'rank_delta' => $match[2],
        'driver' => $match[3],
        'points' => $match[4],
        'behind' => $match[5],
        'start' => $match[6],
        'poles' => $match[7],
        'wins' => $match[8],
        'top5' => $match[9],
        'top10' => $match[10],
        'dnf' => $match[11],
        'winnings' => $match[12]
    );
}

// Add those drivers that are in the rest of the field
foreach($matches2 as $match)
{
    $drivers['field'][$match[1]] = array(
        'rank' => $match[1],
        'rank_delta' => $match[2],
        'driver' => $match[3],
        'points' => $match[4],
        'behind' => $match[5],
        'start' => $match[6],
        'poles' => $match[7],
        'wins' => $match[8],
        'top5' => $match[9],
        'top10' => $match[10],
        'dnf' => $match[11],
        'winnings' => $match[12]
    );
}

echo '<pre>'.print_r($drivers, 1).'</pre>';