Include file from another website

[lumitykki]

Can somebody help me with this:

I have a script that gets 4 newest reviews from database(mysq)
and displays them at my website.

Now my partner website wants to have this top4 list at their website.

Example:

MY WEBSITE:
..
..
<?PHP
$db = mysql_connect("localhost", "**", "**");
$result_list = mysql_query("SELECT manu, mode FROM reviews where online=1 ORDER BY timestamp DESC LIMIT 0, 4",$db);
$myrow_list = mysql_fetch_array($result_list);
strcmp($result_list, '');
do{
$ma = $myrow_list["manu"];
$mo = $myrow_list["mode"];
print "$ma - $mo";
} while ($myrow_list = mysql_fetch_array($result_list));
?>
..
..
So this script displays top4 reviews at my site.

How can my partner include that script to his website?
I don't want to let my partner to know my database username/password

[jerdo]

Have your partner call the script you have created.

[lumitykki]

Originally posted by jerdo
Have your partner call the script you have created.

I don't understand what you mean by that!?

My partner wants to put that top4 list at his website. So reviews from my site(database) would also be shown at his site. (and when users clicks the review title -> he/she is forwarded to my site)

Hope this helps...

[MrAlaska]

If your partner is calling in your entire page, he could wrap it in a frame (ick) or display it in one of his page as an include (provided his server is set up to include remote files)

There is probably a more elegant answer using some type of pure XML solution or something, and you can get a lot fancier with the parsing, but this is the first thing that came to my mind when considering this question.

If he wants to control the display (which seems logical) you could provide the information to him wrapped neatly inside xml type tags, which he could parse out and display. For instance, you can have a page called remote.php where you hit your own database and echo out your information formatted something like this:

<site>
<ranking>1</ranking>
<url>http://www.mysite.com/reviews?rank=1</url>
<review>This site was REALLY rank</review>
</site>

<site>
<ranking>2</ranking>
<url>http://www.mysite.com/reviews?rank=2</url>
<review>This page sucked so bad it was good</review>
</site>

He could call it in with fopen()

Here is an example of using fopen() to pull in a remote site. This snippet calls Yahoo.com and parses out their title:

$file = fopen ("http://www.yahoo.com/", "r");
while (!feof ($file)) {
    $line = fgets ($file, 1024);
    if (eregi ("<title>(.*)</title>", $line, $out)) {
        $title = $out[1];
        break;
    }
}
fclose($file);
echo $title;