[Resolved] Link Validation

[gamew0rld]

Can someone please tell me how I can validate links in my MySQL database to make sure they work and are not dead links. I know I can use fsockopen to do it, but when I try it, it never works, I either get errors or it will say all of the links dont work. Any help would be appreciated. Thanks

Joe

[HalfaBee]

You could try doing fopen() on the remote file. If it exists you can just fclose() it.
If it fails it returns FALSE

HalfaBee

[gamew0rld]

I cant get it to work. Do you know of a site with a demo script I could look at?

[HalfaBee]

This will work.
It is fine for most links, except ones that are redirected.

HalfaBee

<?
$result = mysql_query( 'select * from tablename ' ) or die( mysql_error() );
while( ($row=mysql_fetch_assoc( $result ))!== FALSE )
{
    $link = fopen( $row['link'],'r' );
    if( $link === FALSE )
        echo "bad link {$row['link']}<BR>";
    else {
        echo "Good Link {$row['link']}<BR>";
        fclose( $link );
    }
}
?>

[gamew0rld]

Ok thanks, that works, but, if there is a broken link, there is also an error, like this:

Warning: fopen(http://www.tgamerzone.com/gamerzone/games/java/plopnoid/plopnoid.htm): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/public_html/check.php on line 7
bad link http://www.tgamerzone.com/gamerzone/games/java/plopnoid/plopnoid.htm

is there a way to get rid of that?

[HalfaBee]

Put @fopen( ....

HalfaBee

[gamew0rld]

Ok, thank you so much. I appreciate it