PHP - How to check URLS for 404/Timeout?

Question

Hi,

Here is my structure:

MYSQL: Table: toys ---> Column: id, URL. How do I get my PHP script to check all of those URLs to see if they are alive or have page 404's? Try not to echo or diplay the results on page. I will need to to record in MYSQL with a extra column "checks".

Results will be in this format:

http://asdasd.adas --- up --- 404

It will be in PHP/Curl if possible. I have been trying for ages. I gave up so decided to ask here.

URL's are all located in my database.

Thanks if anyone could help me out.

Answer 1

I trust you're able to run a SQL query and enumerate through the results, so here's the cURL part. For each URL, send it a HEAD request, and check the result code.

<?php
$handle = curl_init($yourURL);
curl_setopt($handle, CURLOPT_NOBODY, true);
curl_exec($handle);
$result = curl_getinfo($handle, CURLINFO_HTTP_CODE);
// $result now contains the HTTP result code the page sent
?>

Answer 2

In cURL, there's the curl_getinfo function, that returns some info about the current handle:

<?php
// Create a curl handle
$ch = curl_init('http://www.yahoo.com/');

// Execute
curl_exec($ch);

//fill here the error/timeout checks.

$http_code = curl_getinfo($ch,  CURLINFO_HTTP_CODE);