Re: How do I pull out data from a mySQL DB...

[Peter Brawley]

If you execute this against the correct url, you ought to be able to see the problem.

$url = "<FILL THIS IN.html";
$lines = file( $url );
printf( "Lines found: %d<br/>", count($lines) );
$val = "Not found";
foreach( $lines as $l => $line ) {
$line = htmlspecialchars( $line );
$i = strpos( $line, "BODY" );
printf( "Line %d: %s<br/>", $l, $line );
if( $i > 0 ) {
$j = strpos( $line, "/BODY" );
$val = substr( $line, $i+8, $j-$i-12 );
break;
}
}
printf( "Value: %s<br/>", $val );