Heb het onderstaande script opgeslagen als getinfo.php:
<?php
include("include/test.php");
function bla() {
/* --- Server Side Caching Functions --- */
$res = mysql_query("SELECT nr, title, gezien, type, filmId FROM film WHERE nr<003");
while($row = mysql_fetch_array($res))
{
$filmId = $row['filmId'];
$message = new xmlrpcmsg("film.retrieveDetails", array(new xmlrpcval($session_key, "string"), new xmlrpcval("$filmId", "int")));
$resp = $client->send($message);
if ($resp->faultCode()) {die();
}
else
{
$results = $resp->value();
$cover = $results["thumbnail"];
$plot = $results["plot"];
$plotq = str_replace("'", "’", $plot);
$year = $results["year"];
$genres = $results["genres_text"];
$linksite = $results["url"];
}
echo "<tr>";
echo "<td><div id='imgshow'><a href='getcover.php?coverlink' name='".$plotq."'>".$row['title']."</a></div></td>";
echo "<td class='center'>".$row['nr']."</td>";
echo "<td>".$year."</td>";
echo "<td>".$genres."</td>";
echo "<td class='center'>".$row['gezien']."</td>";
echo "<td>
<a href='wijzigenfilm.php?nr=".$row['nr']."'>
</a>
</td>";
echo "<td>".$row['type']."</td>";
echo "<td><a href='".$linksite."' target='blank'>Info</a></td>";
echo "</tr>";
}
mysql_free_result($res);
}
?>
Dit script wil ik aanroepen door middel van een andere php pagina:
<?PHP
include("getinfo.php");
bla();
?>
Maar dit werkt niet. Iemand enig idee wat ik hier fout doe? Alvast bedankt
<?php
include("include/test.php");
function bla() {
/* --- Server Side Caching Functions --- */
$res = mysql_query("SELECT nr, title, gezien, type, filmId FROM film WHERE nr<003");
while($row = mysql_fetch_array($res))
{
$filmId = $row['filmId'];
$message = new xmlrpcmsg("film.retrieveDetails", array(new xmlrpcval($session_key, "string"), new xmlrpcval("$filmId", "int")));
$resp = $client->send($message);
if ($resp->faultCode()) {die();
}
else
{
$results = $resp->value();
$cover = $results["thumbnail"];
$plot = $results["plot"];
$plotq = str_replace("'", "’", $plot);
$year = $results["year"];
$genres = $results["genres_text"];
$linksite = $results["url"];
}
echo "<tr>";
echo "<td><div id='imgshow'><a href='getcover.php?coverlink' name='".$plotq."'>".$row['title']."</a></div></td>";
echo "<td class='center'>".$row['nr']."</td>";
echo "<td>".$year."</td>";
echo "<td>".$genres."</td>";
echo "<td class='center'>".$row['gezien']."</td>";
echo "<td>
<a href='wijzigenfilm.php?nr=".$row['nr']."'>
</a>
</td>";
echo "<td>".$row['type']."</td>";
echo "<td><a href='".$linksite."' target='blank'>Info</a></td>";
echo "</tr>";
}
mysql_free_result($res);
}
?>
Dit script wil ik aanroepen door middel van een andere php pagina:
<?PHP
include("getinfo.php");
bla();
?>
Maar dit werkt niet. Iemand enig idee wat ik hier fout doe? Alvast bedankt