Test liens stockés dans base de données, en PHP. Mai 2006.

testlink.php

#!/usr/bin/php
<?php
mysql_connect("ipserver","user","pass");
mysql_select_db("database");
echo "selected db... ready\n";

$res = mysql_query("SELECT iddat,nomdat,linkdat,owner FROM resdat ORDER BY iddat");
mysql_close();
while($dat = mysql_fetch_array($res)) {
  unset($result);
	echo "Testing page $dat[iddat]...";
	exec("wget --spider '$dat[linkdat]' 2>&1",$result);
	echo " OK\n";
	$resstr="";
	foreach($result as $line) $resstr.="$line\n";
#	echo $resstr;
	if(preg_match("/erreur/i",$resstr)) {
		echo "----- $dat[iddat] = ERREUR -----\n $dat[nomdat] ($dat[owner])\n";
		echo $resstr;
		echo "----------------------------------------------------------\n";
	} else {
		echo "----- $dat[iddat] = OK! -----\n";
	}
}

?>