Display content of a HTML file

[el_nino]

hey...

 

I have a postgreSQL database which contains URL's to HTML documents. I want to output the contents of this document on a particular page on my site. so far i have tried 'file_get_contents', 'include' and 'fopen' but dont seem to be getting anywhere. The code i am using is

 

<?php
            $sql="select * from jfs where issue = (select max(issue) from jfs) and format = 'html'";// selects the latest issue


            $result_set = pg_Exec ($conn, $sql);
            $rows = pg_NumRows($result_set);

            if ((!$result_set) || ($rows < 1)) {
                  echo "<H1>ERROR - no rows returned</H1><P>";
                  exit;  //exit the script
                  }

            for ($j=0; $j < $rows; $j++)
               {
               $issue = pg_result($result_set, $j, "issue");
               $page = pg_result($result_set, $j, "page");
               $author = pg_result($result_set, $j, "author");
               $title = pg_result($result_set, $j, "title");
               $format = pg_result($result_set, $j, "format");
               $url = pg_result($result_set, $j, "url");   

			//$url="http://google.co.uk/";
			//$home=readfile($url);
			include ("$url");
			//echo $home;



               }
?> 

<?php
        pg_FreeResult($result_set);
        pg_Close($conn);
?>

 

i know that my query my working as i am able to echo the url but cannot display the contents of the file

 

any help would be greatley appreciated

 

el nino

[rajivgonsalves]

what does the url looks like? is it on your own server or  from some other server, if its on your server is it absolute paths or just relative ?

[el_nino]

the url is on another server, it currently looks like:

 

http://www.comp.brad.ac.uk/intranet/modules/DWT/jfs/formats.html

[rajivgonsalves]

this

 

include ("$url");

 

should be

 

echo file_get_contents($url);

;

 

the reason its not showing up the url is not found.

[el_nino]

I tried

 

echo file_get_contents($url);

 

as well as replacing $url with the actual url but i'm still not getting any results.

 

[rajivgonsalves]

put these lines at the very beginning of your script and see if you get any errors/notices

ini_set('display_errors', '1');
error_reporating(E_ALL);

[el_nino]

thanks for that...ok so i now get the following error

 

Warning: file_get_contents(http://www.comp.brad.ac.uk/intranet/modules/DWT/jfs/formats.html) [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in *file location* on line 54

 

line 54 is:

echo file_get_contents($url);

 

[rajivgonsalves]

Yes that url is invalid and does not exists.

[el_nino]

it must do because if i enter the url into my address bar i can see the page

[getmizanur]

  Quote

it must do because if i enter the url into my address bar i can see the page

 

you need user name and password to access page.

 

if you can view the page through address bar then you can be able to fetch the content.

[el_nino]

problem solved... seemed to be issues with the servers at uni