run a variable http result

[hecon]

I have a php script running querying my database table. it works fine and returns a url from the table see code:

<?
include 'config_inc.php';
include 'error_inc.php';
include 'results_inc.php';

$var = $_GET['q'] ;

$query = "SELECT shape_url FROM shape WHERE shape_id = '".$var."'";

$result = mysql_query($query);
if(mysql_num_rows($result) ==0){
echo $err[3] ,$var;
}
while($row = mysql_fetch_row($result))
{
$shape_url = $row[0];


print "shape_url : $shape_url<br>" ;
}
?>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
the result is
shape_url : http://www.adverts.hecgroup.net/search_mc/shape_45.htm
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^

I have got this code to work ok. But I want the shape_url result to be a variable in the $myfile = file('xxxxxxxxxxx.........

so that when the search result is returned it show as a htm page

<?php
$myfile = file('http://google.com');
foreach ( $myfile as $vals){
print "$vals";
}
?>

any help from any one would be good

ken

[dlite922]

Please use code tags.

I looked at your site. When you display the URLs, when the user clicks on them, instead of visiting the URL, displaying it, you want PHP to grab the contents and give it the user to download ?

[hecon]

Please use code tags.

I looked at your site. When you display the URLs, when the user clicks on them, instead of visiting the URL, displaying it, you want PHP to grab the contents and give it the user to download ?

Hi I think I understand code tags ie <var> makes this a code tags correct ?
The out come I want for my visitor is as follows

visitor searchs via a form "search box" input=text name=q where q is the variable shape-id the query returns the shape_url ie http://xxxxxxxxxxxx

All I have been able to do is display the url What I want is to open the url as a page for the vivitor to view. But the url is not constant and is linked to the var q

I want to be able to insert code to allow the http be a variable

thanks ken


does that make sence ?

[Tarantulus]

I think I know what you want

try:

$urls[]=$q; //this will add the current query to an array
foreach ( $urls as $file)
{ 
$fd=fopen($file, "r"); //this opens the URL
$contents=fread($fd,filesize($file)); //this puts the file contents into a variable
print $contents; //this prints the page
 
}
 

oh and see how my code in this post looks different? thats cos I put it in code tags, you click the # button when writing code in a new post

[hecon]

Hi Hecon or ken back again:

same problem. after querying db the result is returned AOK in the format of
http://www.adverts.hecgroup.net/search_mc/shape_url-45.htm

I have about 200 of these in the db table. I only need one return per search which what I get.

Problem is the the http in not constant ie it chages on each search result

So I need to make the result print to the code below ie chaging the url google,com for my http url for each time a search result is returned.

<?
$myfile = file('http://google.com');
foreach ( $myfile as $vals){
print "$vals";
}
?>

thanks again