Please :) Help!

[Anon]

Hi Guys

My question/problem is in relation to an admin script, which I'm trying
to write for a search engine. Basically what it needs to do is validate (URL)
records in a simple text database.

The format of the database is as follows:

There are 6 fields.

date_time type title description url keywords name

The delimiter is ----

Example: -

12/27/2000 09:46:11----html----Sublite Web Design----Sublite Web Site Design Services.----http://www.sublite.co.uk----sublite,website,development,site,internet----(none given)

I need to write a script that loops though the database and tests each
record to see if it's URL is working.

The script then should delete any record(s) which point to dead URL's
and produce 404 errors etc.

Any ideas on how I could go about coding this?

Greg🙂

[e-mail]

[Anon]

Are you looking for help on how to work with the data and split between the "----" (which I could help with), or a function to determine if a 404 results (I can't think of anything off-hand).

[Anon]

to check the urls, use fsockopen, send a http request and read one line of whatever the webserver answers, that contains the result. 200=ok, 404=not found etc.

[Anon]

And to get the URL, you could just use split(), and look for ----, it will split your string into an array, in which your URL field would be array[4]. Then as vincent said you would use fsockopen() and get the result.