Re: PHP to grab the html from a URL and insert into MySQL

[keith handy]

Nick,

ISBN Number? Text from Book? Not sure what you mean here.

The operating system is Windows NT 4.0 (soon to be upgrading). The OS shouldn't have any impact on the functionality will it?

I have been playing with your code and it works for .HTML, .CFM, .ASP, .PHP .TXT pages (am i missing any?). Which is great. However it does not seem to work for local documents on our site (http://www.mysite.com/index.asp). I get a couple of errors that look like this when I try local documents:

1. Warning: fopen() [function.fopen]: php_hostconnect: connect failed in f:\Inetpub\wwwroot\urlgrabber.php on line 59

2. Warning: fopen(http://www.mysite/test.asp) [function.fopen]: failed to create stream: Bad file descriptor in f:\Inetpub\wwwroot\urlgrabber.php on line 59

3. Notice: Undefined variable: okread in f:\Inetpub\wwwroot\urlgrabber.php on line 65

Any ideas?

I think this is on the right track and could be a possible solution if I could figure out how to strip out HTML tags (so I only get the text) and to solve the .PDF and .DOC problems. I'll continue to play with it.

Keith